Nov 8, 2009

Install Php 5 To Work With Mysql

free web hosting
Open Discussion > MODERATED AREA > Tutorials

Install Php 5 To Work With Mysql

magiccode9
hi, all

php 5 is new to all people a long time( actually, I forget how long...). it introduced a more object-oriented design to developer. like, access type(public, private, protected), abstract type(classes that can't create objects), interface support, and more.

althrought it is widerly available, someone still can't get it running with mysql. every time the php is starting up. a message prompted stated that some xtensions can not be found, and therefore, not loaded. so, I have written this to help other and newbie get it start quickly.

note: this is php setup is based-on windows, coz linux based actually complier with source code, so should be no this problem occur

1.) go php web site download it package(a .zip file) and place in a folder on your harddrive

2.) go to the folder in step[1], create a folder on your harddrive, in this case, "c:\php" extract all the files contained in .zip files into the folder you just create(c:\php)

3.) now, if you look at the folder c:\php, you will see there have two files a) php.ini-dist and b) php.ini-recommended. this is php config file. rename the php.ini-recommended to php.ini and copy / move it to you window directory
QUOTE
      win98 / winme / winxp ==> windows
      winnt / win2000      ==> winnt

4.) use any text editor(e.g. notepad) to open the file renamed above. try find a text string "extension_dir" and set the value of this parameter to the ext folder of your php installation path ( c:\php, c:\php\ext ),
QUOTE
extension_dir = "c:\php\ext\"

5.) try again found some text ";extension=". you have a list of extensions you can use, but some of which might required addition library to function. always check php mannal for more information. please look at three items, a) php_mysql.dll, b) php_mysqli.dll, c) php_gd2.dll( for create graphics ). delete the left most colon(:), save it and close you editor.

6.) on your keyboard, press "winkey+Pause/Break" key, the system properties dialog open. click on advanced tab, look for envionment variables, in system variables or user variables set an addition path to your php installation path and ext ( c:\php, c:\php\ext ), so click on either one(choose new or edit, depending on whether path variable exists), then
QUOTE
if path variable exits, use this form
  c:\php;c:\php\ext;%path%

if path variable no found, use this form
  c:\php;c:\php\ext

click ok and ok to close all dialog.
cheers, that it, the configuration of php is complete.
of course, you have to config you web server too, about the setting, you can refer to php manuual click here to view online or here to download a copy of it.

after php and web server are completed , try this code to test it work or not
CODE
<?php
    phpinfo();
?>


if you see a lot of items, then you successfull.
otherwise, pm me or send me a mail. :)

attach:fig01.jpg
attach:php.ini

- hope this help
- Eric

 

 

 


Comment/Reply (w/o sign-up)

(G)Deandra
EasyPHP MySQL errors on Windows Vista Home Premium Platform
Install Php 5 To Work With Mysql

Help! I am trying to build a simple e-commerce shopping cart, so I installed EasyPHP, Apache, MySQL, IIS in one fell swoop. Apache appears to be working fine with green light go. However MySQL is red lighted and stopped. When I test it by using my web brower at http://localhost, I get the following errors: Warning: mysql_connect() [function.Mysql-connect]: [2002] A connection attempt failed because the connected party did not (trying to connect via tcp://localhost:3306) in C:\EasyPHP\www\includes\database\mysql.Php on line 13 Warning: mysql_connect() [function.Mysql-connect]: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. In C:\EasyPHP\www\includes\database\mysql.Php on line 13 Warning: mysql_get_server_info() expects parameter 1 to be resource, boolean given in C:\EasyPHP\www\includes\database\mysql.Php on line 14 Fatal error: Maximum execution time of 60 seconds exceeded in C:\EasyPHP\www\includes\database\mysql.Php on line 14 Can you assist me in getting the proper settings correct. I believe that's all that's needed. Thanks a bunch. Sincerely, (Poor) Deandra (smile) -reply by Deandra

 

 

 


