[PHP-DB] Re: [PHP] Regex for telephone numbers

[Debian (sid)] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php \d{3}-\d{3}-\d{4} Also, have a look at the phoneNumber method in the relevant Validate PEAR package: http://pear.php.net/packages.php?catpid=50catname=Validate --- Simon

Re: [PHP-DB] transactions

the execution of a script. cheers Simon -- ~~ Simon Rees | [EMAIL PROTECTED] | ORA-03113: end-of-file on communication channel ~~ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

Re: [PHP-DB] printf() in a variable, or alternative to printf()

into their database. Use sprintf see: http://uk2.php.net/manual/en/function.sprintf.php Si -- ~~ Simon Rees | [EMAIL PROTECTED] | ORA-03113: end-of-file on communication channel ~~ -- PHP Database

Re: [PHP-DB] Re: SQL or array ?

the CPU time taken by various parts of the script. I've used Xdebug for profiling and found it useful. Have a look at http://www.php.net/debugger for this and other options (I assume the other debuggers have profiling support). Simon -- ~~ Simon

Re: [PHP-DB] PHP Sessions

me in the direction of a good tutorial? Have a look at the user comments on this page of the docs: http://www.php.net/manual/en/function.session-set-save-handler.php There are examples for MySQL and Postgres which should give you an idea of where to start. cheers Simon

Re: [PHP-DB] GD Question

as a separate file. Put your image code in a separate script and request it in the src attribute of your html image tags. e.g. img src=display_image.php Simon -- ~~ Simon Rees  | [EMAIL PROTECTED]  | ORA-03113: end-of-file on communication

Re: [PHP-DB] comprehensive sql tutorial

(for MySQL) http://dev.mysql.com/doc/ or (for Oracle - requires OTN membership which is free) http://oraclesvca2.oracle.com/docs/cd/B14117_01/index.htm cheers Simon -- ~~ Simon Rees | [EMAIL PROTECTED] | ORA-03113: end-of-file on communication

Re: [PHP-DB] Why not ?

the two tables as well but without knowing your database it is impossible for me to say how. If you are using an older mysql version what you want to do is probably impossible in one statement. Simon -- ~~ Simon Rees  | [EMAIL PROTECTED]  | ORA

[PHP-DB] variable and MySQL

Hi, I'm trying to make a script but have a problem ... How could I do this: I'd like to use $get_question_data[xxx_name_en] where xxx would be a variable variable according to the situation where the script is called... how would I do this? tried : $get_question_data[$test_name_en]

Re: [PHP-DB] password in md5 to connect to mysql instead of clear password

in my php script to call the c program. A PHP program could be used for reading the password file but will need to be executed by a shebang rather than as a parameter to php. I can post further details if anyone is interested. cheers Simon

Re: [PHP-DB] password in md5 to connect to mysql instead of clear password

that described earlier of putting the passwords in a file outside the webserver root. The technique I described keeps you passwords secret even if an attacker has read access to files they shouldn't. A similar strategy is used for the shadow password file on Unix boxes. cheers Simon

Re: [PHP-DB] Re: password in md5 to connect to mysql instead of clear password

On Monday 28 February 2005 13:52, Gael Lams wrote: Simon, I read your post regarding the use of a C program and I would be interested in having some more details as we started thinking about implementing something similar. Unfortunately I've misplaced the program I'd used in the past to do

Re: [PHP-DB] JOIN problem

you're using you may be able to do this: SELECT a.username FROM table1 a WHERE a.username NOT IN ( SELECT b.username FROM table2 b ) cheers Simon -- ~~ Simon Rees  | [EMAIL PROTECTED]  | ORA-03113: end-of-file on communication channel

Re: [PHP-DB] IIS, PHP, and session data

Apache on a Linux (and probably other un*x) distribution you will find that the session.save_path variable is set to /tmp which is usually world writable. I think if you posted the exact error message it would tell me if this was happening to you or not... hth, Simon

Re: [PHP-DB] mysql - image storing

)... cheers Simon -- ~~ Simon Rees  | [EMAIL PROTECTED]  | ORA-03113: end-of-file on communication channel ~~ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] Problem with an insert query

and are using the mysqli library. See: http://www.php.net/manual/en/function.mysqli-prepare.php Note, this is a common technique in database programming but one which MySQL is only just starting to adopt... Simon -- ~~ Simon Rees | [EMAIL

Re: [PHP-DB] Problem with an insert query

You also appear to have a quote in the value that contains the word members' You will need to escape this or use bind vars. Simon On Saturday 13 November 2004 06:29, GH wrote: In my mySQL database I have the following tables: +-+ | Tables_in_AHRC

Re: [PHP-DB] Do You Need addslashes() When Using Bind Variables

Hi Francis No. Thats one of the great things about bind variables. cheers Simon On Wednesday 10 November 2004 05:45, Francis Chang wrote: Hi, I'm using the Oracle database though I think this question is generic to all databases. If you're using bind variables and preparing the SQL

Re: [PHP-DB] Executing SQL query with ODBC

which may be inefficient - say if you were only interested in the first row out of a possible 100. [anybody else care to comment?] Note, after an insert, update and delete statements odbc_num_rows does return the number of rows affected. cheers Simon On Tuesday 09 November 2004 08:09, Petrus Ali

