List:General Discussion« Previous MessageNext Message »
From:Michael Chang Date:April 25 2002 3:10am
Subject:RE: PHP and MySQL help please !
View as plain text  
> I am not sure if the include statement is design to add mysql BINARIES or
> SOURCE CODE ??
Neither.  It's eventually going to link the final php binary with
the mysql shared libraries (probably libmysqlclient).
I'm not too familiar with PHP, so I don't know if '--with-mysql=' wants
the location of the MySQL root directory (typically /usr/local/mysql for
source installations) or the directory that contains the libraries (like
above, but /usr/local/mysql/lib).  

Check to see if /usr/local/mysql exists first.
Better yet, try this:
  find /usr -name libmysqlclient*

Hopefully, it will show you the location of one (or more) MySQL client
libraries.
Start there.


Michael



On Thu, 25 Apr 2002, Andrew Rich wrote:

> Fatal Error: Call to undefined function: mysql_connect() in
> /var/www/html/results.php
> 
> + I think my PHP does not have mysql included, although I put in the
> ./configure --with mysql=/usr/local/mysql \
> + When I type "which mysql" it says "/usr/bin/msql"
> + So should I put:-
> 
>    ./configure --with-mysql=/usr/local/mysql OR
> ./configure --with-mysql=/usr/bin/mysql
> 
> ?????
> 
> I am not sure if the include statement is design to add mysql BINARIES or
> SOURCE CODE ??
> 
> Lost.
> 
> Andrew
> 
> -----Original Message-----
> From: Andrew Rich [mailto:andrew.rich@stripped]
> Sent: Thursday, 25 April 2002 11:28 AM
> To: Andrew Rich; mysql@stripped
> Subject: RE: PHP and MySQL help please !
> 
> 
> Further to this, I removed the "@" symbol and got:-
> 
> Fatal Error: Call to undefined function: mysql_connect() in
> /var/www/html/results.php
> 
> @ $db = mysql_pconnect("localhost", "user", "password");
> 
> $db = mysql_pconnect("localhost", "user", "password");
> 
> 
> Ideas ? Why is it  now a undefined function ?
> 
> Andrew
> -----Original Message-----
> From: Andrew Rich [mailto:andrew.rich@stripped]
> Sent: Thursday, 25 April 2002 11:14 AM
> To: mysql@stripped
> Subject: PHP and MySQL help please !
> 
> 
> + PHP Installed and going - I can write to files, retrieve flatfiles
> + Apache running servers outpages nop probes
> 
> Trying to talk to SQL using PHP.
> ----------------------------------------------------------------------------
> ----------
> <html>
> <body>
> <h1>Go to SQL now</h1>
> <?
> echo "looking";
>    @ $db = mysql_pconnect("localhost", "user", "password");
>   if (!$db);
>   {
>      echo "Error: Could not connect to database.  Please try again later.";
>      exit;
>   }
>   mysql_select_db("test");
>   $query = "select * from logbook" ;
>   $result = mysql_query($query);
>   $num_results = mysql_num_rows($result);
>   echo "<p>Number of books found: ".$num_results."</p>";
> ?>
> </body>
> </html>
> ----------------------------------------------------------------------------
> -------------
> What gets me if I can do all this from the mysql prompt:-
> laptop>mysql -u user -p (enterpassword gets me in)
> mysql>use test;  OK
> mysql>select * from logbook;  OK (shows entries no probs);
> ----------------------------------------------------------------------------
> -------------
> What am I doing wrong ?
> 
> It doesnt get past the
> 
>  @ $db = mysql_pconnect("localhost", "user", "password");
> 
> in the code.
> 
> ??????????????
> 
> Andrew
> 
> 
> 
> 
> -------------------------------------------
> Andrew Rich
> Callsign: VK4TEC
> andrew.rich@stripped
> www.users.bigpond.com/andrew.rich/vk4tec.htm
> 
> 
> 
> 
> -------------------------------------------
> Andrew Rich
> Callsign: VK4TEC
> andrew.rich@stripped
> www.users.bigpond.com/andrew.rich/vk4tec.htm
> 
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <mysql-thread107050@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-andrew.rich=bigpond.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <mysql-thread107058@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-miranda=uranus.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 

-- 
/*--------------------------------------------------------------------------
* "It might look like I'm doing nothing, but at the cellular level
* I'm really quite busy."
*  ---anonymous
*
*
* -----BEGIN GEEK CODE BLOCK-----
* Version: 3.1
* GCS/P/H/L/O d- s-:-- a26 C++(+++) UL+++$>++++ P++ L+++ !E W+++ N- o? K-
* w--(---) !O M+ !V PS+ PE- Y-- PGP- t+ 5-(--) X(-) R* tv b+ DI-- D-- G e+>++
* h+ r* y--
* ------END GEEK CODE BLOCK------
--------------------------------------------------------------------------*/

Thread
PHP and MySQL help please !Andrew Rich25 Apr
  • RE: PHP and MySQL help please !Andrew Rich25 Apr
    • RE: PHP and MySQL help please !Andrew Rich25 Apr
      • RE: PHP and MySQL help please !Michael Chang25 Apr
    • Re: PHP and MySQL help please !Jan-Michael Ong25 Apr