[PHP-DB] MSAccess2000, SQL, and Escape Characters
Hey all... Does anyone know how Microsoft Access 2000 handles escaping apostrophes in SQL statements? I tried back-slashing (\') them out, but that didn't work (i.e, insert into blah values(1, 'Bob', 'Bob\'s stuff')). And since that didn't work, addslashes(), of course, didn't work either. Thanks. Later... -Ari
RE: [PHP-DB] Quotes, double-quotes, and the like.
I'm sorry -- what I meant was that the resulting link links to that. The browser inserts http://localhost; to the beginning of the link as if I had built a relative link rather than a specific complete one. In other words, the browser for some reason sees the double-quote as another normal character rather than the opening and closing ends of a link. Here's the HTML for the form I use: form method=post action=addnewrant_logic.php span class=textTitle:/spanbr input type=text name=title size=50nbsp; input type=radio name=type value=r checked=on Randomnbsp; input type=radio name=type value=c Currentbrbr span class=textText:/spanbr textarea name=text rows=30 cols=65/textareabrbr input type=submit nbsp; input type=reset /form Here's the code to add the rant: // Connect to the database and select the table we'll be using. $db_link = mysql_connect(c831806-a, root, catls-9) or die (we have no connection); $db = mysql_select_db(site, $db_link) or die (we have no database); $text = str_replace(\n, br, $text); $text = addslashes($text); $date = date(m/d/Y); // Write out everything that we have. echo hrDate: $datebr\nTitle: $titlebr\nType: $typebr\nText:br\n$texthr; $query = INSERT INTO rants SET date=\$date\, category=\$type\, title=\$title\, rtext=\$text\; $result = mysql_query($query, $db_link); echo brbrbrResult: $result; Thanks! Later... -Ari -Original Message- From: Justin Buist [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 8:32 AM To: Ari M. Roth Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Quotes, double-quotes, and the like. On Sun, 16 Sep 2001, Ari M. Roth wrote: I'm trying to create a web-based interface that will allow me to save essays to a mySQL database for display on a website. The problem is that it may include HTML in it, so I need to preserve double-quotes in their original context. Right now, they are not encoding correctly for some reason. An HTML link, for example, to http://www.yahoo.com would come out as this: http://localhost/http://www.yahoo.com; addslashes() accomplished nothing, and I'm at a loss. Any ideas? You should probably paste the HTML form and perhaps the PHP code which does the actual insersts -- it's completely illogical that http://localhost/; would magically appear before a field name. At least in my book. Justin Buist Trident Technology, Inc. 4700 60th St. SW, Suite 102 Grand Rapids, MI 49512 Ph. 616.554.2700 Fx. 616.554.3331 Mo. 616.291.2612 -- PHP Database 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 Database 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-DB] Quotes, double-quotes, and the like.
I'm trying to create a web-based interface that will allow me to save essays to a mySQL database for display on a website. The problem is that it may include HTML in it, so I need to preserve double-quotes in their original context. Right now, they are not encoding correctly for some reason. An HTML link, for example, to http://www.yahoo.com would come out as this: http://localhost/http://www.yahoo.com; addslashes() accomplished nothing, and I'm at a loss. Any ideas? Thanks. Later... -Ari -- PHP Database 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-DB] USA Attacks (Nostradamus -- Further Info)
A couple of links to back that up: http://www.snopes2.com/inboxer/hoaxes/predict.htm http://fury.com/article/925.php And the original essay that contains the quote: http://www.ed.brocku.ca/~nmarshal/nostradamus.htm Later... -Ari -Original Message- From: mail MTA [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 12, 2001 12:18 PM To: [EMAIL PROTECTED] Cc: Danny N. Subject: RE: [PHP-DB] USA Attacks Hi, A quote from another message I got may shed some light: quote I would like to address the interesting prophecy that you have attached. It, like several other Nostradamus prophecies that have been circulating on the internet recently, is a complete fabrication. The kernel of the quote was written by a Canadian college student named Neil Brock a few years ago as part of an essay to illustrate how vague language can be interpreted to fit any number of important events (he was writing ABOUT Nostradamus). It has subsequently been added to in the last 36 hours. I use the web site www.snopes.com as a quick cross check on anything that comes through from unverified channels on the internet and it saves a little worry in the long run. /quote With clearity, Roel Mulder At 10:28 12-09-2001 -0700, you wrote: Lars B. Jensen [EMAIL PROTECTED] wrote: Nostradamus died in 1566... I wonder who wrote or re-wrote that passage for the event... / LJ -Original Message- From: Danny N. [mailto:[EMAIL PROTECTED]] Sent: 13. september 2001 01:43 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] USA Attacks quite interesting from Nostradamus's passage!!! In the year of the new century and nine months,From the sky will come a great King of Terror... The sky will burn at forty-five degrees.Fire approaches the great new city... There will be a great thunder,Two brothers torn apart by Chaos, While the fortress endures,The great leader will succumb, The third big war will begin when the big city is burning --Nostradamus 1654 Mulder Technisch Advies Postbus 69 NL-2740 AB WADDINXVEEN tel. 0182-640184 fax. 0182-640185 http://www.mta.nl -- PHP Database 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 Database 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]