Re: [PHP-DB] Dates - adding to unix 86400 seconds not equal nextday

gmdate doesn't cause this anomaly. Apologies if this is what you're discussing and the issue is when the DST switch takes place... cheers Simon -- Simon Rees | -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] DB update problem...

ideas? Yes, see above. ;) Thanks! JIM HTH, Simon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] echo printing a cookie

Here ya go.. if ($_cookie[cookiename]) { echopyour cookie is.$_COOKIE['cookiename']./p; } Cheers Simon -Original Message- From: Steve Dodkins [mailto:[EMAIL PROTECTED]] Sent: 15 October 2002 15:22 To: Php-Db (E-mail) Subject: [PHP-DB] echo printing a cookie Hi I'm trying

RE: [PHP-DB] Javascript

Hi, In your javascript try field1=Number(thisform.field1.value) etc... Cheers Simon -Original Message- From: Shahmat Dahlan [mailto:[EMAIL PROTECTED]] Sent: 11 October 2002 11:35 To: [EMAIL PROTECTED] Subject: [PHP-DB] Javascript My question might have anything to do with PHP but I

RE: [PHP-DB] Dynamic data from user file

. then parse through that array with a loop that inserts the new value line for line and it works fine for me. There is possibly a better way of going about it, but this works for me. Cheers Simon -Original Message- From: John Patrick [mailto:[EMAIL PROTECTED]] Sent: 9 October 2002 00:15

[PHP-DB] Informix

Does anyone know of a good infrmix list I am in a fix.. Thanks _ Simon Taylor AfriTol (Pty) Ltd. ? [EMAIL PROTECTED] Å+27 12 361 3303 ext 257 Å+27 72 471 1833 Æ+27 12 365 3810 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

RE: [PHP-DB] Re: Array help needed :-(

' = '3,99'), 'burgers' = Array('small' = '2.99', 'medium' = '4.99', 'large' = '6,99')) Then access them like this $smallburger = $ar['burger']['small'] Hope this helps. Simon -Original Message- From: David Robley [mailto:[EMAIL PROTECTED]] Sent: 8 October 2002 06:49

[PHP-DB] Erratic isset()

HTML form etc... Simon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] form variables not beeing passed to next page

? Have I missed something? simon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: convert mysql table to Excell or Access file

Try the 'free' PC program called MySQL-Front from http://www.anse.de/mysqlfront/index.php It has a nice function for exporting to Excel. simon Alex Shi [EMAIL PROTECTED] skrev i meddelandet [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Can MySQL table be converted to Access or Excel

[PHP-DB] AUTO_INCREMENT problemos

(their member_id values) have not been forgotten it seems and the DB is using them still to evaluate the next number. Any ideas? Simon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Oracle8i connecting to database problem

sqlplus and the variables I've set in php for the password and name etc. so I'm pretty sure my client and server installations are ok). Thanks, Simon. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED

[PHP-DB] insert date problem

, 'all', '2001-04-06', '2001-09-20') Warning: OCIStmtExecute: ORA-01861: literal does not match format string in ... on line 44 Can anyone help? Cheers Simon.

[PHP-DB] PHP4.0.5 and PHP 4.0.6

: 0.07, 0.09, 0.11 as i said before the system is 100% stable and the ONLY factor i did change WAS php4 from 4.0.1 to 4.0.5 (i did check 4.0.6 as well but there was no significant change!) sincerly Simon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECT

[PHP-DB] security in PHP under Apache

binary and use something like suExec (I currently have it as an Apache module, and would like to leave it that way). best wishes, simon --- Studio 24 Ltd | tel. 01223 501 892 PO Box 88 | fax. 0870 063 1216 Cambridge | mob

[PHP-DB] get_browser()

hi all how does everyone feel about the get_browser function?? Is the general impression it's overkill, and also flawed since it depends on the browser.ini file being up to date, or it is widely used? I'm about to need to use browser detection I'm wondering if a simple

[PHP-DB] running PHP from the cron

is the best method? Otherwise I'll have to fall back on Perl to do my cron stuff ;-) have fun simon --- Studio 24 Ltd | tel. 01223 501 892 30 Hopkins Close | fax. 0870 063 1216 Cambridge | mob. 07974 074 547 CB4 1FD

RE: [PHP-DB] running PHP from the cron

I run my PHP crons like this: 0 6 * * * /usr/local/bin/lynx -source "http://www.domain.com/file.php" This is not the most secure of course, as the file is below the root and could be hit by any user. But works for my particular case ... Anyone know of a method to make this more secure

[PHP-DB] Tricky one - include($identifer);

this though - eval() looks for just php code and include() and require() look for filenames. I really don't want to store my snippets as files - but I guess I may have to if I can't find a way to pull em out of a database and include() em. Any help would be much appreciated Cheers Simon

Re: [PHP-DB] Text Control.

br function, thus converting all newline characters to BR tags. http://uk.php.net/manual/function.nl2br.php -- Simon Pospisil Mail: [EMAIL PROTECTED] Web EngineerWeb: http://www.fastsearch.com/ Fast Web Media Ltd. Phone: +44 (0)