Comment/Reply (w/o sign-up)



Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

This textarea will convert to Rich-Text automatically (IE, Firefox, Chrome)

Similar Topics

Keywords : install, php, 5, work, mysql

  1. How To Install Opengeu In Ubuntu
    OpenGEU is a distro based on Enlightenment and derived from Ubuntu (2)
  2. Getting Started With Mysql
    creating tables and insert data into them. (2)
    Hi in this tutorial you will learn how to create tables and insert items into them. First steps are
    to create the database - go into your cpanel and mysql databases, from there make an account and a
    database and then attach them together with all priviliges, call the database test and the account
    admin, with the pw as pass - or any other password. We need to connect to the database so first in
    your php file (probably named index.php) - this is how to do it. CODE
    mysql_connect("localhost", "admin", "pass") or die(mysql_error()); mysql_select_db("test") or
    die(mysql_....
  3. [linux] How To Manually Install Flock System Wide
    (1)
    Since i am currently in the process of making my own Ubuntu-based distro and will be including Flock
    as one of the browsers to choose from, i figured i'd make a tutorial out of how to install Flock
    manually, since there appears to be no package for it in Ubuntu's repository and many other
    popular distros, and it is said that only Ultima Linux has Flock available. For those that
    don't know what Flock is, rather than going into deep detail here, i'll just provide a link
    to the browser's site: http://www.flock.com/ And yes, to start, you're going....
  4. Install An Aef Forum Onto The Trap17
    From a zip file (11)
    Installing an AEF Forum on the Trap17 Server Preparation for Installing the AEF Forum
    The following items are required for the installation of the packaage onto your site: 1. - a copy
    of the AEF Forum zip package from http://anelectron.com/download.php 2. - a MySql Database 3. - a
    Database User 4. - a password for the Database User 5. - Privileges allowed for the Database User
    The details for ensuring that you have all of these items are as follows: 1. - a copy of the AEF
    Forum zip package from http://anelectron.com/download.php . Simply browse to t....
  5. How To Install Php Scripts
    for people who don't like uploading all the time (0)
    OK. Here's what you need: 1. Web hosting that has FTP 2. A script or something to install 3.
    A program called SmartFTP I'll use my site for an example... 1. Enter your FTP login info
    2. When you login in your files, images, and stuff will show up. 3. Now that you're logged in
    you have to choose what file you want to import into your website. Go to "My Documents" and right
    click on the file you want to put on your site and select "copy". 4. Next you got to open put the
    dictionary that your website is in. Ok what that means the place where the "i....
  6. How To Install Phpbb?
    (8)
    QUOTE Here are the steps: Download the latest version of phpBB2. Currently it can be
    found at http://www.phpbb.com/downloads.php . I prefer the .tar.gz files, and winzip has no
    problems dealing with them. Decompress the files to a directory on your local system, making sure
    that you maintain the relationship between directories. I'll suggest that you decompress them to
    c:\webupload Now, within C:\webupload, you should have a phpBB2 directory, full of goodies. Open
    up your FTP client, and connect to where your web host tells you to go for uploading yo....
  7. Adding Data To A Database And Displaying It Later
    Using Forms, PHP and MySQL (1)
    Requirements: PHP Support MySQL Database access I am going to use a news program as an example.
    Ok, first you are going to need to connect to the database. Do so by using the code below. I have
    added some comments where you will need to edit to fit your server's specifications. Create a
    new file with notepad and call it config.php QUOTE //Change root to your database
    account's username $dbusername = "root"; //Add your account's password in between the
    quotations $password = " "; //Add the name of the database you are using in between the qu....
  8. Simple User System
    php, mysql driven (21)
    Hey! Maybe you've seen my other tutorials...or my signature.. Anyways I'm going to show you
    how to make a system so users of your site could register accounts and you could have protected -
    user only - pages on your site /smile.gif" style="vertical-align:middle" emoid=":)" border="0"
    alt="smile.gif" /> Ok, so we start by creating a config.php file. CODE     $dbhost   =
    'database host';     $dbname   = 'database name';     $dbusername   = 'database
    username';     $dbuserpass = 'database password';          mysql_connec....
  9. Simple Shoutbox
    PHP, MySQL driven.. (34)
    Ok, so I'm going to show you how to create a very basic shoutbox which is driven with PHP and a
    MySQL database. So, lets start - open a database management program like PHPMyAdmin and run these
    queries. SQL CREATE TABLE `shoutbox` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT , `name`
    VARCHAR( 255 ) NOT NULL , `mail` VARCHAR( 255 ) NOT NULL , `time` VARCHAR( 255 ) NOT NULL ,
    `message` TEXT NOT NULL , `ip` VARCHAR( 255 ) NOT NULL , PRIMARY KEY ( `id` ) ) TYPE = MYISAM ;
    CREATE TABLE `shoutbox_admin` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT , `name` VARCHAR( 255....
  10. Cpanel Mysql Database Management
    Part 2.1 Of My 7 Part Cpanel Tutorial (6)
    This tutorial is an extension to my 7 tutorial series about the Cpanel. The 7 different Cpanel
    tutorials can be found below. Part 1: E-mail Management Part 2: Useful Site Management Tools
    Part 3: Useful Site Management Tools2.1 Part 4: Analysis/Log Files Part 5: Advanced Tools Part
    6: PreInstalled Scripts, Extras, and Cpanel Options Part 7: Fantastico Detailed Cpanel
    Tutorial Part 2.1: MySQL Management In this tutorial, i will explain how to add, edit, delete
    and over-all manage the MySQL Feature in the Cpanel. Creating a MySQL Database 1) ....
  11. Install A Simple Machines Forum
    (11)
    If you want to have your own Simple Machines running up without any ADs of any kind , sign up at
    Trap17 and posting until you have enough credits then post an application form and then wait to be
    approved. After that , do like this and you will have your own forum setting up : 1.Download
    Simple Machines You can get it at Simple Machines download page , click here to get one
    2.Upload SMF to the Server This step is too long so be patient , log in to Trap17 forum then log in
    to your own cPanel , click on File Manager. A pop up Explorer will appear , then click on ....
  12. Starting Or Stopping Apache And Mysql Server Via Batch File
    (0)
    Hi guys, this is a litte tutorial about how we start and stop the Apache and MySQL in Windows NT
    (2000, XP, 2003) via a batch file script. As we know in Windows NT based system Apache and MySQL
    installed as Windows Services. So we can stop and start it using NET command. For more information
    about DOS command, type HELP at command prompt. I assuming that your MySQL service name is "mysql"
    and your Apache (Apache 2.0.x) service name is "apache2". If you want to chek it click Start > Run >
    services.msc > OK. Windows IS NOT Case Sensitive. Let's get started!. 1. Open....
  13. Check Referrer To Prevent Linking Yours From Other Sites
    Check referrer with Php and Mysql (9)
    Check Referrer Using Php To Prevent People Linking To Your Downloads From Other Sites Ever
    find that found some people are listing items, images and tuts and linking directly to the download
    url (those that are like my photoshop tutorial.php?id=0), which is a .php to count the number of
    downloads. To prevent this, you can add a piece of code to the download pages that checks which page
    referred them to the download page: if it's my domain, it downloads the file normally, if
    it's not, it will redirect to my home page instead. Important : Not all browser....
  14. How To Install An Openoffice Dictionary Manually
    adding the new dictionary by yourself (3)
    How To Install An OpenOffice Dictionary Manually Introduction The Tutorial
    What's OpenOffice? Introduction Before you all rant at me and tell me that there is a
    wizard to install dictionaries for you, it can sometimes not work. I know this because on my copy of
    OpenOffice Writer, it doesn't. This tutorial is very easy to follow and it's for those
    whose wizard is broking, just like mine or people who like to be difficult and do things the hard
    way /tongue.gif" style="vertical-align:middle" emoid=":P" border="0" alt="tongue.gif" />....
  15. Quiz With Php, But Without Mysql
    (3)
    Ok let`s start! Once I wrote it for school: At first we need questions (php) CODE $form_block =
    " Quiz What's The Capital City Of England? How Many Letters Are There In The
    Alphabet? WHat's 3+10? "; That takes the form of a form... You can, of
    course edit the questions. I will now break that code down and explain the different parts. CODE
    The reason that any "s (Double quotes) are shown after a \ (Backwards slash) is becouse the
    PHP Parser will spew out errors if you forget to do this. "POST" Means that it will ....
  16. Installing Php + Mysql + Apache + Phpmyadmin On Windows Part 2
    Continue the last section which is installing phpMyadmin (0)
    QUOTE phpMyAdmin lets you control you MySQL database from a web browser. Steps: 1. If you
    haven't done so already, download the phpMyAdmin Database Manager - You can download the
    software from the phpMyAdmin website. Be sure to download the phpMyAdmin-2.6.2-pl1.zip file. Save
    the file on your Windows Desktop. ... ... ... Go to for more info. Post Copied. Member
    Banned ....
  17. How To Install S9y Weblog Software
    (0)
    Right , here's my guide at how to install S9Y ( www.s9y.org ) 1. Download the version of S9Y
    you want from the website above 2. Extract the rar file 3.Upload all the files to a Web host 4.
    Go to you domain/subdomain , also at this point make sure all the files are CHMOD 775 5. S9Y's
    Installer should start and give you an overview of you system's setup 6. Make sure there is
    nothing in red and click Simple Install 7. Fill in all the spaces , with you Database name ,
    Password , etc ... From here on S9Y is very easy to set-up ! Just use it as you ....
  18. Searching With Php And Mysql
    The easy way :P (2)
    Searching with PHP and MySQL is pretty easy when you think about it, especially if you're doing
    it the simple way (without boolean or whatever) /tongue.gif' border='0'
    style='vertical-align:middle' alt='tongue.gif' /> It consists of a few forms, a query and an
    output. As I said, simple! CODE \"> The form that you just made
    contains a text input that people will type into, the next code will extract the form data and then
    search it.. Form processing /wink.gif' border='0' style='vertical-align:middle' alt='wink.gif' />
    ....
  19. A Nice Mysql Server Check
    (4)
    I made this and its not very hard at all just fill in the info and it willl see if your mysql is up
    or down CODE Mysql Connection Test // On this you need to put your host most of
    the times localhost username and password. $conncect = mysql_connect ( "host", "Username",
    "password" ) or die (" Sorry your server can't connect to your mysql server Check to see you
    have put in the Username and password and if this is the 1st time you have got this And it has
    worked before That means you need to contact your hoster and tell them my MySql server is....
  20. How To Install A Favicon
    Yup, a favicon. (51)
    Ok, you know those little icons that are to the left of a web address? |_ /smile.gif' border='0'
    style='vertical-align:middle' alt='smile.gif' /> http://www.domain.com_| Well that is called a
    favicon, folks. If you want one, simply do the following: 1.) Make sure your favicon is in .ico
    format. Name it favicon.ico 2.) Upload the favicon.ico to the same folder as your main index.html or
    index.php or index.asp, whatever. Basciaaly, you should have: http://domain.com/blah/favicon.ico
    http://domain.com/blah/index.___ , whatever you have. 3.) Put this into the head....
  21. Mysql Database Setup
    tutorial walk through (1)
    Post copied. Google cache to source Credits have been adjusted. Setting Up Your MySQL &
    phpMyAdmin For The First Time This tutorial will show you how to set up your MySQL and your
    phpMyAdmin with ease, regardless of whether you are going to be using PHP Nuke or PHP Nuke
    Platinum. The process is still the same. -Log into your CPanel with your User Name and Password.
    -Click on MySQL icon -Now, we need to create a database also known as Db , Your User Name will
    make up part of the necessary details, but you don't need to do this as it will be done au....
  22. How To: Create And Install Your Own Cursor
    a step by step guide (16)
    How To: Create And Install Your Own Cursor a step by step guide using animation shop (a
    program free with paint shop pro) Requirements: Animation Shop (can be found on the same disk
    as Paint Shop Pro) Any image Are you displeased with the cursor you've got? Are you
    dissatisified with those cursors you downloaded from that site? Then this tutorial's for you.
    Read on... Create or download your favourite image off the web. Open it in some image editing
    software (ie Paint Shop Pro) and resize it to 15x15. In Paint Shop go to Image --> Resize. Ent....
  23. Php Dynamic Signatures
    Using the GD Module and MySQL (9)
    PHP Dynamic Signatures using the GD Module After much scowering on the internet to find a
    suitable tutorial on this subject, I came up empty-handed. So I was forced to learn it on my own
    through trial & error. And since I had discovered a lack of tutorials on this subject, I dediced to
    write one! Working Example: Abstract : Using the GD Module of PHP allows a developer
    to build custom Images with Dynamic Content. Such content could be the Requesting Users IP Address,
    Web-Browser Type, Operating System, even the number of times the user has seen th....
  24. How To: Install Scripts And Create Database
    preinstalled scripts, own scripts (2)
    How to install php scripts using MySQL,phpMyAdmin on Trap17 using preinstalled script/auto
    installation cPanel > Preinstalled scripts > "Addon Scripts" or "Fantastico" or "phpBB" or the
    scripts which you wanted to install screenshot - >
    http://i6.photobucket.com/albums/y222/haalaaluu/5.jpg explaination: this method is auto install
    the scripts in public_html folder, database name and granted database user respect to its database.
    note: by Addon Scripts, you can not choose other folder structure. by fantastico you can choose the
    folder structure and it is good ....
  25. How To Install Php-nuke
    How to install PHP-Nuke manually (12)
    Download PHPNuke (www.phpnuke.org) and unzip it into a directory. Now go to where your web server is
    installed (or web hosting ftp)! Create a folder and call it phpnuke. Now upload everything from the
    HTML folder into the phpnuke folder you created. Than go to the config file of phpnuke
    (\phpnuke\config.php) Ok now, if you have phpedit installed than this will be easier than using
    Notepad. Go to line 32 and you sould see this: $dbhost = "localhost"; $dbuname = "root"; $dbpass =
    ""; $dbname = "nuke"; $prefix = "nuke"; $user_prefix = "nuke"; $dbtype = "MySQL"; If this....
  26. Php/mysql Login/register
    Tutorial for login with databases. (4)
    Start register code. Register.php CODE Username: Email: Pass: Verify
    Pass: //Login to your database. Make the fields of course..
    mysql_connect("localhost","user","pass"); mysql_select_db("database"); //end //if registering,
    check fields. if ($action == register) { if (!$user || !$pass || !$email || !$vpass) {  print
    "You must fill out all fields.";  exit; } $dupe1 = mysql_num_rows(mysql_query("select * from
    table where user='$user'")); if ($dupe1 > 0) {  print "Someone already has that
    username.";  exit....
  27. Complete Login And Registration System
    doesn't use mysql! (9)
    kLogin 0.1 QUOTE(readme.txt) Readme file to kLogin 0.1 To use the internet explorer fix:
    download the latest IE7 ZIP file
    (http://sourceforge.net/project/showfiles.php?group_id=109983&package_id=119707) Extract the ie7
    zip file to the root directory of your web server. Example, if you are using a unix/linux server,
    it's on "public_html/" or "home/public_html" Open kLogin.php file with your editor and edit the
    $info_text or $info_txt variable. Then, extract the kLogin.php file in to the root directory of
    your web server also. Just run kShoutBox.php If ....
  28. How To Host Ur Own Site In 2 Mins Php+mysql Needed
    (34)
    QUOTE Run you're own server for testing phpmysql or just to host you're own website or
    for you're friends. -needS: a PC that's all 8) - How to ? download : CODE
    http://server.paehl.de/apache20.zip : 30 seconds Installing:---> 1 minute
    *********************************** Unpack the exe where ever you want. after unpack run
    serverinst.exe and change Servername and your e-mail. Start the following files one time:
    start_apache.cmd --> start apache as service mysql_start_as_service.cmd  --> dito for mysql
    mysql_first_start.cmd  --> start m....
  29. Clicks Counter
    With PHP + MySQL (1)
    Well, in this tut, I'll show you how to do an simple link counter, with only one count for each
    IP and the date when the link were clicked. Just remember, this is only one way to do it. First,
    create an mysql database called 'links', with 2 table: first table will be called
    'links', with the columns: id, title, ref and clicks. The other one will be 3 columns and
    will be called links_info: id, ip and date. Just remember that the columns 'id' of this
    second table IS NOT auto-increment. Here is the code of the file which will count the clicks, ....
  30. Complete Login System
    With PHP + MYSQL (57)
    Its an complete login sistem made and tested by me and I think itwill be very usefull for people who
    are tryn to learn PHP. First, let's make register.php: CODE include("conn.php"); //
    create a file with all the database connections if($do_register){ // if the submit button were
    clicked if((!$name) || (!$email) || (!$age) || (!$login) || (!$password) || (!$password2)){ print
    "You can't let any fields in blank.\n"; // if the user did not put some field exit; } $name =
    stripslashes($name); $email = stripslashes($email); $age = stripslashes($age); $login = s....

    1. Looking for install, php, 5, work, mysql
Similar
How To Install Opengeu In Ubuntu - OpenGEU is a distro based on Enlightenment and derived from Ubuntu
Getting Started With Mysql - creating tables and insert data into them.
[linux] How To Manually Install Flock System Wide
Install An Aef Forum Onto The Trap17 - From a zip file
How To Install Php Scripts - for people who don't like uploading all the time
How To Install Phpbb?
Adding Data To A Database And Displaying It Later - Using Forms, PHP and MySQL
Simple User System - php, mysql driven
Simple Shoutbox - PHP, MySQL driven..
Cpanel Mysql Database Management - Part 2.1 Of My 7 Part Cpanel Tutorial
Install A Simple Machines Forum
Starting Or Stopping Apache And Mysql Server Via Batch File
Check Referrer To Prevent Linking Yours From Other Sites - Check referrer with Php and Mysql
How To Install An Openoffice Dictionary Manually - adding the new dictionary by yourself
Quiz With Php, But Without Mysql
Installing Php + Mysql + Apache + Phpmyadmin On Windows Part 2 - Continue the last section which is installing phpMyadmin
How To Install S9y Weblog Software
Searching With Php And Mysql - The easy way :P
A Nice Mysql Server Check
How To Install A Favicon - Yup, a favicon.
Mysql Database Setup - tutorial walk through
How To: Create And Install Your Own Cursor - a step by step guide
Php Dynamic Signatures - Using the GD Module and MySQL
How To: Install Scripts And Create Database - preinstalled scripts, own scripts
How To Install Php-nuke - How to install PHP-Nuke manually
Php/mysql Login/register - Tutorial for login with databases.
Complete Login And Registration System - doesn't use mysql!
How To Host Ur Own Site In 2 Mins Php+mysql Needed
Clicks Counter - With PHP + MySQL
Complete Login System - With PHP + MYSQL

Searching Video's for install, php, 5, work, mysql
See Also,
advertisement


Install Php 5 To Work With Mysql

Affordable Web Hosting, Low cost Web Hosting - ComputingHost.com