RE: [PHP-DB] Oracle syntax
It can be found here: http://us3.php.net/manual/en/ref.oracle.php MAO -Original Message- From: Rafi Sheikh [mailto:[EMAIL PROTECTED] Sent: Thursday, June 10, 2004 9:33 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Oracle syntax Hi list. I am a newbie and would like to ask if anyone could give me the proper syntax for connecting with oracle DB. For example with MySQL it is: mysql_connect..., mysql_query... For MS SQL Server: mssql_connect..., mssql_query... What would be for oracle? TIA RS This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- 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] escape character
Title: Message \"Fees and Expenses.\" Quick question: I am sending email via a simple script: \"QUOTED TEXT.\" is in the body of the message with escape characters. When the mail is sent and arrives the \ (escape characters)are stillin the email text, any way to remove them an not break the script? $headers = "From: $name $email\n"; $headers .= "Cc: $Name $email\n"; $headers .= "X-Sender: $email\n"; $headers .= "X-Mailer: $Name\n"; $headers .= "X-Priority: 1\n"; $headers .= "Return-Path: $email"; $recipient = "$user_first $user_last $user_email"; $subject = "$Subject"; $message = "Dear $First $Last,\n"; $message .= "\n"; $message .= "Example text here \"QUOTED TEXT.\" \n"; $message .= "\n"; $message .= "Example text here \"QUOTED TEXT.\"\n"; $message .= "\n"; $message .= "Example text here \"QUOTED TEXT.\"\n"; $message .= "\n"; $message .= "$Name\n"; $message .= "$Company\n"; $message .= "$Phone \n"; mail($recipient, $subject, $message, $headers); Thanks, MAO
[PHP-DB] Related Tables - Capture ID
Hello, I have three table in which I am inserting records into in one script. I need to capture the ID of the second tables record insertion to insert into a field into a related table in the third. What would the easiest way to go about this in php? Thanks, MAO -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Cookie issue
We are having complaints on our site about users not being able to log-in
and we feel it maybe related to the setting of cookie. Here is the code
used. Can anyone give me insight.
/* some standard var's or other things like srand */
srand((double)microtime() * 100);
$includes_root = $DOCUMENT_ROOT/includes;
$encoded_url= urlencode($REQUEST_URI);
if($_COOKIE[cookie_check] != Y)
{
setcookie(cookie_check, Y, strtotime(+5 years), /,
$HTTP_HOST, 0);
}
if($_COOKIE[current_surfer_id] == AND $_COOKIE[cookie_check] ==
Y)
{
$current_surfer_id = rand(0, 16777215);
setcookie(current_surfer_id, $current_surfer_id, strtotime(+5
years), /, $HTTP_HOST, 0);
}
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Cookie issue
To add to this message:
We are having problems with people using IE 6.0. They appear to sign-in and
then are returned to the sign-in screen over and over. This doesnt happen
to all that use the site.
Thanks in advance
-Original Message-
From: Marie Osypian [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 10:03 AM
To: PHP-DB
Subject: [PHP-DB] Cookie issue
We are having complaints on our site about users not being able to log-in
and we feel it maybe related to the setting of cookie. Here is the code
used. Can anyone give me insight.
/* some standard var's or other things like srand */
srand((double)microtime() * 100);
$includes_root = $DOCUMENT_ROOT/includes;
$encoded_url= urlencode($REQUEST_URI);
if($_COOKIE[cookie_check] != Y)
{
setcookie(cookie_check, Y, strtotime(+5 years), /,
$HTTP_HOST, 0);
}
if($_COOKIE[current_surfer_id] == AND $_COOKIE[cookie_check] ==
Y)
{
$current_surfer_id = rand(0, 16777215);
setcookie(current_surfer_id, $current_surfer_id, strtotime(+5
years), /, $HTTP_HOST, 0);
}
--
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] Email an attached file
I am using something like this example code below to send e-mail and wondered if anyone could tell me how I could include a file also in this email if possible. Thanks in advance. Marie EXAMPLE: $myname = Me Myself; $myemail = [EMAIL PROTECTED]; $contactname = Mister Contact; $contactemail = [EMAIL PROTECTED]; $message = hello from happy me; $subject = Included your file; $headers .= MIME-Version: 1.0\r\n; $headers .= Content-type: text/html; charset=iso-8859-1\r\n; $headers .= From: .$myname. .$myemail.\r\n; $headers .= To: .$contactname. .$contactemail.\r\n; $headers .= Reply-To: .$myname. $myreplyemail\r\n; $headers .= X-Priority: 1\r\n; $headers .= X-MSMail-Priority: High\r\n; $headers .= X-Mailer: Just My Server; mail($contactemail, $subject, $message, $headers); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Email an attached file
I am storing the file on my server.
-Original Message-
From: Dan Brunner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2003 2:42 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Email an attached file
Hello!!
If your storing the file name, file type, in mysql; and are storing
the files on a server.
(Which you should be doing!!!)
You could use this!!
//
$query = SELECT * FROM Images WHERE Num = $num;
$result = mysql_query ($query, $db);
$data = mysql_fetch_object($result);
function sendfile($to, $subject, $text, $cc, $from, $file, $type) {
$content = fread(fopen($file,r),filesize($file));
$content = chunk_split(base64_encode($content));
$uid = strtoupper(md5(uniqid(time(;
$name = basename($file);
$text = stripslashes($text);
$subject = stripslashes($subject);
$header = From: $from\nReply-To: $from\n;
$header .= Cc: $cc\n;
$header .= MIME-Version: 1.0\n;
$header .= Content-Type: multipart/mixed; boundary=$uid\n;
$header .= --$uid\n;
$header .= Content-Type: text/plain\n;
$header .= Content-Transfer-Encoding: 8bnoit\n\n;
$header .= $text\n;
$header .= \n;
$header .= \n;
$header .= --$uid\n;
$header .= Content-Type: $type; name=\$name\\n;
$header .= Content-Transfer-Encoding: base64\n;
$header .= Content-Disposition: attachment; filename=\$name\\n\n;
$header .= $content\n;
$header .= --$uid--;
mail($to, $subject, , $header);
}
$file2 = (./images/$data-name);
$type = ($data-filetype);
$mess .= (\n);
$mess .= (\n);
$mess .= (\n);
$mess .= (\n);
$mess .= (Here is that Pic you wanted...);
sendfile($To, $sub, $mess, $cc, $From, $file2, $type);
//-
Of course all of the $To,$sub,etc...etc...etc...are from posting the
data from a form.
I think you can figure out the rest
Good luck!!
Dan Brunner
On Wednesday, May 28, 2003, at 01:12 PM, [EMAIL PROTECTED]
wrote:
www.phpclasses.org is your best bet. there are plenty. personally i
use
this one..http://phpclasses.com/browse.html/package/32.html
check out his site for examples.
hth
jd
Marie Osypian
[EMAIL PROTECTED] To:
[EMAIL PROTECTED]
llege.com cc:
Subject: [PHP-DB]
Email an attached file
05/28/2003 02:08 PM
I am using something like this example code below to send e-mail and
wondered if anyone could tell me how I could include a file also in
this
email if possible.
Thanks in advance.
Marie
EXAMPLE:
$myname = Me Myself;
$myemail = [EMAIL PROTECTED];
$contactname = Mister Contact;
$contactemail = [EMAIL PROTECTED];
$message = hello from happy me;
$subject = Included your file;
$headers .= MIME-Version: 1.0\r\n;
$headers .= Content-type: text/html; charset=iso-8859-1\r\n;
$headers .= From: .$myname. .$myemail.\r\n;
$headers .= To: .$contactname. .$contactemail.\r\n;
$headers .= Reply-To: .$myname. $myreplyemail\r\n;
$headers .= X-Priority: 1\r\n;
$headers .= X-MSMail-Priority: High\r\n;
$headers .= X-Mailer: Just My Server;
mail($contactemail, $subject, $message, $headers);
--
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 Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Store
I was wondering if anyone was using a good store that was open sourced in php. Marie O -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Time entry program
Hi, I was looking for a basic time entry program for people to sign-in and sign-out. Like a time clock for example. Does anyone know of one out there already? Thanks, Marie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Email to a list of address in your database.
Hi,
I have a list of email address in a mysql database and I would like to
create a link that when clicked pulls up your my mail program and mails to
everyone in the database.
a href=mailto:ARRAY OF EMAIL ADDRESSMail to everyone/a
Here is my code:
pBr
? $userquery = select * from users;
$myuserquery = mysql_query($userquery, $connection) or
die(Couldn't execute query.);
while($myresult = mysql_fetch_array($myuserquery)) {
$emailAddress = $myresult['emailAddress'];
$to[] = $emailAddress;
} $maxTo = count($to);
for($count = 0; $count $maxTo; $count++) {
$mailTo = $to[$count];
}
?
pa href=mailto:?=$mailTo;?mail To all my list/a
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
