You are here: Re: working with mysql « PHP Programming Language « IT news, forums, messages
Re: working with mysql

Posted by Auddog on 07/06/06 18:56

"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

 

Navigation:

[Reply to this 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

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