Mysql: Comments in Fields

April 9, 2008 by  
Filed under So Much Data

I never really noticed that you could create comments in your mySQL fields until now. My co-worker recently upgraded one of the web servers to have phpMyAdmin – 2.11.5.1, and the forms made the “comment” field more visible to me.

Below is a very basic table for “locations.” This simple table is for demonstration purposes only. ;)

Mysql table in PHPmyAdmin
Click on the image for a zoomed in view.
Read more

Related Products:

Database Systems: A Practical Approach to Design, Implementation and Management (5th Edition)Database Systems: A Practical Approach to Design, Implementation and Management (5th Edition) This best-selling text introduces the theory behind databases in a concise yet comprehensive manner, providing database design methodology that can... Read More >
PHP and MySQL Web Development (4th Edition)PHP and MySQL Web Development (4th Edition)PHP and MySQL are popular open-source technologies that are ideal for quickly developing database-driven Web applications. PHP is a powerful scripting... Read More >

Popularity: 10% [?]

How to Connect to a MySQL Database using PHP

March 29, 2005 by  
Filed under Code Snippets, PHP, Scripts and Coding

I was helping my coworker yesterday to create her first PHP-Database program. She already knew how phpMyAdmin worked, so I created a sample page for her to show how to connect to the database and then retrieve data from a query. Maybe this sample page could help you too. I commented as much of the code as I could. Let me know if you have any questions.

Read more

Related Products:

Learning MySQLLearning MySQL

Whether you're running a business, keeping track of members and meetings for a club, or just trying to organize a large and diverse collection of i... Read More >

Code: The Hidden Language of Computer Hardware and SoftwareCode: The Hidden Language of Computer Hardware and Software

What do flashlights, the British invasion, black cats, and seesaws have to do with computers? In CODE, they show us the ingenious ways we manipulat... Read More >

Databases Demystified (Demystified)Databases Demystified (Demystified)Through clear language, step-by-step discussions, and quizzes at the end of each chapter, the author makes databases easy. Quickly learn the core skil... Read More >

Popularity: 26% [?]

Stop SOPA!

SOPA breaks our internet freedom!
Any site can be shut down whether or not we've done anything wrong.

Stop SOPA!