How to Connect and Insert Record to MYSQL using PHP?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is there any way to open notepad within php?

1707


what is main difference between array_push and array_pop?

3687


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

1975


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..

2212


Which keyword is alias for count keyword in php?

1679






How can i know that how many user are visited to my page in php?

1618


What is used of serialize and unserialize in php?

2575


What is the best way to make wordpress plugin

2719


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

1570


How can export database using php code?

1583


How can manage theme in php?

2033


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

4162


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.

2643


How can get all database name using Php and Sql?

1772


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

8042