PHP | The Final Guide

phpMyAdmin 3.4.3.1 (Freeware)

Wednesday, July 6th, 2011

phpMyAdmin is a free software tool written in PHP for administering of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations on MySQL. Operations like managing databases, tables, fields, relations, indexes, users, permissions, etc are supported by user interface. Don’t think there is no chance to execute SQL statements. Its still there to write your own SQL statements and execute.

Features

Intuitive web interface (you can open phpMyAdmin on your PC by typing http://localhost/phpmyadmin/)
Supports MySQL features like browse and drop databases, tables, views, fields and indexes, create, copy, drop, rename and alter databases, tables, fields and indexes and many other features.
Supports importing data from CSV and SQL
Supports exporting data to various formats: CSV, SQL, XML, PDF, ISO/IEC 26300 - Open Document Text and Spreadsheet, Word, Excel and others
Administering multiple servers
Creating PDF graphics of your database layout
Creating complex queries using Query-by-example (QBE)
Searching globally in a database or a subset of it
Transforming stored data into any format using a set of predefined functions, like displaying BLOB data as image or download-link
and many more features available

You can download phpMyAdmin from phpMyAdmin website.

For more information, visit: http://www.phpmyadmin.net/

06.07.2011 Database, MySql No Comments

Install and Use PHP & MySql on Windows Machine

Tuesday, May 5th, 2009

AppServ package is a full-featured package which can be installed in 1 minute.
AppServ package contains
- Apache webserver
- PHP
- MySQL
- phpMyAdmin

You can download AppServ Pagackage from http://www.appservnetwork.com/

AppServ Package installation step by step

Double click appserv-win32-x.x.x.exe to install AppServ on your computer which shows welcome screen and click Next to go to License Agreement Screen.
License Agreement: AppServ distribution under GNU?GPL License. You must read license agreement before install. If you agree for this license click Next to go to next step. If you do not agree click Cancel to exit installation.
Click Next and choose Install Location (Default Location: C:AppServ)
Click Next and choose Components : AppServ default package components are checked.
You can choose the components by check (install) or uncheck (not to install).
- Apache HTTP Server is a Web Server.
- MySQL Database is a Database Server.
- PHP Hypertext Preprocessor is a PHP Programming processor.
- phpMyAdmin is a MySQL Database control via WWW.
If you complete choosing it click Next to go next step.
Apache Configuration : This is the screen where you can configure Apache Server on your pc.
Server Name: Specify Server Name e.g. localhost
Admin Email Specify Admin Email e.g. admin@myserver.com
HTTP Port Specify HTTP port for Apache Web Server (Default Port is 80 but if iis is already installed then select different port ex: 8080)
Click Next to MySQL Configuration :
Default User: root for MySQL Database.
Password: root (or your own password)
Character Sets Specify for data storage language and collations.
Old Password If you have problem when you coding PHP code with Old MySQL API. And found error Client does not support authentication protocol requested by server; consider upgrading MySQL client. You must check this option to avoid error. (Enable InnoDB If you use InnoDB must check this )option.
Click install and Finish installation and it’ll run Apache webserver monitor and Apache service automatically even after you restart your pc.
Directory Structure of Apache, PHP and MySql are shown as follows.
To test PHP, open notepad and type <? phpinfo(); ?> and save as test.php in location C:\AppServwww
Open internet explorer or other web browser and type http://localhost:8080/test.php and click go which will display the default PHP configuration page.
To access the default configuration pages of Apache webserver installed on your local pc, type http://localhost:8080 in the address bar of your browser and Apache default configuration page will be displayed.
You can access PhpMyAdmin interface to configure the database in MySql for your PHP project or any other front end project through the link phpMyAdmin Database Manager Version 2.10.2