Re: Best Practice-HTML In Database

From: Date: Mon, 30 Apr 2001 03:49:23 +0000
Subject: Re: Best Practice-HTML In Database
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-50826@lists.php.net to get a copy of this message
Using an URL to point to an HTML page or file is better. Inserting the HTML page in the database would cause: a) more database requests and thus heavy load on the database b) large amount traffic between the database server and the web server At my previous company we even ended up removing the text from the database and placing it as files on the disk... --- John Monfort <monfort@kahuna.engineering.sdsu.edu> wrote: > > Hello everyone, > > I'm curious. Which is the better practice? > 1) Insert the HTML page (...HTML code) in the > database ? > > or > > 2) Insert a URL in the database field, that > points to the HTML page? > > > why? > > Any help will be appreciated. > > Btw, thank you all for helping with my previous > questions. > > ==FOLLOW-UP ==-================ > = PHP Ultradev Browser Model == > =============================== > > FYI > For those who care about the PHP-Ultradev Server > Model (PHAKT). > I finally got it to work. Everything works for > MySQL. > However, you have to make some manual changes for > it to work with MS > Access. The changes are as follow: > > 1) You have to add the 'Access' or 'ODBC' > "Connection Type", in the > server model's CONNECTION File > (accessed via Modify->Connection->New). > > To do so: > a) open (from the Ultradev Configuration > folder) > > Connection->PHP->Win->Connection_php_adodb.htm > > b) add the value pairs access/access, and/or > odbc/odbc, to the > dropdown list for 'Connection Type'. > > Without this, you can only select MySQL as > the connection type. > This means that ADOBD will use the wrong > drivers to connect to > your DB. > > 2) There is an ERROR in the ADODB ODBC > configuration file. The ODBC > file has a format error in the ODBC connection > call. > (Site Root Folder ->ADODB->adodb-odbc.inc.php) > > The file tries to connect (to the DB) with > > $dbh = odbc_connect ('$hostname', > $username,$password); > > That is an error. The correct format is > > $dbh = odbc_connect ('$DSN_NAME', $username, > $password); > > You do not need to specify the host, for an ODBC > connection. That > information is already listed in the DSN > description. > > > Once that's done. You'll be able to use Ultradev > with PHP. > > I hope that helped. > > -John > > Again, thanks to everyone who helped me find this > extension. > Don't forget my new question :) see above. > > > > > __________John Monfort_________________ > _+-----------------------------------+_ > P E P I E D E S I G N S > www.pepiedesigns.com > "The world is waiting, are you ready?" > -+___________________________________+- > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: > php-general-unsubscribe@lists.php.net > For additional commands, e-mail: > php-general-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > __________________________________________________ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/

« previous php.general (#50826) next »