Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.
All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!
SELECT DISTINCT f1 FROM table;SELECT f1 FROM table GROUP BY f1;
<table>
<tr>
<td><label>Name</label></td>
<td>
<label id="your-name-label">Your name</label>
<input type="text" style="display:hidden" id="your-name" value="Your name" />
</td>
</tr>
</table>
<script>
function toggle()
{
//Gawa kang script something to modify the style that will show and hide the labels and input boxes
}
</script>
<script type='text/javascript'>
$(document).ready(function(){
$('#id_of_toggle_button').click(function(){
$('#id_of_element_to_toggle').toggle(); //this toggles visibility on and off
});
})
</script>
$this->conn_id = mysql_connect(@$params['server'], @$params['login'], @$params['password'], TRUE) or die("CDatabase::Connect() error " . mysql_error($this->conn_id));@hakuna_matata_hm
thx po ok na konti na lang problema
Bagong tanong po..
panu po pag may error na ganito
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in.....
ito po ung code
$sql="SELECT DISTINCT tbl_salesstorename tbl_basket WHERE tbl_customername= '$usern'" . " LIMIT " . $_GET['p'] . "," . $perpage;
$query=mysql_query($sql);
$fetch= mysql_fetch_assoc( $query );
<?php
if( isset( $_POST['info'] ) )
{
$data = mysql_query( "SELECT * FROM `user` WHERE `id` = $_SESSION[id]" );
header( "Content-type: text/plain" );
exit( json_encode( @mysql_fetch_assoc( $data ) ) );
}
else if( isset( $_POST['save'] ) )
{
header( "Content-type: text/plain" );
if( mysql_query( "UPDATE `user` SET `about` = '$_POST[about]', `name` = '$_POST[name]'" ) )
exit( "Data was saved successfully" );
else
exit( "Error saving to the database." );
}
<form method="post" action="?">
About Me:<textarea name="about" id="about"></textarea>
<br />
Name: <input type="text" name="name" id="name" />
<br />
<input type="button" name="edit" value=" Edit " onclick="
var cache = this;
$( this ).attr( 'disabled', true ).unbind( 'click' );
$.post( '?', {info: true}, function( data )
{
var info = {};
try {
info = eval( '(' + data + ' )' );
} catch(e ) {}
$( '#about' ).val( info.about );
$( '#name' ).val( info.name );
$( cache ).attr( {type: 'submit', name: 'save', value: ' Save ', disabled: false} ).click( function( )
{
$.post( '?', $( this ).parent().serialize( ), function( data )
{
alert( data );
} );
} );
} );
" />
</form>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.5/jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(function()
{
$(".edit_td").click(function()
{
var ID =$(this).attr('id');
$("#edit_"+ID).hide();
$("#edit_this_"+ID).show();
}).change(function()
{
var ID=$(this).attr('id');
var name = $(this).attr('name');
var etoangvaluenginedit=$("#edit_this_"+ID).val();
var dataHere = 'id='+ ID +'&variablenyasapost='+etoangvaluenginedit+'&valuename='+name;
$("#edit_"+ID).html('<img src="images/load.gif" />');
if(etoangvaluenginedit.length>0)
{
$.ajax({
type: "POST",
url: "updatetheedit.php",
data: dataHere,
cache: false,
success: function(html)
{
$("#edit_"+ID).html(etoangvaluenginedit);
}
});
}
else
{
alert('Enter something.');
}
});
$(".textbox").mouseup(function()
{
return false
});
$(document).mouseup(function()
{
$(".textbox").hide();
$(".insidelabel").show();
});
});
</script><table><tr><td><label>Password</label></td><td id="<?php echo $id; ?>" class="edit_td"><span id="edit_<?php echo $id?>" class="insidelabel"><?php echo $row['username'];?></span><input id="edit_this_<?php echo $id?>" class="textbox" style="display:none;" type="text" name="username" value="<?php echo $row['username'];?>"/></td></tr>
<tr><td><label>Name</label></td><td id="<?php echo $id; ?>" class="edit_td"><span id="edit_<?php echo $id?>" class="insidelabel"><?php echo $row['name'];?></span><input id="edit_this_<?php echo $id?>" class="textbox" style="display:none;" type="text" name="name" value="<?php echo $row['name'];?>" /></td></tr></table><td id="1" class="edit_td">
<td id="1" class="edit_td"><?php
// here should be the server codes
if( isset( $_GET['ajax'] ) && isset( $_POST['username'] ) )
{
// ajax request must return a plain text or json
header( "Content-type: text/plain" );
// validation here
// save to the database
echo "Thanks $_POST[name]. Your information was updated successfully.";
// exit because this is an ajax request
exit;
}
// to test, the $row value is defined
$row = array (
"username" => "zidaine_38",
"name" => "Secret Agent"
);
?><!-- limit the use of <table> element -->
<style>
.hidden-input {
display: none;
}
</style>
<form method="post" action="?" id="update">
<!-- use form element for non-javascript browser like android, etc. -->
<table>
<tr>
<!-- the context here is username not password -->
<td width="100px" height="35px" valign="top"><label for="username">Username</label></td>
<!-- use for attribute for xhtml validity -->
<td width="150px" valign="top">
<span class="data"><?php echo $row['username']; ?></span>
<input type="text" class="edittable hidden-input" name="username" value="<?php echo htmlentities( $row['username'] ); ?>" />
</td>
</tr>
<tr>
<!-- Name is inappropriate. I'll use Full name here instead -->
<td height="35px" valign="top"><label>Full Name</label></td>
<td valign="top">
<span class="data"><?php echo $row['name']; ?></span>
<input type="text" class="edittable hidden-input" name="name" value="<?php echo htmlentities( $row['name'] ); ?>" />
</td>
</tr>
<!-- I added submit/ edit button for full browser support -->
<tr>
<td colspan="2" align="left">
<input type="submit" id="button" value=" Update " name="save" />
</td>
</tr>
</table>
</form>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.5/jquery.min.js"></script>
<script type="text/javascript">
// use shorthand
$( function( )
{
// get the data class elements
// these are the span elements with data
$( '.data' )
.click( function( )
{
// hide this right?
$( this ).css( 'display', 'none' );
// NOTE: dont use $( this ).hide( );
// get the next input from its parent node
// show it up by making its attribute "type" to text
$( this ).parent( ).find( 'input.edittable' )
.removeClass( 'hidden-input' )
// get focused
.focus();
} );
// get the edittble input
// when the user got out of focus from this element..
$( '.edittable' ).blur( function( )
{
// hide this by mking its attribute type to hidden
$( this ).addClass( 'hidden-input' );
// get the span class from the parent node which id the <td> element
$( this ).parent().find( 'span.data' )
// update the text content with the editted value
.text( $( this ).val( ) )
// show it by making its display property to "block"
.css( 'display', 'block' );
} );
// now for the submit button
$( '#button' )
.click( function( e )
{
// prevent the form to auto submit
e.preventDefault( );
// serialize the data so as to limit hacker attempt
// this will automatically generate post variables like: name=johndoe&username=blahblah etc.
var editted_data = $( '#update' ).serialize( );
// pass it to the server for processing
// the question mark here means "this page"
$.post( '?ajax', editted_data, function( response )
{
// let the server do the validation to limit hcker attempt
alert( response );
} );
} );
} );
</script>