Post by jaga on Jan 6, 2012 2:05:00 GMT -8
Php mysql form insertion code/script example and view grid example
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?
include('db.php');
$query = mysql_query("SELECT * FROM messages ");
while ($data = mysql_fetch_array($query))
{
#print_r($data);exit;
foreach($data as $key => $var)
{
echo $key . ' = ' . $var . '<br />';
}
// echo '<hr />';
}
echo $query;
//print_r($query);exit;
if(is_array(mysql_fetch_assoc($query))){
foreach($query as $k=>$v){
echo "this is".$v[msg_id]." ".$v[msg]."<br />";
}
}
if(iSSet($_POST['content']))
{
$content=$_POST['content'];
mysql_query("insert into messages(msg) values ('$content')");
$sql_in= mysql_query("SELECT msg,msg_id FROM messages order by msg_id desc");
$r=mysql_fetch_array($sql_in);
}
?>
<form id="myForm" name="myForm" method="post" action="" onsubmit="liveStuff();return false;">
<table border='1'>
<tr><td>Message</td><td><input name="content" type="text"></input></td></tr>
<tr><td colspan="2"><input name="submit" id="submit" type="submit" value="Submit Ajax"></input></td></tr>
</table>
</form>
</body>
</html>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?
include('db.php');
$query = mysql_query("SELECT * FROM messages ");
while ($data = mysql_fetch_array($query))
{
#print_r($data);exit;
foreach($data as $key => $var)
{
echo $key . ' = ' . $var . '<br />';
}
// echo '<hr />';
}
echo $query;
//print_r($query);exit;
if(is_array(mysql_fetch_assoc($query))){
foreach($query as $k=>$v){
echo "this is".$v[msg_id]." ".$v[msg]."<br />";
}
}
if(iSSet($_POST['content']))
{
$content=$_POST['content'];
mysql_query("insert into messages(msg) values ('$content')");
$sql_in= mysql_query("SELECT msg,msg_id FROM messages order by msg_id desc");
$r=mysql_fetch_array($sql_in);
}
?>
<form id="myForm" name="myForm" method="post" action="" onsubmit="liveStuff();return false;">
<table border='1'>
<tr><td>Message</td><td><input name="content" type="text"></input></td></tr>
<tr><td colspan="2"><input name="submit" id="submit" type="submit" value="Submit Ajax"></input></td></tr>
</table>
</form>
</body>
</html>