PHP Database: MySQL

If you want to store binary data like images and html files directly in your MySQL database, this column is for you! I will show how you can store the data via the HTML forms File feature in your database and how you can access and use this data in your webproject. If you have read the article PHP, MySQL and images by William Samplonius here on phpbuilder.com, this might be interesting for you as William stores the binary...

Looking to quickly add a dynamic news page to your corporate orpersonal Web site? This article shows you how, combining PHP s rapidapplication development capabilities with a MySQL database to create aprimitive news publishing system and administration module in just underfour hours. In the highly competitive world of Web development, there s a crying need for a toolkit that allows developers to rapidly and efficiently construct dynamic, robust ...

You may be familiar with relational databases, but what is a relational content management system? Read on to learn how to build this system, which helps you create a search engine friendly site fairly quickly.

Almost every dynamic Web application eventually boils down to accessing, manipulating, and presenting information. A forum is an idea example of this type of application. Users register at the site; their information is added to the database. Someone wants to post a new message? The database is queried to validate the user and again to store the message once the user has finished writing it. Displaying each page, the forum listing, the threads li...

In the previous article you were introduced to the basics of PHP and MySQL. We explored some of the functions PHP provides for working with MySQL and saw how they could be used to retrieve, edit, add and delete information from a database. The functions covered in the last article are at the core of creating even the most complex database driven web site. In this article, you will learn how to pull those functions together to create a fully funct...

I m just a few days away from launching a comprehensive support website for my book, Beginning PHP and MySQL 5, Second Edition, and among other features, have built a search engine for sifting through the more than 500 code snippets found throughout the book. This was an interesting exercise because it involves a number of storing a fairly significant amount of text within a MySQL database, using MySQL s full-text search facility, and devising...

If learning how to incorporate creational design patterns into your own PHP 5 applications is a high-priority topic for you, then this set of comprehensive articles might be what you re looking for. Welcome to the concluding installment of the series Using Bridge Classes with PHP 5. These tutorials will teach you how to implement the bridge pattern in PHP by providing you with many hands-on examples that can be included in your existing and fut...

Ok. Your site has recorded the data you want, now you want to display it in an easy to read format. The first method that comes to mind is simply to put the data in an HTML table. Although this is probably the easiest way out, there is a much better way of displaying your information: a graph. This was originally only possible by using sneaky tables with tr s of different lengths. But now, thanks to the GD library and PHP, you can actually ...

Trying to expand beyond the boundaries of your existing background by learning how to code and use static methods and properties inside your PHP 5 classes? Then look no further. Welcome to the last part of the series Using static members and methods in PHP 5. Made up of two instructive chapters, this series introduces the foundations of using static members and defines static methods in PHP 5-driven development environments.

Are you a curious PHP developer, wanting to learn how to simulate a basic Model-View-Controller schema with PHP? Then, look no further, because you re in the right place. Welcome to the final part of the series Simulating the Model-View-Controller Schema in PHP. In three tutorials, this series provides you with a comprehensive introduction, aimed at implementing a MVC-based relationship between PHP objects.

We very often need to import data into MySQL databases. This becomes a tough job if we don t have a reliable and easy-to-use MySQL GUI. At times, when I am working on deadlines, this job becomes frustrating and I find myself wishing I had a tool to do this job for me. I recently found Navicat, which can convert Excel spreadsheets and MS Access to MySQL databases, eliminating time-consuming data entry and the errors that may accompany it. The tool...

by kenlin This article discusses a solution to import MS Excel, MS Access, XML data to local or Remote MySQL databases by using a famous MySQL Admin Tool called Navicat. You can find the information of Navicat at http://www.mysqlstudio.com/detail.php3. Overview We very often need to import various data into MySQL databases. This becomes a tough job if we don t have a reliable easy-to-use MySQL GUI; At times, when I am working on deadlines, this...

In an era where data becomes volumetric in every business, much attention has been given to proper database management and the ease of data access. Businesses that use MS Access begin to look for an alternative which allows better database performance, higher reliability, higher flexibility, yet inexpensive. With the numerous choices available in the market, considering you don t want to put too much investment on it, only one, MySQL, stands out ...

Which database do I use: Postgres or MySQL? This age-old question has plagued developers for, what, at least a couple years now. I ve used both databases extensively (MySQL for about one year and Postgres for about 2 years) and was curious if the performance differences between the two were as stark as the MySQL website suggests. I had actually benchmarked the two databases back in September 1999 when we were starting to lay the groundwork for S...

There are a number of useful date and time functions in MySQL. I ve seen too many applications performing date calculations at the code level when the same can be done using built-in MySQL functions. Before we launch into the functions, however, let s refresh our memory and look at which date and time types are available to MySQL. DATETIMEYYYY-MM-DD HH:MM:SS DATEYYYY-MM-DD TIMESTAMPYYYYMMDDHHSSMM TIMEHH:MM:SS YEARYYYY The TIMESTAMP column stores...

