[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

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

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

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

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

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

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

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

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

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

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

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

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

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