Re: [PHP-WIN] Can someone explain to me....
YES! Jim Lucas - Original Message - From: "Asendorf, John" <[EMAIL PROTECTED]> To: "Php-Windows (E-mail)" <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 12:09 PM Subject: [PHP-WIN] Can someone explain to me > Can someone explain to me why everytime someone answers a question where the > answer includes the suggestion to use eregi_replace why someone has to chime > in to use the perl regexes? Are they really all that much faster than the > POSIX implementation? > > John > > - > John Asendorf - [EMAIL PROTECTED] > Web Applications Developer > http://www.lcounty.com - NEW FEATURES ADDED DAILY! > Licking County, Ohio, USA > 740-349-3631 > Nullum magnum ingenium sine mixtura dementiae fuit > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-WIN] Search Engine Problem
what does the code that displays the results look like?
jim
- Original Message -
From: "DL Neil" <[EMAIL PROTECTED]>
To: "Mark Sweeney" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, October 25, 2001 3:20 PM
Subject: Re: [PHP-WIN] Search Engine Problem
> I am using this piece of code to display news articles based on the
variables inputted by a user. However, it will only
> display one article, never more, even if more are within the terms of the
"WHERE" clause. What am I doing wrong?
>
> $search = mysql_query("SELECT news.ID, newstitle, newsdescription,
newsdate, author, email FROM news, authors WHERE
> $name LIKE '%$value%' AND authors.ID=AID ORDER BY news.ID DESC");
> if (!search) {
> echo("Sorry, there are no matches for what you are looking for. Please
try again");
> exit();
> }
>
>
>
> Mark,
> This piece of code interrogates MySQL and responds with a "result
identifier resource" or ResourceSet or ResultSet or
> RecordSet, depending upon your terminology. How do you thereafter 'unpack'
the rows from the resource set - using for eg
> mysql_fetch_assoc()? (else see manual)
> Have you tried copying that SELECT statement (substituting values
appropriately) and running it under native SQL or in a
> 'management tool', to be sure it actually works (regardless of PHP)?
> Regards,
> =dn
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-WIN] new problem... problem with Query...
try using single quotes
Jim
- Original Message -
From: "Todd Williamsen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 19, 2001 2:30 PM
Subject: [PHP-WIN] new problem... problem with Query...
> Here it is I get the error "cannot execute query" so there is
> something wrong with the SQL and I cannot figure it out...
>
>
> if ((!$FirstName) || (!$LastName)) {
> header("Location:
http://www.feminineforum.com/admin/pick_modcontact.php";);
> exit;
>
> } else {
>
> session_start();
>
> }
>
> if ($valid != "yes") {
> header("Location: http://www.feminineforum.com/admin/contact_menu.php";);
> exit;
>
> } else {
>
> session_register('valid');
>
> }
>
>
> $db_name = "feminineforum";
> $table_name = "tblmembers";
>
> $connection = @mysql_connect ("localhost", "feminine", "krmc33") or die
> ("Couldn't connect.");
>
> $db = @mysql_select_db ($db_name, $connection) or die("Couldn't select
> database.");
>
> $sql = "UPDATE $table_name
> SET
> FirstName = \"$FirstName\",
> LastName = \"$LastName\",
> Address1 = \"$Address1\",
> Address2 = \"$Address2\",
> City = \"$City\",
> State = \"$State\",
> Zip = \"$Zip\",
> HomePhone = \"$HomePhone\",
> WorkPhone = \"$WorkPhone\",
> Fax = \"$Fax\",
> Email = \"$Email\",
> UserId = \"$UserId\",
> Password = \"$Password\",
> WHERE id = \"$ID\"
> ";
>
> $result = @mysql_query($sql, $connection) or die ("Couldn't execute
> query.");
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-WIN] PHP IDE
NoteTab Pro - code it by hand. there are a few libraries out that for it that give examples of php/sql/etc http://www.notetab.com Jim - Original Message - From: "George Nicolae" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 19, 2001 10:49 AM Subject: [PHP-WIN] PHP IDE > can anyone suggest me a good php ide? I tried some freeware but a need a > real good one. > ps. also suggest the download address > > -- > > > Best regards, > George Nicolae > IT Manager > ___ > X-Playin - Professional Web Design > www.x-playin.f2s.com > > > > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-WIN] Re: [PHP] Problem outputting MySQL Date field
John Meyer wrote:
Devendra Jadhav wrote:
No need to do anything special. It should display date as string. Can
you provide little more information or code snippet?
$tweettable .=
preg_replace('@(https?://([-\w\.]+)+(:\d+)?(/([\w/_\.]*(\?\S+)?)?)?)@',
'$1',$row["TWEET_TEXT"]) . "" . "Sent at: " .
$rowqry["TWEET_CREATEDAT"];
$tweettable .= "Sent Using: " . $row["TWEET_CREATEDBY"] .
"";
And I checked the database. The date is there.
Two things jump out.
1. TWEET_CREATEDAT is that suppose to be TWEET_CREATEDATE ??
2. two variables are accessed from the $row array, but the third is referenced from the $rowqry
array. This begs the question: Which is it? $row or $rowqry ?
Try this
$tweettable .= preg_replace(
'@(https?://([-\w\.]+)+(:\d+)?(/([\w/_\.]*(\?\S+)?)?)?)@',
'$1',
$row["TWEET_TEXT"]);
$tweettable .= 'Sent at: ' . $row["TWEET_CREATEDATE"];
$tweettable .= 'Sent Using: {$row['TWEET_CREATEDBY']}";
--
Jim Lucas
"Some men are born to greatness, some achieve greatness,
and some have greatness thrust upon them."
Twelfth Night, Act II, Scene V
by William Shakespeare
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-WIN] HTTP Referer
you might want to see if track_vars is on? I know that I don't have problems with those _VARS when I use a form. Are you sure the they are in the right scope? Jim Lucas - Original Message - From: "Mihail Bota" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 27, 2001 7:38 AM Subject: [PHP-WIN] HTTP Referer > Hello, > > I am trying to use the HTTP_Referer (or any of its variants: SERVER_VARS, > ENV_VARS) to keep track of the URL of pages that are passed through forms. > Any of these variables do not work, as it is clearly stated in the > documentation, when one uses forms. Is there any way to see the URL, even > though I am using forms? > > I use W2k and IIS 5 > > Thanks. > > > Mihai > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-WIN] HTTP Referer
it still does that even though you are saying $GLOBALS[HTTP_REFERER] ?? - Original Message - From: "Mihail Bota" <[EMAIL PROTECTED]> To: "Jim Lucas [php]" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, December 27, 2001 11:26 AM Subject: Re: [PHP-WIN] HTTP Referer > Yes, I think those are on, because when I use the phpinfo, the > HTTP_REFERER givces the URL of the previous link... even though I passed > through the form. > > Anyway, now I am scrambling to adjust all forms in such a way that the > scripts will run only when I am moving forward, and not backward... > Thanks > > > Mihai > On Thu, 27 Dec 2001, Jim Lucas [php] wrote: > > > you might want to see if track_vars is on? I know that I don't have > > problems with those _VARS when I use a form. Are you sure the they are in > > the right scope? > > > > Jim Lucas > > - Original Message - > > From: "Mihail Bota" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Thursday, December 27, 2001 7:38 AM > > Subject: [PHP-WIN] HTTP Referer > > > > > > > Hello, > > > > > > I am trying to use the HTTP_Referer (or any of its variants: SERVER_VARS, > > > ENV_VARS) to keep track of the URL of pages that are passed through forms. > > > Any of these variables do not work, as it is clearly stated in the > > > documentation, when one uses forms. Is there any way to see the URL, even > > > though I am using forms? > > > > > > I use W2k and IIS 5 > > > > > > Thanks. > > > > > > > > > Mihai > > > > > > > > > -- > > > PHP Windows Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-WIN] mail to too many users
with php's mail() funciton you can send to multiple recipents via the headers. just build the headers so it will BCC to everybody at once. one word of caution, you can only have a header that is 5kb or smaller. otherwise php will start truncating the header. Found that out the hard way. so, just build a big header and send out 300 at a time. Jim Lucas - Original Message - From: "Mostafa Al-Mallawani" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 28, 2002 11:41 AM Subject: [PHP-WIN] mail to too many users > I need to send an email to 19000 users using a script, any suggestions. > Looping on a result set using the mail function would kill the server. > I know it can be done using a mailing list module but I'm running a > windows machine with IIS, what's the best thing for this? Thanks. > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
