Hi All,
Using this code you can save data to a table with auto generated ID in PHP.
--------------------------
Table
CREATE TABLE IF NOT EXISTS `hashtag` (
`hid` int(11) NOT NULL,
`tag` text NOT NULL,
`description` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
---------------------------
<html>
<body>
<?php
mysql_connect("localhost","root","");
mysql_select_db("tcsr");
$sql1="select max(hid) as mid from hashtag ";
$data1=mysql_query($sql1);
$id=0;
while($row=mysql_fetch_array($data1))
{
$id=$row['mid'];
}
$id=$id+1;
echo $id;
?>
<form name="frm" method=post enctype="multipart/form-data" >
<pre>
Id <input type="text" value="<?php echo $id; ?>" disabled=disabled name="hid" /> <input name="hid1" type="hidden" value="<?php echo $id; ?>" />
HashTag <input type="text" name="hashtag" />
Description <input type="text" name="description" />
<input name="hsubmit" type="submit" value="Upload files" />
</form>
<?php
echo "entered";
if(isset($_POST['hsubmit']))
{
echo "Entered";
$hid=$_POST['hid1'];
$hashtag=$_POST['hashtag'];
$desc=$_POST['description'];
$sql="insert into hashtag values('$hid','$hashtag','$desc')";
echo $sql;
$result=mysql_query($sql);
}
?>
</body>
</html>
Using this code you can save data to a table with auto generated ID in PHP.
--------------------------
Table
CREATE TABLE IF NOT EXISTS `hashtag` (
`hid` int(11) NOT NULL,
`tag` text NOT NULL,
`description` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
---------------------------
<html>
<body>
<?php
mysql_connect("localhost","root","");
mysql_select_db("tcsr");
$sql1="select max(hid) as mid from hashtag ";
$data1=mysql_query($sql1);
$id=0;
while($row=mysql_fetch_array($data1))
{
$id=$row['mid'];
}
$id=$id+1;
echo $id;
?>
<form name="frm" method=post enctype="multipart/form-data" >
<pre>
Id <input type="text" value="<?php echo $id; ?>" disabled=disabled name="hid" /> <input name="hid1" type="hidden" value="<?php echo $id; ?>" />
HashTag <input type="text" name="hashtag" />
Description <input type="text" name="description" />
<input name="hsubmit" type="submit" value="Upload files" />
</form>
<?php
echo "entered";
if(isset($_POST['hsubmit']))
{
echo "Entered";
$hid=$_POST['hid1'];
$hashtag=$_POST['hashtag'];
$desc=$_POST['description'];
$sql="insert into hashtag values('$hid','$hashtag','$desc')";
echo $sql;
$result=mysql_query($sql);
}
?>
</body>
</html>
No comments:
Post a Comment