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
What are php libraries?
Why do we show php code in browser?
What are the characteristics of php?
Is c similar to php?
What are traits?
What is the array in php?
What are the advantages of using php?
Which function is used to read a single character from a file in PHP.
What is mysqli php?
What is form action php?
How do I use isdigit function?
Explain how you can update memcached when you make changes to php?
What are the features of php 7?
What are php strings?
Do you have to initialize variables in php?
