How to query MySQL Database and display its search results by PHP?

Question

I am new to PHP and MySQL, can I get a smiple example of how to write the connection string, getting the results from a table with some columns and displaying them? Thank you!

I know I am being a JERK, but have you just tried googling "php mysql example"? This thing is OVER documented. — Jakub
– Jakub, Commented Nov 11, 2010 at 13:05
Google is still better than SO for such questions... if SO is better, then google will show you SO... means Google is always better for such questions. — markus
– markus, Commented Nov 11, 2010 at 13:26

Pekka · Accepted Answer · 2010-11-11 13:08:48Z

2

The PHP manual has full working examples.

For the mysql_* functions: Full examples here
For PDO (a bit more complicated, but more modern and the preferable approach - use this if at all possible): Full examples here
For mysqli: Full examples here

edited Nov 11, 2010 at 13:08

answered Nov 11, 2010 at 12:59

Pekka

451k150 gold badges989 silver badges1.1k bronze badges

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

2 Comments

Stephen Over a year ago

I'm curious, why do you recommended mysqli for smaller projects?

Pekka Over a year ago

@Stephen ah humbug, I mixed it up with mysqlite - I'm not very familiar with both. Time for lunch :) Fixed, cheers.

Stephen · Accepted Answer · 2010-11-11 13:00:54Z

0

http://php.net/mysql_connect
http://php.net/mysql_select_db
http://php.net/mysql_query

in that order. :)

answered Nov 11, 2010 at 13:00

Stephen

19k10 gold badges62 silver badges98 bronze badges

Collectives™ on Stack Overflow

How to query MySQL Database and display its search results by PHP?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related