www.uburst.com www.uburst.com

"Some Hints for Accessing MySQL via ODBC"

Go back to the LobbyClick here to Go Back to Main ListingClick here to see helpClick here to Search the Forum

Database Ideas
Forum Type: Public
Moderator: edmunds
Time Zone: EST
Printer Friendly Format
Original Message
 
"Some Hints for Accessing MySQL via ODBC"
Posted by Brian Levine on Apr-02-03 at 11:54 AM (EST)
Just a few hints I've learned when using the ODBC Connector (MyODBC) to access a MySQL database:

1. Use Double instead of Float datatypes
2. Include a Timestamp field
3. Always define a Primary Key
4. Avoid Blob datatypes.

Click to Send Alert Message to the Administrator Click to edit this messageClick to EMail Click here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents

 Table of Contents

your phpmysql integration notes, webmissie, Apr-07-03, (1)
Username and Password in Page Sourc..., Brian Levine, Apr-11-03, (2)

 

 
Click here to goto Click here to goto the Lobby
Messages in this discussion
 
1 . "your phpmysql integration notes"
Posted by webmissie on Apr-07-03 at 11:49 AM (EST)
in your notes you have the database username and password being displayed on the html page the you are using to call the fuction files. Am i reading that wrong, but isnt there a more secure way of doing this than showing the info on the html page
Remove this Message: Administrator and Moderator onlyClick to Send Alert Message to the Administrator Click to edit this messageClick here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents
 
2 . "Username and Password in Page Source"
Posted by Brian Levine on Apr-11-03 at 01:06 PM (EST)
Actually, while they are there in the page source, they will not show up in the generated web page, as it is PHP code that gets interpreted out at the server. As long as you have the directory on your server protected, no one will ever see the username and password.
Remove this Message: Administrator and Moderator onlyClick to Send Alert Message to the Administrator Click to edit this messageClick to EMail Click here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents


Archive This Thread: Admin and Moderator OnlyRemove This Thread: Admin and Moderator Only
Click here to goto Click here to goto the Lobby

 

 

 

 

 

 

 

 

 

 

 

 
Questions or problems regarding this bulletin board should be directed to Webmaster
©1997-1999 by DCScripts. All rights reserved.