whoops. I forgot I was on the php/mysql list since I was replying from
phone and it doesn't display errors. I wasn't necessarily being mean
about it, more suggesting that the php list would probably me faster and
more helpful.
On Fri, 20 Jul 2007 12:39 am, Sylvain Tousignant wrote:
> Hello Jimmy,
>
> What you are doing wrong is quite simple. You forgot to add the
> connection parameter to the mysqli_query function. And you inverted
> the order of the parameters for the musqli_select_db function.
>
> Change this line from
>
> $result = mysqli_query($con, "SELECT * FROM users;");
>
> to
>
> $result = mysqli_query("SELECT * FROM users;");
>
> also, Change this line from
>
> mysqli_select_db("criki", $con);
>
> to
>
> mysqli_select_db( $con, "criki");
>
> You really should read up on the function in the PHP Manual, otherwise
> you'll never use the entire potential of the mysqli extension.
>
> Here is the link :
> http://www.php.net/manual/en/ref.mysqli.php
>
> BTW, Gary, this is the PHP/MySQL list. While I agree that the list
> should be specific to the MySQL problems, I think that our friend Jimmy
> had a valid reason for using this list since he did have problems
> connecting to MySQL from PHP.
>
> Good luck Jimmy
>
> Sylvain.
>
>
> Gary Josack wrote:
>> this is a mysql mailing list, not php so you might want to try and
>> that one though I THINK the problem is you're trying to echo as if it
>> was an associative array.
>>
>> try to echo as row[0] and row[1]
>>
>> though this might be wrong its worth a shot ;)
>>
>> On Thu, 19 Jul 2007 2:35 pm, Jimmy Wu wrote:
>>> Thanks to all for your help,
>>>
>>> Switching to mysqli fixed the problem
>>> Now the script executes to the end (the "echo 'done';" statement), but
>>> there's still some glitches left over.
>>>
>>> The script is intended to display all rows in table users in database
>>> criki. There are two rows in that table now, but the script runs right
>>> through, displaying "hi*" from 1 to 4 with no rows displayed at all.
>>> What
>>> am I doing wrong now?
>>>
>>> Here is an updated version of the script:
>>>
>>> <?php
>>> echo "begin"."<BR/>";
>>> $con = mysqli_connect("localhost", "root", "jxywr00t");
>>> echo "hi <BR/>";
>>>
>>> if (!$con)
>>> {
>>> echo "die";
>>> die('Could not connect: ' . mysql_error());
>>> }
>>> echo "hi2 <BR>";
>>>
>>>
>>> mysqli_select_db("criki", $con);
>>> echo "hi3<BR>";
>>> $result = mysqli_query("SELECT * FROM users;");
>>> echo "hi3 A <BR>";
>>> while($row = mysqli_fetch_array($result))
>>> {
>>> echo $row['id'] . ": " . $row['username'];
>>> echo "<br />";
>>> }
>>> echo "hi4 <BR>";
>>>
>>>
>>> mysqli_close($con);
>>> echo "done";
>>> ?>
>>>
>>> Thanks,
>>>
>>> Jimmy
>>>
>>>
>>>
>>> On 7/19/07, Rick Olson <rick@stripped> wrote:
>>>>
>>>>
>>>> Jimmy Wu wrote:
>>>>> Hi
>>>>>
>>>>> I have php 5.2 installed on a Windows XP Pro, along with Apache
>>>>> 2.2 and
>>>>> MySQL 5.0
>>>>> The server (host) I'm using is localhost, and my php scripts run
>>>>> normally,
>>>>> except when trying to connect to MySQL
>>>>>
>>>>> I have the following php script
>>>>>
>>>>> <?php
>>>>> echo "begin"."<BR/>";
>>>>> $con = mysqli_connect("localhost", "root", "***********");
>>>>> echo "hi <BR/>";
>>>>>
>>>>> if (!$con)
>>>>> {
>>>>> echo "die";
>>>>> die('Could not connect: ' . mysql_error());
>>>>> }
>>>>> echo "hi2";
>>>>>
>>>>>
>>>>> mysql_select_db("cake", $con);
>>>>> echo "hi3";
>>>>> $result = mysql_query("SELECT * FROM users;");
>>>>>
>>>>> while($row = mysql_fetch_array($result))
>>>>> {
>>>>> echo $row['id'] . ": " . $row['username'];
>>>>> echo "<br />";
>>>>> }
>>>>> echo "hi4";
>>>>>
>>>>>
>>>>> mysql_close($con);
>>>>> echo "done";
>>>>> ?>
>>>>>
>>>>> I have set up the MySQL database called cake, along with the table
>>>> called
>>>>> users, with one entry in it.
>>>>>
>>>>> However, the script inexplicably stops after echoing hi2.
>>>>>
>>>>> That means it must be connecting to the mysql server alright, and
> it
>>>>> must be
>>>>> stopping at the mysql_select_db, since it never gets to hi3.
>>>>>
>>>>> I can't figure out what's wrong, and I would appreciate any
>>>>> help/suggestions.
>>>>>
>>>>> Thanks,
>>>>>
>>>>> Jimmy
>>>>>
>>>>
>>>> Hello,
>>>>
>>>> You are using mysql_* functions with a mysqli object. You need to use
>>>> the mysqli_* functions (http://www.php.net/mysqli).
>>>>
>>>> --
>>>> Rick
>>>> http://www.sensual.jp
>>>>
>>
>
> --
> MySQL PHP Mailing List
> For list archives: http://lists.mysql.com/php
> To unsubscribe: http://lists.mysql.com/php?unsub=1
