|
|
Posted by eholz1 on 11/21/06 17:09
Hello Again,
Thanks for checking my post. Well, as to errors - I am not getting
any. I will double check the php page that is supposed to access the
db.
I do a "SELECT * FROM pet" and display about 10 records. I will double
check to see if I do any error checking, etc.
Below is the php code to connect to the database:
<table class="maintable" border=1>
<tr class="rowbar"><th>Pet Name</th><th>Owner</th><th>Pet
Type</th><th>Gender</th><th>Date of Birth</th></tr>
<?php
// connect
require_once('DB.php');
$db = DB::connect("mysql://abc:password@myserver/menagerie");
$dbhost = 'myserver';
$dbuser = 'abc';
$dbpass = 'password';
if (DB::iserror($db))
die($db->getMessage());
//else
// echo 'Congratulatons! Connected to Database!<br></br>';
?><!--center-->
<?php
$sql = "SELECT * FROM pet";
$q = $db->query($sql);
if (DB::iserror($q)) {
die($db->getMessage());
}
// generate the table
while ($q->fetchInto($row)) {
?>
<tr>
<td><?= $row[0] ?></td>
<td><?= $row[1] ?></td>
<td><?= $row[2] ?></td>
<td><?= $row[3] ?></td>
<td><?= $row[4] ?></td>
</tr>
<?php }
?>
</table></center>
This code works fine when I am running the older Apache (2.0), and PHP
4.3.9.
Thanks,
eric
On Nov 20, 6:44 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> Eric wrote:
> > Jerry Stuckle wrote:
>
> >> eholz1 wrote:
>
> >>> Hello Newsgroup,
> >>> I have redhat 3.0 Enterprise, and mysql (3.58.xxx more or less)
> >>> installed from a redhat rpm,
> >>> and php 4.3.9 (installed from an rpm) - I can access data from my mysql
> >>> db using php and the "pear" Db .php. I recently upgraded my Apache to
> >>> 2.2 and installed (more or less) PHP 5.2 as well - neither of these
> >>> installs were from a Redhat rpm, I downloaded the tarballs, extracted,
> >>> configed, make, etc.
> >>> Apache seems to work fine (but not with the php 4.3.9 rpm). I set the
> >>> httpd.conf file to access php 5 (libphp5.so) and can display PHP 5.2.0
> >>> info using phpinfo(). But... I cannot access any data in my mysql
> >>> database (/usr/local/share/DB.php) from the "pear". And it does not
> >>> appear that phpinfo() is reading the php.ini file. I have two php.ini
> >>> files, one in /etc (redhat rpm location), and another in
> >>> /usr/local/lib/php.ini. I have edited and changed both these files,
> >>> but the "changed" items (like default
> >>> mysql.socket=/var/lib/mysql/mysql.sock) do not show up in the phpinfo()
> >>> page. I have even renamed each php.ini file so there is no php.ini
> >>> file (like php_ini), and the phpinfo() data still displays! this is in
> >>> php 5.2.0. In 4.3.9 - all is well - the file (/etc/php.ini) is read,
> >>> etc, and I can access the db.
>
> >>> I have attempted to set the PHP 5.2 switch to the location where my
> >>> mysql binary is (/usr/bin/mysql), but still nothing seems to work. My
> >>> guess is that I am not selecting the correct place for PHP 5.2 to hook
> >>> up with my already installed (but old) redhat my sql rpm.
>
> >>> Any ideas on how I can get PHP 5.2 to work with my version of mysql?
> >>> Or should I remove the existing mysql rpm, and start fresh with a later
> >>> version of mysql - and install it from tarball, etc Then I would at
> >>> least know where the mysql stuff is. Redhat seems to spread the
> >>> package info all over the place.
>
> >>> Help!
>
> >>> eric jones
>
> >> What does phpinfo() show for the path to your php.ini file?
>
> > Hello I did check the location - and moved the php.ini file to this
> > location - /usr/local/apache2/php/lib - now it reads the file (php).
>
> > I still am unable to connect to the db -my my.cnf file seems ok.
> > I will make a change to my php page that accesses the db.
>
> > If I run the older version of apache (2.0) and php 4.3.9 - all is well -
> > i can diplay data on the php page.
>
> > any ideas here???
>
> > Thanks,
>
> > eholz1It would help if you would tell us what errors you're getting.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstuck...@attglobal.net
> ==================
Navigation:
[Reply to this message]
|