how do i insert data to mysql
Posted: Tue Aug 13, 2002 5:10 am
<?php
$db=mysql_connect("127.0.0.1","hi","getche");
mysql_select_db("jawab",$db);
if ((isset($jname)) AND (isset($jemail))) {
$sql="INSERT INTO jawab VALUES('$jid','$jname','$jemail','$jdate','$jcomment')";
$result=mysql_query($sql,$db);
$jdate=date(M,d,Y);
echo "data inserted";
}
?>
<form method=POST action="/jawab/index.php">
<INPUT TYPE="text" NAME="jname">
<br>
<input type=text name=jemail ><br>
<textarea cols=30 rows=8 name=jcomment ></textarea>
<input type=submit name=submit value=add>
</form>
i am using this but it is not working plz help me
$db=mysql_connect("127.0.0.1","hi","getche");
mysql_select_db("jawab",$db);
if ((isset($jname)) AND (isset($jemail))) {
$sql="INSERT INTO jawab VALUES('$jid','$jname','$jemail','$jdate','$jcomment')";
$result=mysql_query($sql,$db);
$jdate=date(M,d,Y);
echo "data inserted";
}
?>
<form method=POST action="/jawab/index.php">
<INPUT TYPE="text" NAME="jname">
<br>
<input type=text name=jemail ><br>
<textarea cols=30 rows=8 name=jcomment ></textarea>
<input type=submit name=submit value=add>
</form>
i am using this but it is not working plz help me