|
|
Posted by Injam on 08/08/06 22:28
Rik,
I was having almost the same problem. Blank screen, could not figure
out where the problem was. But that sweet chunk of code that prints out
errors help find out where the error was.
<?php
ini_set('display_errors','On');
error_reporting(E_ALL);
?>
Thanks,
Injam
Rik wrote:
> tony wrote:
> > Rik wrote:
> >> tony wrote:
> >>
> >>> Hi guys
> >>> I'm new to PHP and I'm trying the following:
> >>>
> >>> <?php
> >>> mysqli_connect ("localhost","root","mypassword",);
> >>> mysqli_select_db (mads);
> >>> $result=mysqli_query (SELECT * FROM clients);
> >>>
> >>> print ($result);
> >>>
> >>> According to me (no great authority I know) this should print the
> >>> array from the clients table. I can execute the query from the
> >>> command line and it works fine. However, when I try to run the
> >>> script nothing happens. I've tried everything I can think of-PHP,
> >>> Mysql and Apache are all working (I can use PHPmyAdmin).
> >>>
> >>> I must be doing something wrong. What is it?
> >>
> >>
> >> 1. mysqli_select_db (mads); should be mysqli_select_db ('mads');
> >> 2. $result is a resource, not a string or array.
> >> 3. Only strings & numbers can be printed.
> >>
> >> Use mysqli_fetch_assoc($result) after your query, normally something
> >> like this:
> >> while($row = mysqli_fetch_assoc($result)){
> >> print(implode(',',$row));
> >> }
> >>
> >> Grtz,
> > Thanx for the reply Rik, unfortunatley that didn't work.
> >
> > I tried to step back a step and try the following:
> >
> > <?php
> > print ('hey there');
> > mysqli_connect ("localhost","root","Xtasy66");
> > mysqli_select_db ('mads');
> > $result=mysqli_query(SELECT * FROM clients);
> >>
> >
> > When I execute the first 3 lines I get "hey there". However, when I
> > add the last line I get nothing. My conclusion is there's somthing
> > wrong
> > with this line. The only problem is I can't see what it is.
> >
> > Can you help?
>
>
> It would mean you have a fatal error somewhere.
> Add this at the beginning of the script:
> <?php
> ini_set('display_errors','On');
> error_reporting(E_ALL);
> ?>
>
> Check which errors are reported.
>
> I've never really worked with mysqli before, because it wasn't on the
> production servers, but contrary to mysql, mysqli seems to want the explicit
> links;
> <?php
> $link = mysqli_connect ("localhost","root","Xtasy66");
> mysqli_select_db ($link,'mads');
> $result = mysqli_query($link,SELECT * FROM clients);
> ?>
>
> However, posting you password (if it's indeed you password) here is a Bad
> Idea. Please change it as soon as possible.
>
> Grtz,
> --
> Rik Wasmus
Navigation:
[Reply to this message]
|