A detailed introduction to PHP and mySQL interaction. Includes detailed comments to help newbies get used to PHP and understand what is happening in each script.
Even though loading data from a text file into the database is not a task that user would perform on a daily basis, there are several cases when the speed of this process is important to DBA and company management. One example would be having a "database guy" receive the daily reports from the field offices or sales people on daily basis. Reports come as Excel documents or delimited spreadsheets of some kind, and DBA's responsibility includes updating the database on constant basis, so that by the end of the day, he is able to give the management a report on the amount of daily sales or field office transactions. Here you will find a MS Word-format downloadable file that examines the benchmark results for Oracle and MySQL speed of loading the data from a text file.
This is a quick MySQL reference for your daily practice or for learning MySQL. This one page document includes most of the commands you will need to create databases and tables, run queries and process data. The download file format in MS Word.
This article will briefly describe how to compile PHP with ORACLE 8i support. The author writes "when i try to compile php with oracle support on Solaris 2.6 i got lots of problems. after tedious search in internet i have found solution. I have following configuration: ORACLE 8.1.6; PHP 4.0.6; Apache 1.3.19 (Already Installed)."
This free, dW-exclusive tutorial shows you how to use two open source, cross-platform tools for creating a dynamic Web site: PHP and MySQL. When we are finished, you will learn how dynamic sites work and how they serve the content, and you will be ready to serve your own dynamic content from your site. After a quick registration, you can begin the tutorial. The tutorial should take you about 1 hour to complete. You can take it online, or download a PDF or zip file of the tutorial.
This is a short tutorial on how to program in PHP and MySQL. Covers several MySQL functions via telnet command, and a short example on using PHP with MySQL.
The author writes "mySQL comes with a pretty powerful security system, the grant tables, which allows database administrators to precisely control access to databases, tables and even specific rows and columns." This article describes how the five grant tables combine to offer power users a tremedous amounts of flexibility and control over database access and operations.