Interested to Buy Any Domain ? << Click Here >> for more details...
How to Connect and Insert Record to MYSQL using PHP?
- 6 Answers
- 15172 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 |
How to Connect and Insert Record to MYSQL using PHP?
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 )
What is main difference between Cookie and Cache?
1)how i get the current system time using php?
How can get all database name using Php and Sql?
how to validation ajax in php with database actually i use here it give some time erroe so pls tell how to do right and second think is that textfeild phone number it accept only int value not charecter so tell me both and my code is that so check it then send after correction
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
Which keyword is alias for count keyword 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 )
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 get current system time continuously without refresh of page?
How can export database using php code?
PHP Code 
