By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,723 Members | 1,891 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,723 IT Pros & Developers. It's quick & easy.

PHP 5 and PDO

P: n/a
I am working on converting some old PHP 4 scripts to PHP 5. I used to
use the PEAR DB module in PHP 4 and in PHP 5 I want to use PDO.

I am using this code to connect to the DB:

$dbh = new PDO('mysql:host=localhost;dbname=name', 'username',
'password');

Later on in the same page I use this code and it works just fine:

foreach($dbh->query('SELECT artist_id, artist_name FROM 10spot_artist
ORDER BY artist_name') as $row) {
$id = $row['artist_id'];
$name = stripslashes($row['artist_name']);
echo "<tr>
<td width=\"240\" height=\"35\"
background=\"images/ArtistColumnBack.gif\">
<b><font face=\"Arial\" size=\"2\"
color=\"#FFFFFF
\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp ;&nbsp;
<a href=\"Artist.php?id=$id\" style=
\"text-decoration: none\">$name</a></font></b></td>
</tr>";
}
$dbh = null;

Later on in the same page I use the following code and it doesn't
work. I don't get any errors or anything the page just stops executing
right at this code. I'm new to using PDO. Any thoughts on why this
doesn't work? Thanks in advance!

$head_sel_sql = $dbh->query('SELECT select_id, headline_id FROM
10spot_head_sel');
$headline_id = $head_sel_sql['headline_id'];
$dbh = null;

$head_display = $dbh->query('SELECT headline_id,
date, headline, headline_description FROM 10spot_headlines WHERE
headline_id = $headline_id');
$display_head =
stripslashes($head_display['headline']);
$display_date = $head_display['date'];
$display_description =
stripslashes($head_display['headline_description']);
echo "<tr>
<td><i><b><font face=\"Arial\" color=\"#BE2E2E
\">$display_head</font></b></i></td>
<td>
<p align=\"right\"><font size=\"2\" face=
\"Arial\">$display_date</font></td>
</tr>
<tr>
<td colspan=\"2\">
<font face=\"Arial\" style=\"font-size: 9pt\">
$display_description</font></td>
</tr>";
$dbh = null;

Apr 29 '07 #1
Share this Question
Share on Google+
7 Replies


P: n/a
On Sun, 29 Apr 2007 08:13:40 -0700, mpar612 wrote:
I am working on converting some old PHP 4 scripts to PHP 5. I used to
use the PEAR DB module in PHP 4 and in PHP 5 I want to use PDO.

I am using this code to connect to the DB:

$dbh = new PDO('mysql:host=localhost;dbname=name', 'username',
'password');

Later on in the same page I use this code and it works just fine:

foreach($dbh->query('SELECT artist_id, artist_name FROM 10spot_artist
ORDER BY artist_name') as $row) {
[SNAP]
}
$dbh = null;

Later on in the same page I use the following code and it doesn't
work. I don't get any errors or anything the page just stops executing
right at this code. I'm new to using PDO. Any thoughts on why this
doesn't work? Thanks in advance!

$head_sel_sql = $dbh->query('SELECT select_id, headline_id FROM
10spot_head_sel');
(assuming you posted all relevant code)

You create a PDO instance $dbh, use it, and then you destroy the object:
the next query can never be executed. Why the $dbh=null; ?
Either strip those out of your code, or re-instantiate a PDO object before
using it again.

The object will automatically be destroyed by PHP when the script ends.

HTH

Sh
Apr 29 '07 #2

P: n/a
(assuming you posted all relevant code)
>
You create a PDO instance $dbh, use it, and then you destroy the object:
the next query can never be executed. Why the $dbh=null; ?
Either strip those out of your code, or re-instantiate a PDO object before
using it again.

The object will automatically be destroyed by PHP when the script ends.

HTH

Sh
Thanks! I removed those $dbh=null; and still no luck. I know the SQL
statements are correct. They work perfectly in the code that I wrote
the code that uses the PEAR DB module. I have posted every bit of PHP
code that is on the page. All of the rest is just static HTML. Any
other thoughts? Thanks!

Apr 29 '07 #3

P: n/a

"mpar612" <mp*****@gmail.comschreef in bericht
news:11*********************@h2g2000hsg.googlegrou ps.com...
>(assuming you posted all relevant code)

You create a PDO instance $dbh, use it, and then you destroy the object:
the next query can never be executed. Why the $dbh=null; ?
Either strip those out of your code, or re-instantiate a PDO object
before
using it again.

The object will automatically be destroyed by PHP when the script ends.

HTH

Sh

Thanks! I removed those $dbh=null; and still no luck. I know the SQL
statements are correct. They work perfectly in the code that I wrote
the code that uses the PEAR DB module. I have posted every bit of PHP
code that is on the page. All of the rest is just static HTML. Any
other thoughts? Thanks!

What happens if you do a...

try
{
$dbh->query('my query');
}
catch ( PDOException $e )
{
die( $e->getMessage() . ' on line: ' . __LINE__ );
}

....for both queries?

I suspect it could have something to do with buffered queries. I've had some
occasions where I got error messages stating that I should use:

$dbh->setAttribute( PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, TRUE );

... because another query is not finished yet, eventhough for instance, only
one
row should be returned and I fetched that row already.
I haven't given it enough attention yet, and just set the attribute to true,
but it looks like it could be some bug.

HTH
Apr 29 '07 #4

P: n/a
On Sun, 29 Apr 2007 13:06:51 -0700, mpar612 wrote:
>(assuming you posted all relevant code)

You create a PDO instance $dbh, use it, and then you destroy the object:
the next query can never be executed. Why the $dbh=null; ?
Either strip those out of your code, or re-instantiate a PDO object before
using it again.

The object will automatically be destroyed by PHP when the script ends.

HTH

Sh

Thanks! I removed those $dbh=null; and still no luck. I know the SQL
statements are correct. They work perfectly in the code that I wrote
the code that uses the PEAR DB module. I have posted every bit of PHP
code that is on the page. All of the rest is just static HTML. Any
other thoughts? Thanks!
You're welcome.

Sorry, I am not even remotely familiar with PDO's intricacies. Any attempt
to say something meaningful about it on my part would be a waste of group
space.

Amygdala seems to have at least some experience with PDO, he's your man!
Signing off on this one.
Rgds
Sh.
Apr 29 '07 #5

P: n/a
On Apr 29, 4:12 pm, "amygdala" <nore...@noreply.comwrote:
"mpar612" <mpar...@gmail.comschreef in berichtnews:11*********************@h2g2000hsg.goo glegroups.com...
(assuming you posted all relevant code)
You create a PDO instance $dbh, use it, and then you destroy the object:
the next query can never be executed. Why the $dbh=null; ?
Either strip those out of your code, or re-instantiate a PDO object
before
using it again.
The object will automatically be destroyed by PHP when the script ends.
HTH
Sh
Thanks! I removed those $dbh=null; and still no luck. I know the SQL
statements are correct. They work perfectly in the code that I wrote
the code that uses the PEAR DB module. I have posted every bit of PHP
code that is on the page. All of the rest is just static HTML. Any
other thoughts? Thanks!

What happens if you do a...

try
{
$dbh->query('my query');}

catch ( PDOException $e )
{
die( $e->getMessage() . ' on line: ' . __LINE__ );

}

...for both queries?

I suspect it could have something to do with buffered queries. I've had some
occasions where I got error messages stating that I should use:

$dbh->setAttribute( PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, TRUE );

.. because another query is not finished yet, eventhough for instance, only
one
row should be returned and I fetched that row already.
I haven't given it enough attention yet, and just set the attribute to true,
but it looks like it could be some bug.

HTH
Thanks for the response! That didn't do anything, but return a blank
screen. I did a little playing around and the first statement works.
If I comment out that query and enter a hard value into the 2nd query,
it works. So, I think I need to figure out how to close the first
query so the 2nd query can execute. Does that make sense? Any
thoughts?

Thanks!

Apr 29 '07 #6

P: n/a

"mpar612" <mp*****@gmail.comschreef in bericht
news:11**********************@h2g2000hsg.googlegro ups.com...
On Apr 29, 4:12 pm, "amygdala" <nore...@noreply.comwrote:
>"mpar612" <mpar...@gmail.comschreef in
berichtnews:11*********************@h2g2000hsg.go oglegroups.com...
>(assuming you posted all relevant code)
>You create a PDO instance $dbh, use it, and then you destroy the
object:
the next query can never be executed. Why the $dbh=null; ?
Either strip those out of your code, or re-instantiate a PDO object
before
using it again.
>The object will automatically be destroyed by PHP when the script
ends.
>HTH
>Sh
Thanks! I removed those $dbh=null; and still no luck. I know the SQL
statements are correct. They work perfectly in the code that I wrote
the code that uses the PEAR DB module. I have posted every bit of PHP
code that is on the page. All of the rest is just static HTML. Any
other thoughts? Thanks!

What happens if you do a...

try
{
$dbh->query('my query');}

catch ( PDOException $e )
{
die( $e->getMessage() . ' on line: ' . __LINE__ );

}

...for both queries?

I suspect it could have something to do with buffered queries. I've had
some
occasions where I got error messages stating that I should use:

$dbh->setAttribute( PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, TRUE );

.. because another query is not finished yet, eventhough for instance,
only
one
row should be returned and I fetched that row already.
I haven't given it enough attention yet, and just set the attribute to
true,
but it looks like it could be some bug.

HTH

Thanks for the response! That didn't do anything, but return a blank
screen. I did a little playing around and the first statement works.
If I comment out that query and enter a hard value into the 2nd query,
it works. So, I think I need to figure out how to close the first
query so the 2nd query can execute. Does that make sense? Any
thoughts?

Thanks!
Now that I took a closer look at the code, is this the following really the
code you're using for the second query?

$head_display = $dbh->query('SELECT headline_id,
date, headline, headline_description FROM 10spot_headlines WHERE
headline_id = $headline_id');

If so, you should use " (double quotes), instead of ' (single quotes) to
let PHP evaluates the variable $headline_id.

HTH
Apr 30 '07 #7

P: n/a
On Apr 29, 8:33 pm, "amygdala" <nore...@noreply.comwrote:
"mpar612" <mpar...@gmail.comschreef in berichtnews:11**********************@h2g2000hsg.go oglegroups.com...
On Apr 29, 4:12 pm, "amygdala" <nore...@noreply.comwrote:
"mpar612" <mpar...@gmail.comschreef in
berichtnews:11*********************@h2g2000hsg.goo glegroups.com...
(assuming you posted all relevant code)
You create a PDO instance $dbh, use it, and then you destroy the
object:
the next query can never be executed. Why the $dbh=null; ?
Either strip those out of your code, or re-instantiate a PDO object
before
using it again.
The object will automatically be destroyed by PHP when the script
ends.
HTH
Sh
Thanks! I removed those $dbh=null; and still no luck. I know the SQL
statements are correct. They work perfectly in the code that I wrote
the code that uses the PEAR DB module. I have posted every bit of PHP
code that is on the page. All of the rest is just static HTML. Any
other thoughts? Thanks!
What happens if you do a...
try
{
$dbh->query('my query');}
catch ( PDOException $e )
{
die( $e->getMessage() . ' on line: ' . __LINE__ );
}
...for both queries?
I suspect it could have something to do with buffered queries. I've had
some
occasions where I got error messages stating that I should use:
$dbh->setAttribute( PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, TRUE );
.. because another query is not finished yet, eventhough for instance,
only
one
row should be returned and I fetched that row already.
I haven't given it enough attention yet, and just set the attribute to
true,
but it looks like it could be some bug.
HTH
Thanks for the response! That didn't do anything, but return a blank
screen. I did a little playing around and the first statement works.
If I comment out that query and enter a hard value into the 2nd query,
it works. So, I think I need to figure out how to close the first
query so the 2nd query can execute. Does that make sense? Any
thoughts?
Thanks!

Now that I took a closer look at the code, is this the following really the
code you're using for the second query?

$head_display = $dbh->query('SELECT headline_id,
date, headline, headline_description FROM 10spot_headlines WHERE
headline_id = $headline_id');

If so, you should use " (double quotes), instead of ' (single quotes) to
let PHP evaluates the variable $headline_id.

HTH
Thanks! It actually turned out to be an issue with my end. You need
to end the query() before you can begin using another one. Got it
figured out. Thanks again!

Apr 30 '07 #8

This discussion thread is closed

Replies have been disabled for this discussion.