[PHP-DB] php and oracle

2004-09-07 Thread D.Wilkening
Hi everyone, i've a problem using php with oracle 10g. (php 5.0.1 compiled against Oracle 10.1.0.2-libs, apache2 and apache1) One or two days, everything looks good. Then, by pressing (once a second) reload in your browser, you sometimes get an ERROR #: 2 ERROR DESC: oci_execute() [a

[PHP-DB] Fetch Array, Display and Update, all in one ?

2004-09-07 Thread GamCo - Gawie J Marais
Hi All, I have designed a debit-system database with a PHP frontend. The amounts need to be updated on a monthly basis. now i have 10 clients in the system. i can get all the fields and display them, but next to that, i need to insert a field where we can enter an amount per client and after all

[PHP-DB] Re: Antwort: [PHP-DB] php and oracle

2004-09-07 Thread D.Wilkening
This sounds interesting! We'll try this. Thanks and greetings from Essen :), Dieter -- Dieter Wilkening Software-Entwickler Baumann Technologie GmbH [EMAIL PROTECTED] [EMAIL PROTECTED] sagte: I tried to compile PHP 4.3.8 with OCI and oracle_LIB 32bit somewhere in $ORACLE_HOME/../lib32

[PHP-DB] error on count()

2004-09-07 Thread Sancerni Veronica
hello, this is problably newbie question, but I can not understand why my count() function doesn't work. I need to count how many items has a determinated customer ordered ever. 1. I tired to get the array like this: $una = $check[uname]; function orderquantity ($una) { $pss =

[PHP-DB] Re: php Form Validation help

2004-09-07 Thread Neil Smith [MVP, Digital media]
At 11:09 07/09/2004 +, you wrote: From: Vincent Jordan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Mon, 6 Sep 2004 19:20:16 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary==_NextPart_000_0004_01C49446.8C688C60 Subject: php Form Validation help have a form

[PHP-DB] mysqli and prepare

2004-09-07 Thread Joerg Forg
Hi @ all, i´ve some questions about the new mysqli. I build my own dbmanagement for mysqli and now i´ve a problem with dynamic bind for params. bind_param only alows to set primitive datatypes and i don´t have any idea to make it dynamic like: function bind_MyParams($array_myParams) like pear::db

Re: [PHP-DB] functions via event handlers

2004-09-07 Thread Neil Smith [MVP, Digital media]
Or you could use XMLHTTP on the browser side (supported by IE and Mozilla variants) You'd send a GET request to the page, it would return - often - an XML record set, or you can return text, and indeed you can even query page status codes from the client side. The point is, you no longer need

Re: [PHP-DB] error on count()

2004-09-07 Thread Peter Ellis
You need to pass the functions a variable to work with because you've specified parameters. Try: $okuan = orderquantity($una); Ditto for the other function call. -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development Consultant naturalaxis | http://www.naturalaxis.com/ On Tue,

Re: [PHP-DB] Another newbie question

2004-09-07 Thread Wolfgang Ebneter
charset=iso-8859-15 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Am Montag, 6. September 2004 23:50 schrieb Pete Holsberg: [...] $sql =3D SELECT * FROM $table ; $sql .=3D WHERE `LastName` LIKE $search_string ; $sql .=3D OR `FirstName` LIKE $search_string ;

[PHP-DB] Re: Another newbie question -- ANSWERED!!

2004-09-07 Thread Pete Holsberg
On Mon, 6 Sep 2004, Pete Holsberg wrote: The following code results in the error message Couldn't execute query. $sql = SELECT * FROM $table ; $sql .= WHERE `LastName` LIKE $search_string ; $sql .= OR `FirstName` LIKE $search_string ; $sql .= OR `Spouse` LIKE $search_string ; $sql .= OR

Re: [PHP-DB] Re: Another newbie question -- ANSWERED!!

2004-09-07 Thread Greg Donald
On Tue, 2004-09-07 at 12:16, Pete Holsberg wrote: Also, should I have back tics around a column name EVERYWHERE it's used in a SELECT (in this case, following ORDER)? Only if you plan to use keywords as field names, otherwise it's pointless. -- Greg Donald -- PHP Database Mailing List

Re: [PHP-DB] Re: Another newbie question -- ANSWERED!!

2004-09-07 Thread John Holmes
From: Pete Holsberg [EMAIL PROTECTED] $sql = SELECT * FROM $table ; $sql .= WHERE `LastName` LIKE` '%$search_string%' ; $sql .= OR `FirstName` LIKE '%$search_string%' ; $sql .= OR `Spouse` LIKE '%$search_string%' ; $sql .= OR `Street` LIKE '%$search_string%' ; $sql .= OR `Email` LIKE

Re: [PHP-DB] Re: Another newbie question -- ANSWERED!!

2004-09-07 Thread randy
On Tue, 7 Sep 2004 13:16:20 -0400 (EDT), Pete Holsberg [EMAIL PROTECTED] wrote: With a Unix shell programming background, I'm puzzled by the use of 'tics' (single quotes, apostrophes' around %$search_string%. I would have though that they would have removed the special meaning of the $.

[PHP-DB] Building A Web Site Search Engine Using PHP / mySQL

2004-09-07 Thread Ron Piggott
I wanted to also ask about how you would build a web site search engine with php and mySQL. I had thought of setting up a table with a few columns --- one for the URL of the specific page (This could become a link when a match is found for that page) second with the page title --- used in

Re: [PHP-DB] Building A Web Site Search Engine Using PHP / mySQL

2004-09-07 Thread Peter Ellis
Well, this is from the why reinvent the wheel department -- have you looked at htdig://? http://www.htdig.org/ Might save you some work. Just a thought :) More constructive replies regarding actual code are forthcoming, I'm sure. -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development

Re: [PHP-DB] error on count()

2004-09-07 Thread zareef ahmed
1. I tired to get the array like this: $una = $check[uname]; function orderquantity ($una) { $pss = mysql_query(SELECT OID FROM orders WHERE una = '.trim($una).') or die (mysql_error(Query error on Order search)); while($pisao=mysql_fetch_array($pss)) { return count($pisao);

Re: [PHP-DB] Building A Web Site Search Engine Using PHP / mySQL

2004-09-07 Thread zareef ahmed
Hi, http://www.zend.com/php5/casestudies/php5-orase.php You may have some lead. zareef ahmed --- Ron Piggott [EMAIL PROTECTED] wrote: I wanted to also ask about how you would build a web site search engine with php and mySQL. I had thought of setting up a table with a few columns ---