uShop English (U.S.) for 179!

uStorekeeper English (U.S.) for 149!

 Products
       uTest
       uReserve
       uShop
       uStorekeeper
       uGolf
       uDirectory
       uSignIn
 Tech Support
       Support Policy
       Knowledge Base
            uTest
            uReserve
            uShop
            uStorekeeper
            uGolf
            uDirectory
            uSignIn
       Documentation
       Reference Sites
 Legal
       Software Piracy
       Legal Notices
       Privacy Policy
       Licensing
 Miscellaneous
       Reseller Info
       Contact Us
       Site Map
Some Hints for Accessing MySQL via ODBC

Knowledge Base Lobby : uShop Support Conference : Database Ideas
Nov-23-17 10:54 PM EST
Original Message
Some Hints for Accessing MySQL via ODBC
Author Brian Levine on 04-02-2003 at 11:54 (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.
E-MAIL AUTHOR | TABLE OF CONTENTS

Table Of Contents
  your phpmysql integration notes webmissie, 2003-04-07 11:49:25 (1)
            Username and Password in Page Source Brian Levine, 2003-04-11 13:06:50 (2)

Messages In This Discussion
         1. your phpmysql integration notes
        Author webmissie on 04-07-2003 at 11:49 (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
TABLE OF CONTENTS
                 2. Username and Password in Page Source
                Author Brian Levine on 04-11-2003 at 13:06 (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.
TABLE OF CONTENTS

© 2003 Microburst Technologies, Inc.