Thread: How to connect MYSQL Data base on a webserver with a PHP Script

How to connect MYSQL Data base on a webserver with a PHP Script or page?

HI,
I have a website and i want to connect a database in order to get form data saved into it.
Want to do it using PHP.
Now i am looking or the basic connection process. Not the SQL syntax for queries but only to establish the connection.

Hi,

Go through this - dev.mysql.com/tech-resources/articles/ddws/21. Use html at the end of this page.

May be you can get the solution from this...

Regards,

You can connect your table to the page you want to have a database connection by clicking the Database on the dreamweaver
but before that you must first set the necessary privileges to XAMPP. Enter the necessary fields needed and then remember the
connection name and the password because it will be ask to you to input if your gonna connect it when you click the database then
database behavior. Hope it will help you.

MYSQL can be installed runs in any remote server user can connect to the local server using IP address on the privilege they have. Once connected users can manipulate the MySQL database by using different PHP commands. So first you learn about PHP commands.

Originally Posted by smith78

[B][SIZE=3]Not the SQL syntax for queries but only to establish the connection.

$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');

more on http://php.net/manual/en/function.mysql-connect.php

HI, we easily connect Server Side Scripting Language,PHP with Open Source Database System Software "MySql " ,
and here I Mention Basic code that' help you,

<?php
$connection = mysql_connect("localhost","root","");
/*
Server Name => "localhost", username => "root", Password =>" ".
$connection having Resource Data Type.
*/

if (!$connection)
{
die('We unable to Connect, Try Again !! connect: ' . mysql_error());
}

//Now before Creating Table we Must Create Data Base, then see here,

if (mysql_query("CREATE DATABASE sample_database_name",$connection))
{
echo "Your Database created, Successfully";
}
else
{
echo "Error, During creating database: " . mysql_error();
}
/*
After Creating Database We need to create Table.
*/
mysql_select_db("sample_database_name", $connection);
$sql = "CREATE TABLE sample_table_name
(
UserName varchar(15) NOT NULL,
Address varchar(15) NOT NULL,
)";

// Execute query
mysql_query($sql,$connection);
/*
After completion of task we need to close connection.
*/
mysql_close($con);
?>

and still if you Problem then Just mention here, I'll Try to Solve them.

The query is used to connect with the mysql

mysql_connect(servername, username, password);

really good question kindly take a look at following tutorials, through these tutorial u will get exactly what u want

http://www.w3schools.com/php/php_mysql_connect.asp

Learning how to connect to a MySQL database with PHP shouldn't be a difficult task.

//Connect to MySQL
$res = mysql_connect("host","username","password");
//Select database
mysql_select_db("DatabaseName");

w3school is best answer to your question look at w3school website..