Home » Science » Computer Science » Archive by category "SQL"

How to Install MySQL for Linux

The installation process of MySQL 5.6.x (community) on Linux, using the distribution from MySQL AB. if you’re using another flavor of UNIX, download appropriate files and follow the instructions included with the distribution.   The recommended installation method for MySQL is with RPM’s. There are several RPM’s that make up a full distribution, but  for a minimal installation you need the following ;   MySQL-server-VERSION.i386.rmp-The MySQL server. MySQL-client-VERSION.i386.rpm-The standard MySQL client programs. To download these...
Continue reading »

How to create a Test Table in MySQL

Go to the Windows Start menu, choose Run, type  mysql -u root -p, and press Enter. The program will then prompt you for the password.           When the MySQL, Monitor starts, it provides its own prompt. At this prompt (mysql>), you type commands used to create tables, explain tables, insert data, select data, and so on. Get used to ending your commands with a semicolon (;)  because it’s...
Continue reading »

How to Testing your MySQL Installation

When using MySQL with PHP, you’ll issue the same types of commands, only within the context of the PHP code.   Starting MySQL To start MySQL manually,  go to the Windows Start menu, choose Run, type c:\Program Files\MySQL\MySQL Server 5.6\bin\mysql-nt.exe And press Enter.   The MySQL process will now be running in the background. you can now connect to MySQL and create database and tables.   Creating a Test Database Before going any further, you...
Continue reading »

How to Installing and Configuring MySQL

MySql is the database of choice for a vast majority of Web developers who use PHP, because of its efficiency and ease of use. Plus, MySQL is free and runs on multiple platforms, and its documentation sis superb. When using MySQL and PHP, it’s easiest to install MySQL first, because during the PHP installation and configuration processes, you must tell the PHP configuration script that you plan to use MySQL, in order to activate...
Continue reading »

A Brief History of PHP.

In 1994, an incredibly forward-thinking man named Rusums Lerdorf developed a set of tools that used a parsing engine to interpret a few macros here and there. They were not extravagant : a guest book, a counter, and some other ” home  page” elements that were cool when the Web was in its infancy. He eventually combined these tools with a form interpretation (FI) package he had written, added some database...
Continue reading »

What is PHP ?

Its official name is PHP : Hypertext Preprocessor, and it is a server-side language. When your Web browser accesses a URL, it is making a request to a web server. When you request a PHP page, something like http://www.yourcompany.com/home/php, the Web server wakes up the PHP parsing engine and says, ” Hey ! you’ve got to do something before I send a result back to this person’s Web browser.” Then the...
Continue reading »