Using PHP to access a MySQL database

Question

I would like to access a MySQL database using PHP.

Can someone please explain the basic steps involved in doing that?

Maybe you are also interested in this: stackoverflow.com/questions/71088/… — Felix Kling
– Felix Kling, Commented Mar 14, 2010 at 9:01

Jacob Relkin · Accepted Answer · 2010-03-14 15:56:25Z

5

I would suggest that you use the mysqli extension as opposed to the old, insecure mysql extension.

First get familiar with database design, SQL and MySQL, then follow this link.

Still want an example? Here you go:

<?php
$host = 'YOUR HOSTNAME HERE';
$user = 'YOUR USERNAME HERE';
$pass = 'YOUR PASSWORD HERE';
$db_name = 'YOUR DATABASE NAME HERE';

$db = new mysqli( $host, $user, $password, $db_name );

if( $db->errno ) {
  // an error occurred.
  exit();
}
...
$sql = 'SELECT * FROM some_table;';    

$result_set = $db->query( $sql );

...fetch results...

while( $obj = $result_set->fetch_object() ) {
   $value = $obj->some_property;
   ...do something with $value...
}

$db->close();

?>

Nuff said.

Good luck!

edited Mar 14, 2010 at 15:56

answered Mar 14, 2010 at 8:49

Jacob Relkin

163k34 gold badges351 silver badges321 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jacob Relkin Over a year ago

lol theres a up arrow and a checkmark, you can click on both.

middus Over a year ago

Be aware that you probably don't want anyone else see your database errors. echo $db->error; is only a good idea while you're debugging.

Collectives™ on Stack Overflow

Using PHP to access a MySQL database

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related