Re: working with mysql


"Jerry Stuckle" <jstucklex@xxxxxxxxxxxxx> wrote in message
news:7--dndlSwo3IzDDZnZ2dnUVZ_oadnZ2d@xxxxxxxxxxxxxx
Auddog wrote:
"Jerry Stuckle" <jstucklex@xxxxxxxxxxxxx> wrote in message
news:AYadnQ-8XYQoojDZnZ2dnUVZ_q6dnZ2d@xxxxxxxxxxxxxx

Auddog wrote:

thanks, I should've known to place that at the top.

That being said, I still get nothing but a blank page

A



"Jerry Stuckle" <jstucklex@xxxxxxxxxxxxx> wrote in message
news:IKydnfxTcfDetTDZnZ2dnUVZ_sCdnZ2d@xxxxxxxxxxxxxx


Auddog wrote:


I have tried all of the options listed and I have even tried this code

<?php

// example using procedural approach
if(!$db=mysqli_connect('localhost','root','password','pppe')){
throw new Exception('Error connecting to host.
'.mysqli_connect_error());
}
error_reporting(E_ALL);

// display host information
echo 'Host information: '.mysqli_get_host_info($db);
// close connection
mysqli_close($db);

?>

I still get nothing but a blank page

<taofik.hidayat@xxxxxxxxx> wrote in message
news:1152174121.598411.161670@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



If Windows you've installed, please make a folder tmp, like: c:\\tmp.

Auddog wrote:



I have installed php on my server and can get the phpinfo page to
display.
I have installed mysql 5 and I'm able to get into the database and
create
data. I would like to be able to get php to pull the data. I have
been
reading on the internet as to what I need to do in php and have
created a
couple of pages. When I go to the page all I get is a blank
screen - no
data from the database.

I edited my php.ini file to allow for mysql. I copied libmysql.dll
to my
c:\windows\system32 directory. Is there anything else that I need
to do to
make mysql and php work together?

Will



If you get an error, you're throwing an exception but not catching it.

Rather, try:

error_reporting(E_ALL);
if(!$db=mysqli_connect('localhost','root','password','pppe')){
echo 'Error connecting to host. '.mysqli_connect_error());
exit();
}
... rest of code

(P.S. Please don't top post. Thanks.).


Again, please don't top post. This newsgroup uses bottom posting as a
standard.

Did you take out your throw statement and put in the echo like I asked?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@xxxxxxxxxxxxx
==================


Here is my entire code:

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
<title>Host Information</title>
</head>
<body>

<?php
error_reporting(E_ALL);

// example using procedural approach
if(!$db=mysqli_connect('localhost','root','password','ppe'))
{
echo 'Error connecting to host. '.mysqli_connect_error());
exit();
}
// display host information
echo 'Host information: '.mysqli_get_host_info($db);

// close connection
mysqli_close($db);

?>
</body>
</html>

Here's something else that I find odd. If I change the title to the web
page and save, when I bring up the page, I does not reflect the change.
I just can't figure out what is wrong.

A

ps - sorry about the top posts



OK, that's important. It means either you're loading the wrong page, or
the page is being cached - either by your browser or somewhere along the
line.

Try renaming your file to something you haven't used before and see what
happens. Also try clearing the cache in your browser.

And thanks for bottom posting!

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@xxxxxxxxxxxxx
==================

When I rename the file it doesn't load the title in either IE6 or firefox.
If I delete all the files and history in IE6, I still have the same problem.
Did I miss something in the ini file or might have I not copied all the
files to the correct location?

A


.

Relevant Pages

  • Re: working with mysql
    ... throw new Exception('Error connecting to host. ... I would like to be able to get php to pull the data. ...
    (comp.lang.php)
  • DokuWiki <= 2006-03-09brel /bin/dwpage.php remote commands execution
    ... dork: "Driven by DokuWiki" ... Usage: php '.$argv.' ... host path cmd OPTIONS ... echo 'No response from '.$host.':'.$port; die; ...
    (Bugtraq)
  • Re: working with mysql
    ... throw new Exception('Error connecting to host. ... I would like to be able to get php to pull the data. ... Did you take out your throw statement and put in the echo like I asked? ...
    (comp.lang.php)
  • Re: working with mysql
    ... throw new Exception('Error connecting to host. ... I would like to be able to get php to pull the data. ...
    (comp.lang.php)
  • Re: Cant connect to a mySQL DB
    ... I'm trying connecting to a mySQL DBm but I've some troubles. ... echo "Connecting ... ... the php page just writes: ... and then the execution stops, ...
    (comp.lang.php)