Re: PHP and MySQL
Joe and Nancy M wrote: > > Thanks to everyones help, I have my webpages using php to read my mysql > table and presenting the appropriate information. I upload and refresh my > table via telnet when the whole thing needs refreshing. > > I would like to give my end user a tool to change the table when just a few > rows need updating. > > Can any of you point me to a resource that would have sample php code that > just displays a whole table and allows add/chg/delete functionality. > > Thanks once again! > > Joe. Try phpMyAdmin ... (http://www.phpwizard.net/projects/phpMyAdmin/) -- Ben Kennish Software Developer Fubra Limited web | www.fubra.net email | [EMAIL PROTECTED] phone | +44 (0)870 1222 600 fax | +44 (0)870 1222 699 - 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Antwort: PHP and MySQL - Specifying location for mysql.sock
HOORAY! It's finally working. However, I'd prefer to have my mysql.sock socket file in /tmp/ Anyone know how to change the settings for MySQL (and also PHP4 and phpMyAdmin) so that it looks in /tmp/ instead? Cheers. Ben Rick Emery wrote: > > I hd this same problem. Ensure that /var, /var/lib, and /var/lib/mysql have > permissions set to: drwxr-xr-x > > This cured the problem for me. > > rick > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 01, 2001 6:19 AM > To: Ben Kennish > Cc: [EMAIL PROTECTED] > Subject: Antwort: PHP and MySQL > > On 01.03.2001 11:55:40 Ben Kennish wrote: > > > "Warning: MySQL Connection Failed: Can't connect to local MySQL server > > through socket '/var/lib/mysql/mysql.sock' (111) in > > /var/www/html/index.php on line 5" > > Are you sure that your MySQL installation creates the socket right there? > If > I'm not mistaken, it may be created in /tmp. > > - > 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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > 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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Ben Kennish Software Developer Fubra Limited web | www.fubra.net email | [EMAIL PROTECTED] phone | +44 (0)870 1222 600 fax | +44 (0)870 1222 699 - 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Antwort: PHP and MySQL - Default Socket Setting
[EMAIL PROTECTED] wrote: > > On 01.03.2001 11:55:40 Ben Kennish wrote: > > > "Warning: MySQL Connection Failed: Can't connect to local MySQL server > > through socket '/var/lib/mysql/mysql.sock' (111) in > > /var/www/html/index.php on line 5" > > Are you sure that your MySQL installation creates the socket right there? If > I'm not mistaken, it may be created in /tmp. > > - > 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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php No it was creating it in /var/lib/mysql but then PHP doesn't like this Thanks to you, we've managed to get it working using the following commands... mysqladmin shutdown safe_mysqld --user=root --socket=/tmp/mysql.sock & This works but would you happen to know how I can get NySQL to create the socket in /tmp/ at startup? (rather than having to shut it down and reboot with a new socket) Cheers, -- Ben Kennish Software Developer Fubra Limited web | www.fubra.net email | [EMAIL PROTECTED] phone | +44 (0)870 1222 600 fax | +44 (0)870 1222 699 - 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP and MySQL - still got problem
I think that my file permissions are set OK. Heres a list of my MySQL
folder...
total 1652
drwx--6 mysql27 4096 Mar 1 11:37 .
drwxr-xr-x 20 root root 4096 Feb 15 16:26 ..
-rw---1 mysql27244 Feb 26 16:56 .bash_history
drwx--2 mysqlroot 4096 Feb 26 15:48 .xauth
drwx--2 mysqlmysql4096 Feb 28 16:32 BEN
-rw-r--r--1 mysqlmysql 1 Mar 1 10:28
chiefwigham.fubra.err
-rw-r--r--1 mysqlmysql8628 Feb 26 15:07
chiefwigham.fubra.err.old
-rw-rw1 mysqlmysql 3 Mar 1 10:06
chiefwigham.fubra.pid
-rw-rw1 mysqlmysql 322 Feb 26 14:15 chiefwigham.log
-rw---1 mysqlmysql 0 Feb 26 16:12 columns_priv.MYD
-rw---1 mysqlmysql1024 Feb 26 16:12 columns_priv.MYI
-rw---1 mysqlmysql8778 Feb 26 16:12 columns_priv.frm
-rw---1 mysqlmysql 302 Feb 26 16:12 db.MYD
-rw---1 mysqlmysql3072 Feb 26 16:12 db.MYI
-rw---1 mysqlmysql8982 Feb 26 16:12 db.frm
-rw---1 mysqlmysql 0 Feb 26 16:12 func.MYD
-rw---1 mysqlmysql1024 Feb 26 16:12 func.MYI
-rw---1 mysqlmysql8641 Feb 26 16:12 func.frm
-rw---1 mysqlmysql 0 Feb 26 16:12 host.MYD
-rw---1 mysqlmysql1024 Feb 26 16:12 host.MYI
-rw---1 mysqlmysql8958 Feb 26 16:12 host.frm
-rw-r--r--1 root root0 Mar 1 11:37 list.txt
drwx--2 mysqlmysql4096 Feb 28 14:26 mysql
srwxrwxrwx1 mysqlmysql 0 Mar 1 10:06 mysql.sock
-rwxr-xr-x1 mysqlmysql 1524536 Feb 19 13:56 mysqld
-rw---1 mysqlmysql 0 Feb 26 16:12 tables_priv.MYD
-rw---1 mysqlmysql1024 Feb 26 16:12 tables_priv.MYI
-rw---1 mysqlmysql8877 Feb 26 16:12 tables_priv.frm
drwx--2 mysqlmysql4096 Feb 28 16:13 test
-rw---1 mysqlmysql 428 Feb 26 16:12 user.MYD
-rw---1 mysqlmysql2048 Feb 26 16:12 user.MYI
-rw---1 mysqlmysql9148 Feb 26 16:12 user.frm
Thanks
Ben K
Ireneusz Piasecki wrote:
>
> - Original Message -
> From: "Ben Kennish" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, March 01, 2001 11:55 AM
> Subject: PHP and MySQL
>
> > Who would've thought it would take 3 days to install MySQL, PHP and get
> > them talking???!!
> >
> > I've installed PHP 4.0.4pl1 using an RPM from www.redhat.com
> >
> > I've also installed MySQL (latest ver) server and client versions from
> > www.mysql.com using RPMs.
> >
> > Now MySQL seems to be up and working (using 'mysql' and 'mysqladmin'
> > gives me no trouble) and PHP seems to work fine .
> >
> > I've installed the PHP-MySQL module from redhat.com (a single file -
> > mysql.so) and uncommented the "extension=mysql.so" line in /etc/php.ini
> >
> > But when I type ...
> >
> > mysql_connect('localhost', 'root', 'b');
>
> This can be that: mysql_connect('serwer_name','root','b' ); where
> serwer_name is serwer, that serve mysql databases
> or you can chmod file mysql.sock than other can it write (it could help)
>
> > into a PHP file, (I set b as my root SQL pwd) I get the following
> > error...
> >
> > "Warning: MySQL Connection Failed: Can't connect to local MySQL server
> > through socket '/var/lib/mysql/mysql.sock' (111) in
> > /var/www/html/index.php on line 5"
> >
> > There seems to be nothing in the MySQL error log.
> >
> > Please help! Thanks,
> >
> > --
> > Ben Kennish
> >
> > Software Developer
> > Fubra Limited
> >
> > web | www.fubra.net
> > email | [EMAIL PROTECTED]
> > phone | +44 (0)870 1222 600
> > fax | +44 (0)870 1222 699
> >
> > -
> > 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 <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > 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
Re: AW: PHP and MySQL
It is in /var/lib/msql
Ben K
Tobias Wolff wrote:
>
> You have to edit your "php.ini" file, usually located in /usr/local/lib.
>
> There is an option called "mysql.default_socket". The value of this options
> is the path to the mysql socket file. Your systems seems to search the
> socket file at "/var/lib/mysql/mysql.sock". It might be at a different
> place, probably "/tmp/mysql.sock".
>
> Tobias.
>
> -----Ursprüngliche Nachricht-
> Von: root [mailto:root]Im Auftrag von Ben Kennish
> Gesendet: Donnerstag, 1. März 2001 11:56
> An: [EMAIL PROTECTED]
> Betreff: PHP and MySQL
>
> Who would've thought it would take 3 days to install MySQL, PHP and get
> them talking???!!
>
> I've installed PHP 4.0.4pl1 using an RPM from www.redhat.com
>
> I've also installed MySQL (latest ver) server and client versions from
> www.mysql.com using RPMs.
>
> Now MySQL seems to be up and working (using 'mysql' and 'mysqladmin'
> gives me no trouble) and PHP seems to work fine .
>
> I've installed the PHP-MySQL module from redhat.com (a single file -
> mysql.so) and uncommented the "extension=mysql.so" line in /etc/php.ini
>
> But when I type ...
>
> mysql_connect('localhost', 'root', 'b');
>
> into a PHP file, (I set b as my root SQL pwd) I get the following
> error...
>
> "Warning: MySQL Connection Failed: Can't connect to local MySQL server
> through socket '/var/lib/mysql/mysql.sock' (111) in
> /var/www/html/index.php on line 5"
>
> There seems to be nothing in the MySQL error log.
>
> Please help! Thanks,
>
> --
> Ben Kennish
>
> Software Developer
> Fubra Limited
>
> web | www.fubra.net
> email | [EMAIL PROTECTED]
> phone | +44 (0)870 1222 600
> fax | +44 (0)870 1222 699
>
> -
> 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 <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Ben Kennish
Software Developer
Fubra Limited
web | www.fubra.net
email | [EMAIL PROTECTED]
phone | +44 (0)870 1222 600
fax | +44 (0)870 1222 699
-
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PHP and MySQL
Who would've thought it would take 3 days to install MySQL, PHP and get
them talking???!!
I've installed PHP 4.0.4pl1 using an RPM from www.redhat.com
I've also installed MySQL (latest ver) server and client versions from
www.mysql.com using RPMs.
Now MySQL seems to be up and working (using 'mysql' and 'mysqladmin'
gives me no trouble) and PHP seems to work fine .
I've installed the PHP-MySQL module from redhat.com (a single file -
mysql.so) and uncommented the "extension=mysql.so" line in /etc/php.ini
But when I type ...
mysql_connect('localhost', 'root', 'b');
into a PHP file, (I set b as my root SQL pwd) I get the following
error...
"Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111) in
/var/www/html/index.php on line 5"
There seems to be nothing in the MySQL error log.
Please help! Thanks,
--
Ben Kennish
Software Developer
Fubra Limited
web | www.fubra.net
email | [EMAIL PROTECTED]
phone | +44 (0)870 1222 600
fax | +44 (0)870 1222 699
-
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
