[PHP-DB] php-db Digest 26 Feb 2001 19:12:23 -0000 Issue 477
php-db Digest 26 Feb 2001 19:12:23 - Issue 477 Topics (messages 6951 through 6963): Re: Server side or client side? 6951 by: Uioreanu Calin 6953 by: JJeffman Re: OCI 8 and rowid cause SIGSEGV 6952 by: Thies C. Arntzen Re: cookies, email and passwords 6954 by: JJeffman Re: Join causing Error? 6955 by: Johnny Withers Oracle 8i questions 6956 by: Chris Murtland 6958 by: Andreas Karajannis 6959 by: Joe Brown Re: Interbase + PHP 6957 by: Meir kriheli The dreaded 12154!! 6960 by: Kevin Porter 6962 by: Kevin Porter Updating a Grid of Data 6961 by: Chris Andrew Re: Can't connect to local MySQL server error 6963 by: Rick Emery Administrivia: To subscribe to the digest, e-mail: [EMAIL PROTECTED] To unsubscribe from the digest, e-mail: [EMAIL PROTECTED] To post to the list, e-mail: [EMAIL PROTECTED] -- Hello, I see here a problem in jsclient-side generated code. Suppose 1st list (category) has 100 elements and second list, the products (ex.) has each 200 elements. a code that prevents selecting in 1st list the category would select all 100 x 200 elements and use js to display the correct list. This is very expensive. The link solution seems much better Regards, Uioreanu Calin That's what I've been telling to who asked about filling drop down lists at run time: When the amount of data is small you can generate JavaScript arrays to hold it otherwise you MUST reload the page to run your php script to fill up drop down lists. HTH. Jayme. -Mensagem Original- De: Uioreanu Calin [EMAIL PROTECTED] Para: [EMAIL PROTECTED] Enviada em: segunda-feira, 26 de fevereiro de 2001 06:54 Assunto: Re: [PHP-DB] Server side or client side? Hello, I see here a problem in jsclient-side generated code. Suppose 1st list (category) has 100 elements and second list, the products (ex.) has each 200 elements. a code that prevents selecting in 1st list the category would select all 100 x 200 elements and use js to display the correct list. This is very expensive. The link solution seems much better Regards, Uioreanu Calin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] On Sat, Feb 24, 2001 at 05:43:58PM +0100, Sven Voigt wrote: On Friday 23 February 2001 17:03, you wrote: I suppose the authors never concieved a replacement parameter for select specification. try: $sql =3D "select foo, bar, rid from masterdata WHERE rid=3D:rid" You need to loose the colon ":" or place it to the right of a where cla use. Sorry to bother this list again, but I don't get the point... :-( I need the rowid for later updates by a user form. So how can I issue a select clause with 'WHERE rid=3D:rid'? Don't I need this for the *update* clause??? rowids in 8i are an opaque data-type. so you need to convert them to something human-readable 1st (btw the column is called rowid and not rid). select ROWIDTOCHAR(rowid), name from test; ROWID NAME -- AAAGBFAAIAAAB/tAAA mller update test set name = 'hallo' where ROWID ='AAAGBFAAIAAAB/tAAA'; This is what I thought of: 1.) select foo, bar, rid from masterdata 2.) let user select data set to update with 'update.php?rowid=ROWID' 3.) write changes to database: update foo, bar values (FOO, BAR) where rowid=ROWID' usually one uses his/her self-defined primary key for that purpose. And what's about that colon? Is there any special meaning in PHP? no - in oracle sql the colon indicate that you are using a placeholder (= bind-variable); I'd highly appreciate your help/answer! Many thanks in advance BTW i cannot reproduce the reported crash - could you please try the latest snapshot from snaps.php.net and report if you still see this crash? thanx, tc Have a look on PHP manual there is good information on mail functions, setcookie function, and other stuff. HTH Jayme. -Mensagem Original- De: Matthew Cothier [EMAIL PROTECTED] Para: [EMAIL PROTECTED] Enviada em: domingo, 25 de fevereiro de 2001 17:13 Assunto: [PHP-DB] cookies, email and passwords Thanks! Is there anyone who can actually give me little bits of code that I need cause I am in a rush with this _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL
[PHP-DB] php-db Digest 27 Feb 2001 08:38:46 -0000 Issue 478
php-db Digest 27 Feb 2001 08:38:46 - Issue 478 Topics (messages 6964 through 6974): dns script 6964 by: Liz Bander 6968 by: php3.developersdesk.com Re: Can't connect to local MySQL server error 6965 by: Brunner, Daniel 6967 by: Rick Emery Re: onMouseOver onMouseOut 6966 by: Ron Brogden 6969 by: php3.developersdesk.com Fatal error: Call to undefined function: () in add2.php on line 11 6970 by: jim and lois flaherty 6973 by: Joe Brown array awry 6971 by: Keith Spiller 6972 by: Rolf Hopkins 6974 by: CC Zona Administrivia: To subscribe to the digest, e-mail: [EMAIL PROTECTED] To unsubscribe from the digest, e-mail: [EMAIL PROTECTED] To post to the list, e-mail: [EMAIL PROTECTED] -- I'm not sure that this is entirely on topic, but does anyone have a simple DNS script gleaning from MySQL 3.23 that I could take a look at? Right now we're doing the manual entry thing, but it's going to get old fast. If you can even direct me to an appropriate source, that would be great. Thanks, Liz Addressed to: Liz Bander [EMAIL PROTECTED] [EMAIL PROTECTED] ** Reply to note from Liz Bander [EMAIL PROTECTED] Mon, 26 Feb 2001 14:51:07 -0500 I'm not sure that this is entirely on topic, but does anyone have a simple DNS script gleaning from MySQL 3.23 that I could take a look at? Right now we're doing the manual entry thing, but it's going to get old fast. If you can even direct me to an appropriate source, that would be great. I don't understand what you want to do. Please give a few more details on what you want. This is probably as good a place as any for the question though. Rick Widmer Internet Marketing Specialists http://www.developersdesk.com Hello... Try this instead... Grant ALL ON Database_name.* to user@localhost IDENIFIED BY "password"; You can use Grant whatever ON Database_name.*...As well The .* after the Database_name will allow all tables to be accesed by the users, on that Database... It worked great for me... Dan -- From: Rick Emery Sent: Monday, February 26, 2001 1:16 PM To: '[EMAIL PROTECTED]' Subject: RE: [PHP-DB] Can't connect to local MySQL server error I'm also having trouble connecting to the MySQL server. I can connect as root, but not as a user from the command line. When connect to the mysql server as ROOT, I've granted all privileges to the user using 'user@localhost' and 'user@"%" '. Still no luck. I'm using MySQL on Redhat Linux. I'm having same problem connecting via a mysql_connect(---) call in PHP. What do I need to do to allow user interaction for MySQL? thanks rick Richard L. Emery IT Sr. Project Manager "There is no 'trying'... There is only 'Do' or 'Not Do' " -Original Message- From: Brunner, Daniel [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 5:05 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: [PHP-DB] Can't connect to local MySQL server error Hello... Do a netstat -vatp To see if mysql is up and listening on your TCP. And it will give your PID/Program name as well... I remember reading something about if the mysql.sock didn't work...you needed to do something with mysql...I'll look into it this weekend. If nobody can help you out sooner Well good luck... Dan -- From: Chris Weiss Reply To: [EMAIL PROTECTED] Sent: Friday, February 16, 2001 4:37 PM To: [EMAIL PROTECTED] Subject:[PHP-DB] Can't connect to local MySQL server error Help! I'm experimenting with several of the PHP based WebDatabase front ends and am getting the following errors from all of them: "Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /home/httpd/html/pub/mainfile.php on line 9 Unable to select database" I've tried the following: [root@casadelove pub]# telnet localhost 3306 |strings Trying 127.0.0.1... Connected to casadelove.com. Escape character is '^]'. 3.23.27-beta $Gu=m/. Connection closed by foreign host. The databases being requested do exist and are populated with the default data and WebMin (Perl-based web administration program) accesses the test databases just fine. This is on a RH6.2 system with Apache 1.3.14 and PHP 4.0.4. This strikes me as something really stupid that I'm missing, anyone have any bright ideas where to look? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: