RE: [PHP] Best Practice-HTML In Database
-Original Message- From: John Monfort [mailto:[EMAIL PROTECTED]] Sent: Monday, April 30, 2001 5:08 PM To: Mark Roedel Cc: [EMAIL PROTECTED] Subject: RE: [PHP] Best Practice-HTML In Database Yes, I will need to provide searching capabilities. Basically, I'm creating an online referencing system with a db backend. A user will be able to search for a manual, and/or browse to a particular section of the manual. It's similar to the online PHP manual...at least, in concept. So, in the long run, which will be more beneficial: 1) HTML code inside the db fields? or 2) HTML URL inside the field? Well, I know I'm going against most of the rest of the responses you've gotten, but if you think you're going to need to do databasey things with the material, it makes sense to me to put it in a database. Having said that, I do agree with a lot of what the other posters have said regarding things like the impact on ease of maintenance, waste of storage space, etc. If it were me, I think I'd be looking for a way to only store the actual text in the database, with some PHP scripting to apply whatever formatting/template is needed to generate the page you want to present. --- Mark Roedel ([EMAIL PROTECTED]) || There cannot be a crisis next week. Systems Programmer / WebMaster || My schedule is already full. LeTourneau University ||-- Henry Kissinger -- PHP General 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] Best Practice-HTML In Database
-Original Message- From: John Monfort [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 29, 2001 10:40 PM To: [EMAIL PROTECTED] Subject: [PHP] Best Practice-HTML In Database 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? Will you ever want to do database-ish things with the contents of the page? (Allow somebody to search for words or phrases in the body, for example?) --- Mark Roedel ([EMAIL PROTECTED]) || There cannot be a crisis next week. Systems Programmer / WebMaster || My schedule is already full. LeTourneau University ||-- Henry Kissinger -- PHP General 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] Best Practice-HTML In Database
Yes, I will need to provide searching capabilities. Basically, I'm creating an online referencing system with a db backend. A user will be able to search for a manual, and/or browse to a particular section of the manual. It's similar to the online PHP manual...at least, in concept. So, in the long run, which will be more beneficial: 1) HTML code inside the db fields? or 2) HTML URL inside the field? __John Monfort_ _+---+_ P E P I E D E S I G N S www.pepiedesigns.com The world is waiting, are you ready? -+___+- On Mon, 30 Apr 2001, Mark Roedel wrote: -Original Message- From: John Monfort [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 29, 2001 10:40 PM To: [EMAIL PROTECTED] Subject: [PHP] Best Practice-HTML In Database 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? Will you ever want to do database-ish things with the contents of the page? (Allow somebody to search for words or phrases in the body, for example?) --- Mark Roedel ([EMAIL PROTECTED]) || There cannot be a crisis next week. Systems Programmer / WebMaster || My schedule is already full. LeTourneau University ||-- Henry Kissinger -- PHP General 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] Best Practice-HTML In Database
If you ever need to update the HTML, option 2 will be a lot easier.
Mick
On Sun, 29 Apr 2001, John Monfort 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General 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] Best Practice-HTML In Database
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 [EMAIL PROTECTED]
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:
[EMAIL PROTECTED]
For additional commands, e-mail:
[EMAIL PROTECTED]
To contact the list administrators, e-mail:
[EMAIL PROTECTED]
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
PHP General 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]
