[PHP] mysql blob and phpmysqladmin

[Jianping Zhu]

I have mysql table call com. One colum of table com will store
user's comments. Because user-provided comment might be too big to fit in char(255), i
use blob. but when i try to see it by use phpmysqladmin, i can only see
something like [BLOB 345 byes] i can not read the text of the comment.

Is there a way to let see the user-provide comments from phpmysqladmin?

Thank

JP

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] php-mysql problem

[Jianping Zhu]

Thank you for your response.
I get the php rpm distributed with redhat 9.0. 
Do I have to recompile phd instead from source code with mysql support?

Thanks



On Thu, May 13, 2004 at 06:15:23PM +0200, Oliver Hankeln wrote:
> Hello,
> 
> [snip]
> 
> >   but i got error message with:
> >   http://coopunit.forestry.uga.edu:8080/testdb.php
> >   the error is:
> >   Fatal error: Call to undefined function:
> >   mysql_connect() in /var/www/html/testdb.php on line 13
> >
> >   How can Fix this problem? Thanks
> 
> [/snip]
> 
> 
> Your PHP is compiled without mysql support (see 
> http://coopunit.forestry.uga.edu:8080/test.php) You do however have dbx 
> support. You might want to look at http://de.php.net/manual/de/ref.dbx.php
> Your mysql_connect has to be replaced by dbx_connect and so on...
> Alternativly you could recompile php with mysql support.
> 
> HTH,
> Oliver Hankeln
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Re: [PHP-DB] php-mysql problem

[Jianping Zhu]

Hi, thank you for your respinse.

It the /etc/php.ini i have something like:

;
;   extension=modulename.extension
;
; For example:
;
   extension=mysql.so

if you go to 
http://coopunit.forestry.uga.edu:8080/test.php
you will find mysql is not installed as an extension.

but i do not know how to fix this problem.

Do i have to recomplie the phd from source code?

Thanks
JP

On Thu, May 13, 2004 at 07:24:28PM +0200, Stefan Dengscherz wrote:
> hello,
> 
> did you load the mysql module in your php.ini configuration file?
> i.e. is the following line there:
> extension=mysql.so
> 
> regards
> 
> On Thu, 13 May 2004 11:47:41 -0400
> Jianping Zhu <[EMAIL PROTECTED]> wrote:
> 
> >  have redhat 9.0 and Server version: Apache/2.0.40.
> >   i have installed rpms php-4.2.2-17.2.i386.rpm
> >php-mysql-4.2.2-17.2.i386.rpm
> > 
> > 
> >After i create a database called mydb and serveral tables in mysql,
> >I tried to run following testdb.php script
> > 
> > 
> >--
> >
> >
> > >$db = mysql_connect("localhost", "root","xx");
> >mysql_select_db("mydb",$db);
> >$result = mysql_query("SELECT * FROM employees",$db);
> >printf("First Name: %s\n", mysql_result($result,0,"first"));
> >printf("Last Name: %s\n", mysql_result($result,0,"last"));
> >printf("Address: %s\n", mysql_result($result,0,"address"));
> >printf("Position: %s\n", mysql_result($result,0,"position"));
> >?>
> >
> >
> >---
> > 
> >but i got error message with:
> >http://coopunit.forestry.uga.edu:8080/testdb.php
> >the error is:
> >Fatal error: Call to undefined function:
> >mysql_connect() in /var/www/html/testdb.php on line 13
> > 
> >How can Fix this problem? Thanks
> > 
> > -- 
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> > 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] php-mysql problem

[Jianping Zhu]

I  have redhat 9.0 and Server version: Apache/2.0.40.
  i have installed rpms php-4.2.2-17.2.i386.rpm
   php-mysql-4.2.2-17.2.i386.rpm


   After i create a database called mydb and serveral tables in mysql,
   I tried to run following testdb.php script


   --
   
   
   \n", mysql_result($result,0,"first"));
   printf("Last Name: %s\n", mysql_result($result,0,"last"));
   printf("Address: %s\n", mysql_result($result,0,"address"));
   printf("Position: %s\n", mysql_result($result,0,"position"));
   ?>
   
   
   ---

   but i got error message with:
   http://coopunit.forestry.uga.edu:8080/testdb.php
   the error is:
   Fatal error: Call to undefined function:
   mysql_connect() in /var/www/html/testdb.php on line 13

   How can Fix this problem? Thanks
   

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php