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

package: http://pear.php.net/packages.php?catpid=50&catname=Validate --- Simon Welsh Admin of http://simon.geek.nz/ Who said Microsoft never created a bug-free program? The blue screen never, ever crashes! http://www.thinkgeek.com/brain/gimme.cgi?wid=81d520e5e -- PHP Database Mailing List

Re: [PHP-DB] transactions

persist beyond 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.ne

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

utor who will parse it and input 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 ~

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

l show 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 suppo

Re: [PHP-DB] PHP Sessions

bout this or point 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

Re: [PHP-DB] GD Question

wsers work - each image is requested 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. Simon -- ~~ Simon Rees  | [EMAIL PROTECTED]  | ORA-03113: end-of-fil

Re: [PHP-DB] comprehensive sql tutorial

database concepts. See (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-031

Re: [PHP-DB] Why not ?

e...) You almost certainly want to join 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 -- ~~

[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] $get_que

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'

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

chnique you describe is no more secure than 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

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

ad the password file and a system call 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

Re: [PHP-DB] JOIN problem

is : Depending on which database 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-

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

e permissions on c:\php\sessiondata Assuming you're running 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 te

Re: [PHP-DB] mysql - image storing

ection attacks)... 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

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

ove 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 | [EM

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: > +-+ > >

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 var

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

m all 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, Petru

Re: [PHP-DB] Reverse (or backward?) Infinity Loop

code in your client language to interpret the catParentId to catId relationship. Simon On Wednesday 20 October 2004 03:47, Bruno B B Magalhães wrote: > Hi guys, > > I have a normal categories table: > > catId > catParentId > catName > catStatus > > But I want when a

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

ither... Using 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

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

> > # > > When I use " " or ' ' around the program name I get only "didn't work #1". Then you perhaps don't have the right to execute it. Note that the apache-user must have the execution right on that file. > Any 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"]) { echo"your cookie is".$_COOKIE['cookiename'].""; } Cheers Simon -Original Message- From: Steve Dodkins [mailto:[EMAIL PROTECTED]] Sent: 15 October 2002 15:22 To: Php-Db (E-mail) Subject: [PHP-DB

RE: [PHP-DB] Javascript

') Field3=Number('2') Field1+field2+field3 = 3 Cheers Simon -Original Message- From: Ignatius Reilly [mailto:[EMAIL PROTECTED]] Sent: 11 October 2002 15:48 To: Shahmat Dahlan; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Javascript I have met this problem before. The only

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

[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] 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

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

ike this. $ar = Array( 'hotdogs' => Array('small' => '1.99', 'medium' => '2.99', 'large' => '3,99'), 'burgers' => Array('small' => '2.99', 'medium' => 

[PHP-DB] Erratic isset()

#x27;,'$memb_date ','$comments')"; mysql_query($doit1); //put the data in members table printf ("Database updated. Enter a new member?"); /* Closing connection */ mysql_close($link); endif; ?> //print 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

e. Worked fine in 4.06? 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

[PHP-DB] AUTO_INCREMENT problemos

ows (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] special chars

and whatnot in the db. Is there some way i can administrate thise special chars? also, the function htmlentities() does not work properly - it ignors ö, ä, etc. Does anyone know a manual for that? Thanks!!! Simon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [E

[PHP-DB] Oracle8i connecting to database problem

x27;t see anything about it being a problem but I can't think of anything else. Any ideas? (I can create a connection to the database using 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

[PHP-DB] Setting nls_date_format in initSID.ora

sid of the database in question. Is that right? However, if I alter the format within a session then it works fine. Any ideas? Cheers Simon. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contac

[PHP-DB] insert date problem

values (16, '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

ll PHP as a CGI 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 Camb

[PHP-DB] RE: MySQL: CRITICAL problem

e function your MySQL statement is in cannot access it. to access a variable outside of a function write global $connection; or something similar (whatever the name of your MySQL connection handle) as the first line of your function :-) simon ---

[PHP-DB] RE: nobody header

mail.php the "nobody" user will be the webserver, and since your original script did not specify a sender then this is what the server usually defaults to. best wishes, Simon --- Studio 24 Ltd | tel. 01223 501 892 PO Box 88 |

RE: [PHP-DB] Can't connect to local MySQL server through socket '/tmp/mysql.sock'

the command line will tell you if it's running. you might find some useful info here: http://www.mysql.com/doc/S/t/Starting_server.html good luck, simon --- Studio 24 Ltd | tel. 01223 501 892 PO Box 88 | fax. 0870 063 1216

[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 get_env("HTTP_USER_AGENT"

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 se

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

parse PHP scripts off the cron. An example (from PHPAds) is below.. 59 23 * * * fetch -o - http://www.profi.it/phpAds/mail.php3>>/var/log/messages I'm wondering if there are any pros/cons to this approach, and whether there are a

[PHP-DB] running PHP from the cron

this, and what 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 54

[PHP-DB] RE: problems with require...

his line $includefile = $row["includefile"]; with: $includefile = $row["includefile"].".inc"; PHP is prob getting confused what the "." means in your require statement. best wishes, simon --- Studio 24 Lt

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

ks 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 -- THE WORST HOMING

Re: [PHP-DB] Text Control.

could try using the nl2br function, thus converting all newline characters to tags. http://uk.php.net/manual/function.nl2br.php -- Simon Pospisil Mail: [EMAIL PROTECTED] Web EngineerWeb: http://www.fastsearch.com/ Fast Web Media Ltd.

Re: [PHP-DB] Easy MySQL question

Julie Meloni wrote: > simon wrote: > > > Julie Meloni wrote: > > > > > >> Paulson, Joseph V. \"Jay\" wrote: > >> > >> > >>> Hello everyone-- > >>> I've got a easy question that I can't seem to answer f

Re: [PHP-DB] Easy MySQL question

gt; > -- > 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] Shouldn't this be $query also? $query = "SELECT c

[PHP-DB] Problem with writing to database. Possibly a CLOB error...

ks in advance, Simon. Error: Warning: OCIStmtExecute: ORA-01704: string literal too long Code: while ( list($k, $v) = each($res) ) { $body = $res[$k][1]; $id = $res[$k][0]; $body = preg_replace( "/'/", "''", $body ); $sql = &qu