Last time we looked at a few of the more commonly used date and time functions. This time we re going to look at some of the less well-known functions. First, we will need to understand the various date and time types MySQL accepts for passing to many of these functions. SECONDss MINUTEmm HOURhh DAYDD MONTHMM YEARYY MINUTE_SECONDmm:ss HOUR_MINUTEhh:mm DAY_HOURDD:hh YEAR_MONTHYYYY-MM HOUR_SECONDhh:ss DAY_MINUTEDD hh:mm DAY_SECONDDD hh:mm:ss As yo...

Have a large MySQL dataset that you would like to display on your website, but don t want to bog down your users connections with large HTML renderings? Try paginating your data. As a PHP and MySQL Developer I browse around many forums and one of the more common questions being asked is How do I Add Next / Prev Links to my Pages? . Even I asked this very question a long time ago when I was beginning to learn PHP. I decided to write this article...

Joe s used auto sales, an average sized car yard of around 150 cars has decided to make the big leap into the new millennium. First of all they had to get themselves a nice new computer, with that new computer came the Internet. After a few weeks of searching the internet they decided to go all out, now they wanted a web site of their own. And it just so happens that Joe s good friend knows a little HTML, three days later Joe s used ...

by kenlin SSH Tunnel What Is SSH? SSH stands for Secure SHell and is typically used as an encrypted version of telnet. In a telnet session, all communications are transmitted in plain-text, allowing anyone to listen-in on your session and steal passwords and other information. Such sessions are also susceptible to session hijacking, where a malicious user takes over your session once you have authenticated. OpenSSH, the tool included with most Li...

So you ve got a dynamic site, filled with all sorts of user inputs, whether it be a phorum , or like my own site at knowpost.com. The site htdig.org will take care of indexing and searching your html pages, but if you are like me, you have very few html pages, and must of your content resides in BLOBs in your database. You can t do anything useful using a like %searchword% query, it just isn t coming back relevant. There has to be a...

We all know accessing data in RAM is a lot quicker than accessing data on disk. So, with this in mind, wouldn t it make sense for MySQL to store as much data as possible in memory? The answer is of course yes, and MySQL can in a number of ways. Query caches, holding indexes in memory, and most extreme of all, holding an entire table in memory. The latter is the topic of this article. Tables in memory are called HEAP tables. The MySQL table types...

Last month we looked at the HEAP table type, a table type which runs entirely in memory. This month we look at setting up the InnoDB table type, the type of most interest to serious users. The standard MyISAM table type is ideal for website use, where there are many reads in comparison to writes, and no transactions. Where these conditions do not apply (and besides websites, they do not apply often in the database world), the InnoDB table is lik...

Our objective is to install a web server that will allow us to host sites, that would be secure for e-commerce solutions, and that could be driven via scripts to connect to a database server and extract its data.

This article is aimed at answering one of the most asked questions on the PHP mailing list and discussion forums alike: How to store binary files in a MySQL database. // ); //]] I ran into this same question when asked by a possible employer testing my programming skills to create a set of scripts to upload files to a MySQL database, download files from it, and also show an image, if the file was indeed an image. Anyway, I couldn t find any arti...

Welcome to the third part of the series User-defined interfaces in PHP5. In four parts, this series explains the use of interfaces in PHP5, highlighting their advantages and illustrating their implementation in real applications.

If you re a PHP programmer who s searching for a comprehensive tutorial on how to create adapter classes with PHP 5, them look no further. Welcome to the final installment of the series Implementing adapter objects with PHP. Made up of two parts, this series teaches you how to implement the adapter design pattern in PHP 5, and it accompanies the corresponding theory with educational examples.

Here at Soundbreak we stream out live audio and video 24 hours a day, so it didn t take much convincing to be able to run some testing on MySQL s new replication feature. We discoverd that we could use it to keep an up to date standby database server that could handle all of the queries should the primary fail for any reason. It s not dificult to configure two servers for just such a purpose, and I ll walk through the procedure, as well as a dis...

This article helps explain how to use Macromedia Flash 5 in conjunction with PHP and a MySQL database. This demonstration will show you how to setup a simple login and registration form, then allow users to save movie clip positions and various properties in the database. When they log back in the movie clips are in the same position. For this tutorial you will have to have some basic knowledge of PHP and MySQL, hopefully you won t need much tho...

If you re looking for brand new material to help you expand your background in using design patterns with PHP 5, then hopefully this article will suit your needs. Welcome to the final installment of the series Introducing Visitor Objects in PHP 5. Composed of three chapters, this series walks you through the key points of creating and using visitor objects with PHP 5, and teaches you how to use them in the context of real-world applications.

If you re interested in learning how to combine objects, sessions and MySQL, this is the article that you ve been waiting for. It s the final part of the series Serializing objects in PHP. In three parts, this series goes through the fundamentals of serializing objects in PHP applications, and explores some advanced topics with regard to this subject, including the use of the magic __sleep() and __wakeup() functions, and the manipulation of...

If you re one of those avid PHP developers who wants to learn how to apply the decorator design pattern within your Web applications, then this group of articles might be quite appealing to you. Welcome to the second part of the series Using the Decorator pattern with PHP. Comprised of two parts, this series walks you through the core concepts of using this pattern in PHP, and shows you its practical edge with numerous hands-on examples.