How to Connect and Insert Record to MYSQL using PHP?

Answer Posted / mukesh bisht

<?php
//var_dump($_POST);
//die();
$link=mysql_connect("localhost","root","");
$db=mysql_select_db("emp",$link);
$id=$_POST['id'];
$name=$_POST['name'];
$age=$_POST['age'];
$phone=$_POST['phone'];
$salary=$_POST['salary'];
$address=$_POST['address'];


$query="insert into db(id,name,age,phone,salary,address)
values
('".$id."','".$name."','".$age."','".$phone."','".$salary."'
,'".$address."')";
//echo $query;
mysql_query($query);
echo "<B></B>DATA ADDED SUCCESSFULLY<B></B>";
?>

Is This Answer Correct ?    22 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Given a string=”me,I,myself”; .Using javascript only create an array out of this string and then send a POST request to the url “record.php” without reloading the page. The post key parameters should be n1,n2 and n3 respectively.

2505


Which keyword is alias for count keyword in php?

1834


What is the best way to make wordpress plugin

2855


Is there any way to open notepad within php?

1848


What is 301 redirects in php? When are we used 301 redirects in our projects?

2154


How can restrict user to type upto 8 characters in textbox in php?

1721


How can manage theme in php?

2185


How can get all database name using Php and Sql?

1939


How can export database using php code?

1745


How can call any javascript function without saying onclick, onchange, onblur etc events in php?

4354


Which framework is best in php among Smarty, Cakephp, Joomla, Drupal, Zend or Something else...? If any then Why?

8391


Given a string=”me,I,myself”; .Using javascript only create an array out of this string and then send a POST request to the url “record.php” without reloading the page. The post key parameters should be n1,n2 and n3 respectively.

2775


What is used of serialize and unserialize in php?

2748


can we pass variable in array to traverse it?

2152


what is main difference between array_push and array_pop?

3913