Connecting to my sql using PHP

Connecting to my sql using PHP

• 1.
  Course Instructor: NisaSoomro nisa1207@gmail.com prog_nisa@quest.edu.pk
• 2.
  With PHP, youcan connect to and manipulate databases. MySQL is the most popular database system used with PHP. 2
• 3.
   MySQL isa database system used on the web  MySQL is a database system that runs on a server  MySQL is ideal for both small and large applications  MySQL is very fast, reliable, and easy to use  MySQL supports standard SQL  MySQL works on many operating systems and with many languages including PHP, PERL, C, C++, JAVA, etc.  MySQL compiles on a number of platforms  MySQL is free to download and use  MySQL is developed, distributed, and supported by Oracle Corporation  MySQL is named after co-founder Monty Widenius's daughter: My 3
• 4.
  The data inMySQL is stored in tables. A table is a collection of related data, and it consists of columns and rows. Databases are useful when storing information categorically. A company may have a database with the following tables: Employees Products Customers Orders 4
• 5.
  PHP + MySQL PHP combined with MySQL are cross-platform (you can develop in Windows and serve on a Unix platform) 5
• 6.
  A query isa question or a request. We can query a database for specific information and have a recordset returned. Look at the following query (using standard SQL): SELECT LastName FROM Employees 6
• 7.
  7
• 8.
  8
• 9.
  9
• 10.
  10
• 11.
  Use the PHPmysqli_connect() function to open a new connection to the MySQL server. Open a Connection to the MySQL Server Before we can access data in a database, we must open a connection to the MySQL server.  In PHP, this is done with the mysqli_connect() function. Syntax mysqli_connect( host, username, password, dbname); 11
• 12.
  Syntax mysqli_connect( host,username, password, dbname); 12 Parameter Description host Either a host name or an IP address username The MySQL user name password The password to log in with dbname Optional. The default database to be used when performing queries
• 13.
  13
• 14.
  14
• 15.
  15
• 16.
  16
• 17.
  17
• 18.
  18
• 19.
  19
• 20.
  20
• 21.
  21
• 22.
  $dbc=mysqli_connect( 'localhost', "root","", "users"); 22 $query = "INSERT INTO user VALUES ( 123, 'hel88');"; mysqli_query($dbc,$query ); mysqli_close($dbc);
• 23.
   www.w3school.com Head First Php & MySQL  23