how to fetch data with PDO

Question

0.00/5 (No votes)

See more:

Hi all, hope all is well?

Please am new to this PDO thingy, how can I fetch data from my database just like this Mysql query below

PHP

<?php

include ("connect.php");


$email=@$_POST["email"];

$sql="SELECT sname,fname FROM user_db WHERE email='$email' ";
	$result=mysql_query($sql);

// Mysql_num_row is counting table row

$count=mysql_num_rows($result);

if($count==1){
	
$info=mysql_fetch_array($result);


$sname=$info['sname'];

$fname=$info['fname'];


}
else{
	
	echo "user details not found";
	
	}

?>

And how can I put the connection string of the PDO in another file and import and use it when need? Thanks

Posted 10-Jul-13 11:15am

tarhex

Add a Solution

Comments

enhzflep 10-Jul-13 17:43pm

What have you tried, where are you stuck? There are 474,000 results for the google search "pdo php tutorial"

tarhex 10-Jul-13 17:53pm

which is the best to use:

fetch_assoc or fetch_both or fetch_num

enhzflep 10-Jul-13 18:14pm

You replied to yourself. You need to hit the ( <- Reply ) button to the right of a comment, or the ( Have a Question or Comment? ) button to respond to a solution or a question.

That aside, No context given, no reasonable answer possible. I don't use any of the three, generally. When I do, it's whatever is the default.

enhzflep 10-Jul-13 19:02pm

You replied to yourself. You need to hit the ( <- Reply ) button to the right of a comment, or the ( Have a Question or Comment? ) button to respond to a solution or a question.

tarhex 10-Jul-13 19:46pm

ok, thanks for the hint.

query($sql) or die("failed!");

$r = $q->fetch(PDO::FETCH_BOTH);

echo $r['userid']; ?>

In the place of fetch, I found out that fetch_assoc or fetch_both and some others can be used, they all produce the same result and I can't seem to find the difference.</xml?-->

enhzflep 10-Jul-13 20:00pm

You're welcome.
Now then. You need to start reading the documentation. Being able to find the relevant information in the documentation is one of your most important skills as a software developer..

Reading from PDOStatement::fetch

"PDO::FETCH_ASSOC: returns an array indexed by column name as returned in your result set

PDO::FETCH_BOTH (default): returns an array indexed by both column name and 0-indexed column number as returned in your result set"

Seems perfectly clear to me..
I.e - with assoc, you can index the result array _only_ by using the column name.
With fetch_both, you can index with _either_ it's 0-based column number or the column name.

I suggest you download the php manual. The standard (CHM) edition is ~10MB, while the enhanced edition (includes user comments from the php website) is ~28MB. There are many, many, many useful tips in the user-contributed notes. Often, they're more helpful than the official docs.

You can goto the PHP documentation page here: PHP Documentation download page
NOTE: As the page says, currently the CHM builds are broken and not available there. You can probably just wait or get it from elsewhere. The copy I have is called php_enhanced_en.chm - 28.6 MB (30,072,065 bytes)

tarhex 10-Jul-13 20:26pm

thanks, bro. I appreciates

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)