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

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

1697


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

2131


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

4329


How can manage theme in php?

2171


How can get all database name using Php and Sql?

1918






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

2329


what is main difference between array_push and array_pop?

3883


Which keyword is alias for count keyword in php?

1814


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.

2756


can we pass variable in array to traverse it?

2128


What is used of serialize and unserialize in php?

2725


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

8354


What is the best way to make wordpress plugin

2839


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.

2482


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

1766