[PHP-DB] Re: [PHP] Temporary MySQL Tables
On Thu, 21 Mar 2002, Georgie Casey wrote: -Hi, - -membership with the username and timestamp in the URL. The users clicks it, -and I run a SQL command that copies the row from tempmembers into the -members table. I assume you are building up all your fields as you move through the site. I would just perform an INSERT into your tempmebers table right away setting whatever fields you have at this point. Then as I pass through each data entry page, I would do UPDATES to that record updating only those new fields, leaving the old ones alone and thus preserved. This way you only have to pass a record ID and the new parameters on each page thus eliminating moving data through the URL. Yuk. Anyway, that's what I would do. - -This process worked well for a while until I discovered if users enter a -single or double quote into any of the fields, it fecks everything up. So I -added an addslashes command but it's all getting a bit hairy so I was -looking for some advice on MySQL temporary tables for either using after -every form or at the end of all the forms. - -Or does anyone have any other method I could use??? Thanks for any help -you might have. - - - --- -PHP General Mailing List (http://www.php.net/) -To unsubscribe, visit: http://www.php.net/unsub.php - ** John Huggins VANet [EMAIL PROTECTED] http://www.va.net/ ** -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] TEXT fields without line breaks
The line breaks may be there, but HTML will not render them. Try this: $outputstring = nl2br($stringfromDB); print(p$outputstring/p); or something like this to see if the newlines will convert to br and render correctly. John On Fri, 6 Jul 2001, Mat Marlow wrote: -Hi all, -(I'm not sure if this is the right place to submit this but I'm having -problems with the php.general group) - -I am in desperate need for a solution to HTML text fields not storing new -lines. I'm storing news articles in a database but all the text just ends up -in a big block because it ignores line breaks. Is there a way around this -without having to upload text files? - -Thanks, - -Mat - - - - - --- -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] - ** John Huggins Virginia Net Corporation 7101 Oriole Avenue Springfield, VA 22150 703-912-6214 703-912-4831 fax [EMAIL PROTECTED] http://www.va.net/ ** -- 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] front end for mysql for use on my website
Try phpMyAdmin. On Fri, 6 Jul 2001, Ed Peddycoart wrote: -I am looking for a front end for mysql for use on my website. What I want -is something that I can run, from the server (my webhost will not allow -remote connections to the mysql server), that allows me to insert, delete, -and modify records into a mySql database. Requirements are that it be -free, preferrably written in PHP and not require a knowledge of SQL. -Anything out there that can do this? - - - --- -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] - ** John Huggins Virginia Net Corporation 7101 Oriole Avenue Springfield, VA 22150 703-912-6214 703-912-4831 fax [EMAIL PROTECTED] http://www.va.net/ ** -- 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] Distributed Tables vs. fewer Monster Tables
I am putting the finishing touches on a forum program which has a direct lineage (look and feel at least) to Matt Wright's WWWBoard perl script. Remember that? Today I have one table per forum. The forums on my live test site are huge. http://www.astronomy.net/forums/ I have long dreamed of combining all the messages into one big honking table in MySQL and parse accordingly. I already know how to do this, but wonder the following: - Will MySQL lookup performance suffer... much? - Is this just not a good idea? - Will this make MySQL just flat out quit? I have heard the hype behind MySQL being able to handle incredible amounts of data with relative ease. I hear that MySQL does a good job when you are doing mostly reads as is the case here. So far, I have had absolutly no issues with MySQL and just love it. Thus, I am automatically biased. So what say you non-biased folks about data management for a multi-topic forum where each forum has identical structure, but differ only in topic? Combine and simplify? or Divide and conquer? John ** John Huggins Virginia Net Corporation 7101 Oriole Avenue Springfield, VA 22150 703-912-6214 703-912-4831 fax [EMAIL PROTECTED] http://www.va.net/ ** -- 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] Handling Linefeeds in MySQL/PHP
Try nl2br() http://www.php.net/manual/en/function.nl2br.php On Tue, 3 Jul 2001, Bessette, Casey wrote: -I am creating a content management page that uses a textarea box to enter a -chunk of text which then is sent into the database into a text-type field. - -I am finding that when the data is retrieved to be shown in the browser that -the line feeds are lost. I don't want users to have to know HTML to put -tags in themselves. What's the best way to handle this? - -Can I read from the database and insert br's and p's to be put into the -displayed HTML? Or, instead, is there a way to put the br's and p's -immediately into the database when the record is inserted? How can I do -this? How would the string be manipulated? - -Thanks for your help, --Casey - --- -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] - ** John Huggins Virginia Net Corporation 7101 Oriole Avenue Springfield, VA 22150 703-912-6214 703-912-4831 fax [EMAIL PROTECTED] http://www.va.net/ ** -- 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] adding Carrol O'Conner in a form
On Sat, 30 Jun 2001, Ken Sommers wrote: -but how do I get rid of that pesky slash \ ? - -so I can echo exactly what the user typed in? - Try: stripslashes() -I am already using: - - ?php echo(htmlspecialchars ($name, ENT_QUOTES)); ? - -Thanks for the help, - -ken - ** John Huggins Virginia Net Corporation 7101 Oriole Avenue Springfield, VA 22150 703-912-6214 703-912-4831 fax [EMAIL PROTECTED] http://www.va.net/ ** -- 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] Re: adding Carrol O'Conner in a form
+-*-On Mon, 2 Jul 2001, Angela Meehan wrote: -This is automatically done by something called MagicQuotes. You can -turn this off in your installation of PHP. - Yes, and if you do not have control over the server you can usually control this with the .htaccess file. To turn on... php_value magic_quotes_gpc 1 to turn off... php_value magic_quotes_gpc 0 -- 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]