[PHP-DB] PHP5 instalation on SuSE 10.2
HI I've got a problem during instalation php on SuSE I try to do this code in shell sh ./configure --enable-versioning --with-layout=GNU --with-config-file-scan-dir=/usr/local/etc/php --enable-libxml --with-gd --with-mysql all is ok but last report lines are: checking for specified location of the MySQL UNIX socket... no checking for MySQL UNIX socket location... /var/lib/mysql/mysql.sock configure: error: Cannot find MySQL header files under yes. Note that the MySQL client library is not bundled anymore! What I should do?? Apache2 and MySQL5 is corectly installed, I check it Thx in advance -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mssql and client encoding
Hi, how can I set client encoding on mssql connection? I can connect, but data are win1250 in db and web in utf8. SET NAMES do not work nor php.ini directive mssql.charset = UTF-8 / UTF8 WindowsXP Home/Pro Apache 2.2 PHP 5.2 (apache module) Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Thanks Fanda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] SELECT string
Businesses
--
id
businessName
isChristianBookstore
isGift
isHomeDecor
isSkinCareAndCosmetics
isThriftStore
CREATE TABLE `Businesses` (
`id` BIGINT NOT NULL AUTO_INCREMENT ,
`businessName` VARCHAR( 64 ) NOT NULL ,
`isChristianBookstore` TINYINT( 1 ) NOT NULL ,
`isGift` TINYINT( 1 ) NOT NULL ,
`isHomeDecor` TINYINT( 1 ) NOT NULL ,
`isSkinCareAndCosmetics` TINYINT( 1 ) NOT NULL ,
`isThriftStore` TINYINT( 1 ) NOT NULL ,
PRIMARY KEY ( `id` )
) TYPE = MYISAM ;
?php
$DbFieldByFormFieldMap = array(
'category_1' = 'isChristianBookstore',
'category_42' = 'isGift',
'category_44' = 'isHomeDecor',
'category_43' = 'isSkinCareAndCosmetics',
'category_17' = 'isThriftStore'
);
$sql = SELECT `id`, `businessName` FROM `Businesses` WHERE ;
foreach($_POST as $formField = $formValue){
if(substr($formField, 0, 9) == category_ substr($formValue, -1)
== a){//Handle any Not Selected
$sql .= ` . $DbFieldByFormFieldMap[$formField] . ` = '0'
AND ;
}
if(substr($formField, 0, 9) == category_ substr($formValue, -1)
== b){//Handle any Must Include
$sql .= ` . $DbFieldByFormFieldMap[$formField] . ` = '1'
AND ;
}
}
if(substr($sql, -4) == AND ){
$sql = substr($sql, 0, -4);
}else{
$sql .= 1;
}
echo SQL:$sql;
?
It was getting a tad complicated with the Could Include using OR and
testing for the end of the existing $sql string, but the Could Include's
just need to be omitted from the SQL query altogether.
Regards,
Dwight
God Bless!
-Original Message-
From: Ron Piggott [mailto:[EMAIL PROTECTED]
Sent: Monday, April 23, 2007 11:31 PM
To: PHP DB
Subject: [PHP-DB] SELECT string
I am looking for help to write a SELECT syntax to help me process a
directory searching query tool I am developing.
If you start at
http://www.actsministrieschristianevangelism.org/ministrydirectory/ and
under 'Step 1:' click Business a form is displayed.
My question is how would you generate the SELECT syntax for the search
results Could Include a given category and Must Include a given
category based on what the user has inputted through this form?
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Access another server aspx page
Hi All, I need to access .aspx page using .php page. It's like this. 01) I have a login.aspx home.aspx pages in different server (IIS6, already hosted at different location: www.abc.com/login.aspx ). 02) I have the username password for login to the above application (home.aspx) 03)I need to go to home.aspx page, bypassing login.aspx page. (using php page: http://localhost/bypass.php ) * Is there is a possibility to control www.abc.com/login.aspx page events. Ex: login.aspx page have 2 text boxes login button. I mean is it possible to handle login.aspx's login button's click event? * Is it possible to do my requirement using php curl function? * Or do you all have any suggestions? Thanking you, Best regards, Lasitha DOTW DISCLAIMER: This e-mail and any attachments are strictly confidential and intended for the addressee only. If you are not the named addressee you must not disclose, copy or take any action in reliance of this transmission and you should notify us as soon as possible. If you have received it in error, please contact the message sender immediately. This e-mail and any attachments are believed to be free from viruses but it is your responsibility to carry out all necessary virus checks and DOTW accepts no liability in connection therewith. This e-mail and all other electronic (including voice) communications from the sender's company are for informational purposes only. No such communication is intended by the sender to constitute either an electronic record or an electronic signature or to constitute any agreement by the sender to conduct a transaction by electronic means. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
