RE: [PHP-DB] Re: Multi search function (help)

[Gavin Amm]

For what it's worth, if you store your form fields in an array, you can
loop through the array to search for isset  empty on each array element
and have the array add the fields that are relevant to your sql
statement.

Doing this will also ensure that you won't have to modify your script
(that generates the sql statement) regarding how many form fields you
have every time you add a new form field to the form page.

Gav

-Original Message-
From: nabil [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 27 May 2004 10:57 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Re: Multi search function (help)


yes, this is true, we should add empty() function too.

Ross Honniball [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
 I'm not 100% sure, but you may want to also check if the field is
empty
 (using empty() function) before including in your search. (in addition
to
 isset)

 Also, just a caution, you will need to take some care in figuring when
and
 where to place your 'and' statements linking the various parts of the
query.

 At 08:01 AM 27/05/2004, you wrote:
 Nabil wrote:
 
   David Robley [EMAIL PROTECTED] wrote in message
   news:[EMAIL PROTECTED]
   Nabil wrote:
  
 hi all
   
Is there a way to condition your search:
   
-I have a form for four text boxes for search my Mysql...
-I don't want to write 4 conditions and for SQL statements
incase
he
decided not to search with all keywords (fields)
- I have by example : name, lastname , nickname and phone
form...
I need a way to select my records even one or more field were
null
(searching only on of the above)
   
because the following SQL will generate null result
   
   
$name=$_POST['naame'];
$lastname=$_POST['lastname'];
$nickname=$_POST['nickname'];
$m_date=$_POST['m_dateY'];
echo $name.$lastname.$nickname.$m_date;
   
SELECT id, name , lastname , m_date from users
where
name like binary '%$name%' and lastname like binary
'%$lastname%'
and
nickname like binary  '%$nickname%' and m_date= YEAR('$m_date')
order
   by
id ASC ) or die(mysql_error());
   
   
   
Thanks in advanced
  
   Use isset to test whether the POST values are set and only
include in
the
   query if there is a value.
 
   thanks .. but my question is not for isset... i m thinking
consider
that i
   have 10 search fields... if i have to do a combination then i need
a
day
   to right the various SQL statements
 
 So do something like:
 
 $query = SELECT id, name , lastname , m_date from users where 1 ;
 if (isset($_POST['name'])) {
$query .= AND name like binary '%{$-POST['name']}%' ;
 }
 if (isset($_POST['lastname'])) {
$query .= AND name like binary '%{$_post['lastname']}%' ;
 }
 //etc etc
 $query .=  order by id ASC ;
 $sql = mysql_query($query) or die(mysql_error());
 
 
 --
 David Robley
 
 Only cosmetologists give make-up exams.
 
 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php

 .
 . Ross Honniball. JCU Bookshop Cairns, Qld, Australia.
 .

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

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

[PHP-DB] subquery

[Brock Jimmy D Contr 74MDSS/SGSI]

I'm trying to use a delete subquery in Oracle (using SQL) and it is preventing me from 
deleting when no records are found in the SELECT statement.

 

DELETE roles WHERE roleid NOT IN (SELECT DISTINCT roleid FROM users WHERE 
roleid='Staff Member';

 

There are no records in the USERS table that has a roleid='Staff Members'

 

Any suggestions?

 

 

Jimmy Brock

Web Developer

 

[PHP-DB] using php to manage multiple databases

[frank dziuba]

Hi,

  I have a need to create a web interface that will be used to connect to many, 
separate MySQL databases.

Basically, it's a central php web application that will make connections to one of 
perhaps 500-1000 different MySQL servers to do some simple queries, then disconnect. 
Each server will be running the same data structures, so the php program will function 
the same for all servers, it just has to connect to a specific server to get the 
information it needs to present.

So, here's my question: Has anyone ever done something similar? Can php reliably open 
500 or so simultaneous connections to 500 or so different MySQL servers? Any feedback 
would be appreciated.

thanks

frank dziuba