How to Connect and Insert Record to MYSQL using PHP?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / satyajit das
$conn = mysql_connect("localhost","root","");
mysql_select_db("database_name",$conn); // Connection....
if($hh){
$res = mysql_query("insert into `table`(`all
paramaeters of table`)values('','','')");
}
$res1 = mysql_query("select * from `table`");
// Insert Module....
Is This Answer Correct ? | 16 Yes | 6 No |
Answer / pinal
<?php
$Con = mysql_connect("$vHostName","$vUserName","$vPassword");
if(!$Con ) {
die("<html><script language = 'Javascript'>alert('unable
to connecet to the db ... bcause'". mysql_error().
")</script></html>");
}
mysql_select_db("$dbName",$Con);
?>
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sudhanshu
To
Connect="$dblink=mysql_connect("127.0.0.1","mediamagick","mediamagick");
$db_conn=mysql_select_db("mediamagick_italy",$dblink)or
die("could not connect");"
And To Insert = "Select (Field Names) values (values to
insert )";
Is This Answer Correct ? | 4 Yes | 5 No |
Answer / anirban paul
<?php
->connection parts-------
mysql_connect("<webser-name>","user-name","password-name");
mysql_select_db("<database-name>");
->insertion parts--------
$r=mysql_query("insert into <table-name> values(fild
name)");
if($r)
{
print "<h1>insert successfully";
}
else
{
print"<h1>insert not successfully";
}
Is This Answer Correct ? | 3 Yes | 6 No |
Answer / ra-j-an
<?php
$dbCon = mysql_connect("$vHostName","$vUserName","$vPassword");
if(!$dbCon ) {
die("<html><script language = 'Javascript'>alert('unable
to connecet to the db ... bcause'". mysql_error().
")</script></html>");
}
mysql_select_db("$dbName",$dbCon);
?>
Is This Answer Correct ? | 2 Yes | 5 No |
What is the best way to make wordpress plugin
How to Connect and Insert Record to MYSQL using PHP?
What is difference between in_array and array_search?
How can i know that how many user are visited to my page in php?
can we pass variable in array to traverse it?
How can call any javascript function without saying onclick, onchange, onblur etc events in php?
How can manage theme in php?
What is 301 redirects in php? When are we used 301 redirects in our projects?
How many frameworks are in php?
I am attempting to work on a game panel with multi-server support, so in one of the pages there is a dropdown menu with servers on it, this is the part i am having issues with is server 1 is chosen i need access to the username running a script to server 1 chosen i need a script that will realize its been chosen and pop up below with a username thats associated with it because the users differ on each server so i choose server 1 i need a code to pull from the db and choose the user associated with the said server please help..
How can export database using php code?
What is meant by 404 errors in php?