Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / dev
for database connectivity
<?php
$con = mysql_connect("localhost","your database username
here","your database password here") or die("could
not connect".mysql_error());
$db = mysql_select_db("your database name here") or die
("could not select db".mysql_error());
?>
insert into a table
$sql_query= "insert into your table name here(table fields
name here)
values(Fields values here)";
$result = mysql_query($sql_query);
?>
FOR EXAMPLE....
<?php
//for database connectivity
$con = mysql_connect("localhost","peter","123456");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("my_db", $con); // select a database
$firstname=$_POST['firstname'];
$lastname = $_POST['lastname'];
// insert into a table
mysql_query("INSERT INTO Persons (FirstName, LastName)
VALUES ('$firstname','lastname ')");
mysql_close($con);
?>
<html>
<body>
<form action="insert.php" method="post">
Firstname: <input type="text" name="firstname" />
Lastname: <input type="text" name="lastname" />
<input type="submit" />
</form>
</body>
</html>
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Are php session secure?
List few sensible functions in PHP?
if you run the app program all vendor open items are cleared but is it possible to reverse the again again open items please tell me the answer
Steps for the payment gateway processing?
Tell me can you extend a final defined class?
How to open a file for writing?
What are the php functions?
What type of operation is needed when passing values through a form or an url?
Why framework is used in php?
What are the functions of string?
What is php full form?
How to read and display a HTML source from the website url?
How to increase the execution time of a PHP script?
Which function is used to strip whitespace?
What is php artisan tinker?
