I'm still a beginner in the PHP so I need your help ... I have a small database Containing
- id & content & links
I want to retrieve the content data using the id . so I need the php code which could help me
2
-
2Plz send me teh codez ? There are plenty tutorials out there on how to do this. Try doing a few, and if you run into an actual problem, people here will be happy to help you.Valentin Flachsel– Valentin Flachsel2010-09-26 09:10:01 +00:00Commented Sep 26, 2010 at 9:10
-
php.net/manual/en/book.mysql.php happy reading.Bertrand Marron– Bertrand Marron2010-09-26 09:14:31 +00:00Commented Sep 26, 2010 at 9:14
Add a comment
|
3 Answers
<?php
mysql_connect("localhost", "dbuser", "dbpass");
mysql_select_db("dbname");
$id = 5;
$q = mysql_query("SELECT * FROM table_name WHERE id = {$id}");
$r = mysql_fetch_object($q);
echo $r->links;
?>
Supposing you need to get only one row from table.
Comments
if your database is mySQL
read http://www.w3schools.com/PHP/php_mysql_connect.asp
and
http://www.novaksblog.com/2007/10/02/database-connection-with-php/
Comments
Object oriented approaches:
PDO:
- http://php.net/manual/en/book.pdo.php
- PDO tutorial: http://www.phpro.org/tutorials/Introduction-to-PHP-PDO.html#1
ADOdb:
