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
Tell me what kind of things have you done on the social side?
What is the difference between htmlentities() and htmlspecialchars()?
What sized websites have you worked on in the past?
sort term descripttion form, report and uery
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
What is the current stable version of php?
What does $_files means?
how to detect a mobile device using php
Name and explain five of the PHP error constants?
Write a program using while loop?
How to calculate the difference between two dates using php?
How to create a web form?
Explain me is it possible to destroy a cookie?
What is difference between static and final in php?
List some features of php that are deprecated in php7?
