Re: [PHP] Re: Using PHP Credit Card orders
Were you looking for online autho handlers or mod checks? Phil Schwarzmann[EMAIL PROTECTED] 04/01/03 08:29AM Where can I find information on using PHP along with secure online Credit Card orders? Thanks! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] HELP HELP in a stand still
I dont know where my brain is today, obviously not with me. I had this working yesterday and then a server crash casued them to run the backup from teh day before and wiped all my work out. Can someone please get me back on track. HEre is the problem. I want to list a collection of items. Standard list. Within that list I want the selection of items that meet x criteria to be bolded and not to have a checkbox. I have that working fine, but its displaying the collection list three times, instead of once. I for the life of me cant remember what I did yesterday. http://www.heathermccullough.com/copelands/administration/new_store/build-d.php thanks _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] strip single quotes
I have this code in to try and strip single quotes out. But it does it to
one but not the rest.
$address = str_replace(\\\///, , $store['address']);
$address = str_replace(', , $address);
$address = str_replace(', \', $address);
$address = addslashes($address);
$sql2 = SELECT * FROM store_name WHERE name = '.$store['name'].';
//$build_sql .= $sql2.br;
$result2 = mysql_query($sql2) or die(mysql_error());
$store_name = mysql_fetch_array($result2);
$sql3 = SELECT * FROM store_address WHERE address = '.$address.';
any thoughts
From: John W. Holmes [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: 'Daniel McCullough'
[EMAIL PROTECTED],[EMAIL PROTECTED]
Subject: RE: [PHP] strip single quotes
Date: Wed, 19 Mar 2003 21:49:10 -0500
MIME-Version: 1.0
Received: from dc-mx03.cluster1.charter.net ([209.225.8.13]) by
mc10-f34.bay6.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Wed, 19
Mar 2003 19:04:29 -0800
Received: from [68.117.196.146] (HELO coconut) by
dc-mx03.cluster1.charter.net (CommuniGate Pro SMTP 3.5.9) with ESMTP id
107067803; Wed, 19 Mar 2003 21:51:20 -0500
X-Message-Info: JGTYoYF78jEHjJx36Oi8+Q1OJDRSDidP
Organization: U.S. Army
Message-ID: [EMAIL PROTECTED]
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook, Build 10.0.3416
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
In-Reply-To: [EMAIL PROTECTED]
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 20 Mar 2003 03:04:29.0882 (UTC)
FILETIME=[6C8DB1A0:01C2EE8D]
I'm trying to query the database using a string pulled out of the
database
and compare and get the id. I can do it to a certain point and what
kills
my query is single quotes. I CANNOT figure out how to escape it.
I DID THIS:
$address2 = str_replace(', , $address);
that worked on some, but not all.
$address = stripslashes($store['address']);
$address = str_replace(', , $address);
$address = htmlspecialchars($address);
$address = addslashes($address);
anyone
Some errors I have gotten back
You have an error in your SQL syntax near 's Linen Home'' at line
1
and
You have an error in your SQL syntax near 's 800 number.'' at line 1
You need to use addslashes() on any string you insert into your query.
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/
_
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] strip single quotes
another question is could this becoming from the table I am comparing it
too?
SELECT * FROM store_address WHERE address = '.$address.'
where $address is fine but the other table is causing the error. how do I
strip that result as well?
I have this code in to try and strip single quotes out. But it does it to
one but not the rest.
$address = str_replace(\\\///, , $store['address']);
$address = str_replace(', , $address);
$address = str_replace(', \', $address);
$address = addslashes($address);
$sql2 = SELECT * FROM store_name WHERE name = '.$store['name'].';
//$build_sql .= $sql2.br;
$result2 = mysql_query($sql2) or die(mysql_error());
$store_name = mysql_fetch_array($result2);
$sql3 = SELECT * FROM store_address WHERE address = '.$address.';
any thoughts
From: John W. Holmes [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: 'Daniel McCullough'
[EMAIL PROTECTED],[EMAIL PROTECTED]
Subject: RE: [PHP] strip single quotes
Date: Wed, 19 Mar 2003 21:49:10 -0500
MIME-Version: 1.0
Received: from dc-mx03.cluster1.charter.net ([209.225.8.13]) by
mc10-f34.bay6.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Wed, 19
Mar 2003 19:04:29 -0800
Received: from [68.117.196.146] (HELO coconut) by
dc-mx03.cluster1.charter.net (CommuniGate Pro SMTP 3.5.9) with ESMTP id
107067803; Wed, 19 Mar 2003 21:51:20 -0500
X-Message-Info: JGTYoYF78jEHjJx36Oi8+Q1OJDRSDidP
Organization: U.S. Army
Message-ID: [EMAIL PROTECTED]
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook, Build 10.0.3416
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
In-Reply-To: [EMAIL PROTECTED]
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 20 Mar 2003 03:04:29.0882 (UTC)
FILETIME=[6C8DB1A0:01C2EE8D]
I'm trying to query the database using a string pulled out of the
database
and compare and get the id. I can do it to a certain point and what
kills
my query is single quotes. I CANNOT figure out how to escape it.
I DID THIS:
$address2 = str_replace(', , $address);
that worked on some, but not all.
$address = stripslashes($store['address']);
$address = str_replace(', , $address);
$address = htmlspecialchars($address);
$address = addslashes($address);
anyone
Some errors I have gotten back
You have an error in your SQL syntax near 's Linen Home'' at line
1
and
You have an error in your SQL syntax near 's 800 number.'' at line 1
You need to use addslashes() on any string you insert into your query.
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/
_
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
_
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] error message ... never seen this one before.
I get this error.
Unknown column 'B' in 'where clause'
From this code.
$sql = SELECT * FROM store;
$result = mysql_query($sql) or die(mysql_error());
$store = mysql_fetch_array($result);
$count = mysql_num_rows($result);
$id = $store['id'];
$name = $store['name'];
$address = $store['address'];
$state = $store['state'];
$groups = $store['groups'];
for ($i=0; $i$count; $i++) {
$sql2 = SELECT id FROM store_name WHERE name = .$name[$i].;
$result2 = mysql_query($sql2) or die(mysql_error());
$store_name = mysql_fetch_object($result2);
$sql3 = SELECT id FROM store_address WHERE address = .$address[$i].;
$result3 = mysql_query($sql3) or die(mysql_error());
$store_address = mysql_fetch_object($result3);
$sql4 = SELECT id FROM store_state WHERE state_name = .$state[$i].;
$result4 = mysql_query($sql4) or die(mysql_error());
$store_state = mysql_fetch_object($result4);
$build_sql .= $id. - .$store_name. - .$store_address. -
.$store_state. - .$groups[$i].br\n;
}
any thoughts?
_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] strip single quotes
I'm trying to query the database using a string pulled out of the database
and compare and get the id. I can do it to a certain point and what kills
my query is single quotes. I CANNOT figure out how to escape it.
I DID THIS:
$address2 = str_replace(', , $address);
that worked on some, but not all.
$address = stripslashes($store['address']);
$address = str_replace(', , $address);
$address = htmlspecialchars($address);
$address = addslashes($address);
anyone
Some errors I have gotten back
You have an error in your SQL syntax near 's Linen Home'' at line 1
and
You have an error in your SQL syntax near 's 800 number.'' at line 1
_
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Flash book help please
My wife is a designer, not a technical person. She is learning Flash and she needs a book to learn and learn quickly how to do some things like click actions for a project. Can someone please give me an idea of 2-3 good flash books. _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] complicated but fun, please help.
Okay here is what I have. I thought this was going to be a wham bam slam dunk. I need to update the poppasswd file on a Plesk system, I have it so the Plesk database gets updated, but I need to let people change their password from a web form, without having them need to login to the Plesk system. Where I am having problems at is when they need to update the poppasswd, which is a IMAP or QMAIL file. Plesk has files that will update the system, but it seems that I using the exec() and system() I can access those pl files. From the command prompt it works fine, html/php file doesnt work. Any thoughts? I would really appreciate the help, I'm doing this as a favor and would like to clear this off my plate. _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] complicated but fun, please help.
Yes sorry for not being clear. I am trying to use exec() and system(). I guess I'm trying to see if there is another way to do it, like write to a file and have acron job run every minute or so, or if there is some way to make it seem like I am doing this with the right permissions. From: Erik Price [EMAIL PROTECTED] To: Daniel McCullough [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: [PHP] complicated but fun, please help. Date: Mon, 17 Mar 2003 16:55:52 -0500 MIME-Version: 1.0 Received: from mxrelay.ptc.com ([12.11.148.30]) by mc5-f40.law1.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Mon, 17 Mar 2003 13:58:28 -0800 Received: from HQ-EXFE4.ptcnet.ptc.com (localhost [127.0.0.1])by mxrelay.ptc.com (8.9.0/8.9.0) with ESMTP id QAA22956;Mon, 17 Mar 2003 16:58:27 -0500 (EST) Received: from hq-mail1.ptcnet.ptc.com ([132.253.201.69]) by HQ-EXFE4.ptcnet.ptc.com with Microsoft SMTPSVC(5.0.2195.5329); Mon, 17 Mar 2003 16:56:11 -0500 Received: from ptc.com ([132.253.96.61]) by hq-mail1.ptcnet.ptc.com with Microsoft SMTPSVC(5.0.2195.5329); Mon, 17 Mar 2003 16:56:11 -0500 X-Message-Info: JGTYoYF78jEHjJx36Oi8+Q1OJDRSDidP Message-ID: [EMAIL PROTECTED] User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.2.1) Gecko/20021130 X-Accept-Language: en-us, en References: [EMAIL PROTECTED] In-Reply-To: [EMAIL PROTECTED] X-OriginalArrivalTime: 17 Mar 2003 21:56:11.0113 (UTC) FILETIME=[059A0D90:01C2ECD0] Return-Path: [EMAIL PROTECTED] Daniel McCullough wrote: Where I am having problems at is when they need to update the poppasswd, which is a IMAP or QMAIL file. Plesk has files that will update the system, but it seems that I using the exec() and system() I can access those pl files. From the command prompt it works fine, html/php file doesnt work. Any thoughts? I would really appreciate the help, I'm doing this as a favor and would like to clear this off my plate. You probably are logged into the command prompt as a different user than what the PHP binary runs as. If the PHP binary runs as a user named apache, and you log in as dmcullough or root, and the commands you are trying to execute are restricted only to being run by dmcullough or a group that dmcullough is in but apache is not, then PHP won't run them. I'm assuming that you are using the system() or exec() commands, your email is a little difficult to understand in that respect... sorry. Erik _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
