Interested to Buy Any Domain ? << Click Here >> for more details...
How to Connect and Insert Record to MYSQL using PHP?
- 6 Answers
- 15161 Views
- I also Faced
- E-Mail Answers
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 |
hi sir actually i use now day's ajax but i m having problem my opinion i thing this code is right becuse i make code for my side validation with ajax in php so but it is not run complete i m posting my code pls confirm and clear my some mistake and return send me with informatiom what was error so next time i will be care fully so i m sending u but replay so quick because tomorrow i have to present it some where,frist one is index.php and second is show.php show.php is database connectivity for testing
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..
I have array like $array = array(1, "hello", 1, "world", "hello"); if i want the following output then how can i do this? Array ( [1] => 2 [hello] => 2 [world] => 1 )
How can get current system time continuously without refresh of page?
What is difference between ksort and krsort in php?
What is used of serialize and unserialize in php?
How can call any javascript function without saying onclick, onchange, onblur etc events in php?
What is used of phpinfo() function in php?
What is main difference between Cookie and Cache?
How many frameworks are in php?
If i have an array $string = array(1,2,6,2,9,6,7,3,1,2); How can i get only unique values from it? Array ( [0] => 1 [1] => 2 [2] => 6 [4] => 9 [6] => 7 [7] => 3 )
can we pass variable in array to traverse it?
PHP Code 
