Reply to Re: working with mysql

Your name:

Reply:


Posted by Jerry Stuckle on 07/06/06 20:53

Auddog wrote:
> "Auddog" <will_k@hotmail.com> wrote in message
> news:Xxcrg.12215$lk7.11876@tornado.rdc-kc.rr.com...
>
>>"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
>>news:7--dndlSwo3IzDDZnZ2dnUVZ_oadnZ2d@comcast.com...
>>
>>>Auddog wrote:
>>>
>>>>"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
>>>>news:AYadnQ-8XYQoojDZnZ2dnUVZ_q6dnZ2d@comcast.com...
>>>>
>>>>
>>>>>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@attglobal.net> wrote in message
>>>>>>news:IKydnfxTcfDetTDZnZ2dnUVZ_sCdnZ2d@comcast.com...
>>>>>>
>>>>>>
>>>>>>
>>>>>>>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@gmail.com> wrote in message
>>>>>>>>news:1152174121.598411.161670@b68g2000cwa.googlegroups.com...
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>>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@attglobal.net
>>>>>==================
>>>>
>>>>
>>>>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@attglobal.net
>>>==================
>>
>>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
>>
>
>
> It has to be something to do with the database connectivity as I can create
> different php pages, make changes and have it display without problems.
>
> A
>
>

No, it wouldn't have anything to do directly with database connectivity
- I suspect you have a problem in your code. Are you sure you have the
mysqli extensions loaded? Are there any messages in your error log?

Something else I just thought about - what's the value of display_errors
in your php.ini file? It needs to be on to get errors (such as missing
functions) to display in your browser.

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

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация