Try using the query:
$db->query("update SERVER set Token = '$intoken' where IPAddress
='192.168.1.100'");
You are trying to update all rows with $intoken, where the column Token is
unique.
Regards,
Neil Morgan
-Original Message-
From: Prashant Prabhudesai [mailto:pprab...@cisco.com]
Lester,
Thanks for the advice, I tried to run this on a 5.2.17 install as well with the
same results.
Thanks anyway,
Neil
-Original Message-
From: Lester Caine [mailto:les...@lsces.co.uk]
Sent: 05 August 2011 17:08
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Oracle NClobs
n.a.mor..
Guys,
Can anyone help please? I am using Oracle 10g (10.2.0.3) with PHP 5.2.5.
The following piece of code works with a CLOB, but not with an NCLOB. Can
anyone shed any light please?
$SQL = "
UPDATE $d_sid.srs_spd SET spd_fuld = EMPTY_CLOB()
WHERE spd_stuc = :stuc AND spd_seqn = :seqn
Escape the embedded single quotes i.e.
$stmt = OCIParse($conn, 'SELECT * FROM v$sql WHERE
INSTR(SQL_TEXT,\'something\')>0');
Neil
-Original Message-
From: Mark Casson [mailto:confu...@icube.co.uk]
Sent: 23 April 2009 12:10
To: php-db@lists.php.net
Subject: [PHP-DB] Re: PHP and table/v
I find that using single quotes rather than double quotes prevents
variable substitution.
I don't know if this is an undocumented feature, as the documentation
says that both have the same functionality.
Regards,
Neil
-Original Message-
From: Mark Casson [mailto:confu...@icube.co.uk]
S
Adam,
Have you tried oci_pconnect() instead of ocilogon()?
Also, I have encountered some issues on Win32 with the instant client
and PHP5.
Try installing the full client and testing again.
Neil Morgan
-Original Message-
From: Fortuno, Adam [mailto:[EMAIL PROTECTED]
Sent: 24 November 20
Ritesh,
Don't know of a suitable XML database to use with PHP, but I could
recommend using Oracle 10g. There are built in XML services that should
help with your project. Furthermore, PHP has a well documented Oracle
interface (OCI8) just for this. To handle the XML though, you would
probably n
You may want to check the max_execution_time directive in php.ini
Neil
-Original Message-
From: Iulian Manea [mailto:[EMAIL PROTECTED]
Sent: 21 April 2006 01:33
To: php-db@lists.php.net
Subject: [PHP-DB] Php in the twilight zone!
Hey everybody,
For about the last 7 hours I am trying
>From the manual:
ORA-00600 internal error code, arguments: [string], [string], [string],
[string], [string], [string], [string], [string]
Cause: This is the generic internal error number for Oracle program
exceptions. It indicates that a process has encountered a low-level,
unexpected condit
Hi All,
Does anyone out there run PHP5 on Solaris 9 with Instant Client 10.1 for
Oracle? Are there any known issues with compiling OCI support?
Regards,
Neil Morgan MSc
Analyst Programmer
Admin Computing
University of Brighton
T: +44 (0) 1273 64 3930
F: +44 (0) 1273 64 2666
Try sprintf().
-Original Message-
From: mayo [mailto:[EMAIL PROTECTED]
Sent: 27 May 2005 14:02
To: php-db@lists.php.net
Subject: [PHP-DB] printf() in a variable, or alternative to
I need to be able to format data.
Printf() is perfect because I need a certain amount of characters (30
Jos,
This may or may not sort out the problem, but OCI_ASSOC |
OCI_FETCHSTATEMENT_BY_ROW should be OCI_ASSOC+OCI_FETCHSTATEMENT_BY_ROW.
Neil
-Original Message-
From: Juffermans, Jos [mailto:[EMAIL PROTECTED]
Sent: 20 April 2005 12:18
To: 'php-db@lists.php.net'
Subject: [PHP-DB] OCI Bind
Sorry, trigger happy. Also try ":postalcode" in uppercase.
Neil
-Original Message-
From: Juffermans, Jos [mailto:[EMAIL PROTECTED]
Sent: 20 April 2005 12:18
To: 'php-db@lists.php.net'
Subject: [PHP-DB] OCI Binding problem
Hi,
Imagine this code:
Both queries should result in the sa
http://www.fpdf.org
I swear by it as well.
Neil Morgan
-Original Message-
From: Peter Beckman [mailto:[EMAIL PROTECTED]
Sent: 06 April 2004 03:39
To: PHP-DB Mailing List
Subject: Re: [PHP-DB] PDFLib
I LOVE FPDF. I don't know where I found it, but I can insert images, it
wraps text --
I have had similar problems before. I have just created your table in
MySQL. Seems you can't have an AUTO_INCREMENT column that is UNSIGNED.
Doesn't mention this in the manual though.
Neil Morgan
-Original Message-
From: js [mailto:[EMAIL PROTECTED]
Sent: 21 January 2004 22:34
To: [EMA
You could try sqlite. http://www.sqlite.com/ would give you more details on
sqlite, http://hu.php.net/sqlite is the PHP manual pages for the sqlite
extension (PHP4). You can download the php_sqlite.dll extension for windows
here as well.
Neil Morgan
-Original Message-
From: GUIRAUDOU [m
is register_globals set to off in php.ini?
this may be the issue if it is set to on.
-Original Message-
From: Jas [mailto:[EMAIL PROTECTED]
Sent: 15 December 2003 22:50
To: [EMAIL PROTECTED]
Subject: [PHP-DB] sql errors?
I have checked and rechecked my code on these php to mysql stateme
You could try ODBC instead.
Neil Morgan
-Original Message-
From: Morten Gulbrandsen [mailto:[EMAIL PROTECTED]
Sent: 16 December 2003 05:45
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Max DB as Database for PHP
Hello,
Has anyone tried to connect to MaxDB with PHP ?
http://www.mysql.com/
$keywords = str_replace(' ','%',$keywords);
select * from table where data like "%keywords%";
-Original Message-
From: Hadi [mailto:[EMAIL PROTECTED]
Sent: 12 December 2003 13:21
To: [EMAIL PROTECTED]
Subject: [PHP-DB] anyone trickier than 'LIKE' ?
Hi all,
I have this data (eg.) "..
put the schema name before the sequence object you need to increment, i.e.
$sql = "select SCHEMA.TEAM_SEQ.NEXTVAL as \"nextval\" from sys.dual";
Regards,
Neil Morgan
-Original Message-
From: Paul Miller [mailto:[EMAIL PROTECTED]
Sent: 12 December 2003 00:05
To: [EMAIL PROTECTED]
Subject
A simple thing, but do you have wrte permission on your drive F: from the
web server?
-Original Message-
From: Karen Resplendo [mailto:[EMAIL PROTECTED]
Sent: 23 October 2003 22:18
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Can't copy file to another server
Nope. A
Hi,
Has anyone out there using PHP and Oracle come across this problem? I have
a text area that allows free-form text that I store in a varchar2 column. I
have problems with apostrophes in the free-form text. When users put in an
apostrophe the SQL fails. If I force 3 apostrophes (the usual O
22 matches
Mail list logo