Hi....
<html>
<head>
<title>Girfa Saving Record on PHP Server</title>
<?php
if($_GET['name1'])
demo();
function demo()
{
$con=mysql_connect("localhost","girfa","12345") or die("Could not open the database ");
mysql_select_db("basant_bsw",$con);
$roll=$_GET['roll'];
$nm=$_GET['name'];
$ct=$_GET['city'];
$quary="insert into stu values('$roll','$nm','$ct')" or die("error in making sql");
mysql_query($quary,$con) or die("unable to run sql quary");
}
?>
</head>
<body>
<form name="form1" method="get" action="<?php $_PHP_SELF ?>">
Roll : <input type="text" name="roll" /><br />
Name : <input type="text" name="name" /><br />
City : <input type="text" name="city" /><br />
<input type="submit" value="save" name="name1" />
</form>
</body>
</html>
I spend lot of time to achieve this. I Searched many website but didn’t
find a proper way which help me to do this. Then I use php manual which help me
to find my solution.
Mostly we use mysql_connect("localhost","root","")
this will work on client side where you develop your application. You just have
to change the format of mysql_connect() function and rest of the thing will be same as
you used to on your client.
mysql_connect("localhost","Girfa","12345")
Girfa is your user name and 12345 is password of your website. Which
you got when launch your website.
<html>
<head>
<title>Girfa Saving Record on PHP Server</title>
<?php
if($_GET['name1'])
demo();
function demo()
{
$con=mysql_connect("localhost","girfa","12345") or die("Could not open the database ");
mysql_select_db("basant_bsw",$con);
$roll=$_GET['roll'];
$nm=$_GET['name'];
$ct=$_GET['city'];
$quary="insert into stu values('$roll','$nm','$ct')" or die("error in making sql");
mysql_query($quary,$con) or die("unable to run sql quary");
}
?>
</head>
<body>
<form name="form1" method="get" action="<?php $_PHP_SELF ?>">
Roll : <input type="text" name="roll" /><br />
Name : <input type="text" name="name" /><br />
City : <input type="text" name="city" /><br />
<input type="submit" value="save" name="name1" />
</form>
</body>
</html>
No comments:
Post a Comment