PHP MySQL Tutorial

Rocky Rasonable

A na Filipino Senior PHP programmer, Web Developer at Webmaster batay sa Davao, Pilipinas. Dalubhasa sa Joomla, WordPress, Soholaunch, Oscommerce, Drupal, Social Media Sites, at iba pa

Higit pang mga Post - Website

PHP MySQL Tutorial

Ang isa at lamang na database ng pamamahala ng programa ng internet host kliyente ay kailanman malaman ang Aking SQL. Ang dahilan kung bakit kaya maraming mundo-wide-web host ay nag-aalok ng MySQL ay marahil ay ipinaliwanag ng karagdagang ibaba. Madalas sa ibang DMS MySQL gumagamit ng SQL na wika at ay binili sa pamamagitan ng Sun Microsystems taon ito para sa mga lamang tungkol sa isang solong bilyong dolyar.

Isang Open Source Software programa

Ang isang tao ng MySQL sa pinakamatibay kalamangan ay na ang pamamaraan ng pamamahala ng database ay batay sa bukas na supply ng programming. Ito ay hindi nangangahulugan na gayunpaman na ito nararapat na isaalang-alang freeware. Hindi, may mga pa rin ng isang bilang ng mga ang patentadong function sa programang ito at ito ay nagkakahalaga ng cash gamitin. Ngunit sa pamamagitan ng pagbuo ng ito bilang isang bukas na supply ng software ng computer MySQL Pinapahintulutan ang mga gumagamit nito ng isang katiyakan ng kalayaan upang baguhin ang DBMS bilang makita sila angkop. Licensed sa ilalim ng Pangkalahatang pampublikong License MySQL ay may isang bukas na code supply at ng software program ay ipinamahagi sa mga customer ang lisensya na bigyan sila ng karapatan upang tingnan, baguhin at pagbutihin ang code ng mapagkukunan, kaya ang mga pakete ng software. Ito ay isang tao ng ang mga dahilan kung bakit ang MySQL ay maging kaya napakalaki kilala.

Quick Update at Tao Friendly

Kapag ang pamamahala sistema sa iba pang mga database tulad ng Oracle ay mabagal sa mga update MySQL bihira ipaalam ang kanilang mga customer maghintay. Sa bagong at upgrade na bersyon darating ang higit pa kaysa sa madalas at ang unang posisyon bilang pangunahing server database mukhang MySQL ay natuklasan nito lugar. Kilala at ginagamit sa karamihan sa Linux na programa pinaiiral, na lamang ang mangyayari sa isang ginustong umaandar na paraan para sa mga net server, MySQL ay din mabilis at maaasahang.

cPanel, phpMyAdmin at MySQL

Isang mahusay na halimbawa ng platform ng isang baguhan sa paggamit database ay ang control panel na nagho-host ng maraming mga internet ay paggawa ng paggamit ng cPanel. Hindi lamang ang tao ay may access sa tutorial video upang lumikha ng database ngunit ang phpMyAdmin function na ay nag-aalok ng ang user na visual aid sa pamamahala ng maraming mga gawain MySQL. Bukod dito ang pagkakaroon ng MySQL ay nagbibigay-daan sa maraming salita malawak na web host na magbigay ng PHP script na nagbibigay-kakayahan sa mga tao upang bumuo ng mga dynamic na mga aplikasyon para sa kanyang / ang kanyang web page

Rocky Rasonable

A na Filipino Senior PHP programmer, Web Developer at Webmaster batay sa Davao, Pilipinas. Dalubhasa sa Joomla, WordPress, Soholaunch, Oscommerce, Drupal, Social Media Sites, at iba pa

Higit pang mga Post - Website

PHP MySQL Tutorial

1.) CCCA sa pamamagitan ng IDX Web disenyo

Sistema ng pamamahala ng nilalaman na batay sa PHP at MySQL. Malakas pa simpleng CMS para sa lahat. Komprehensibong pag-andar. Pagpepresyo tila makatwirang para sa maliit na kumpanya. Madaling i-install at user friendly na. Magagamit lamang para sa lahat ng mga disenyo ng IDX Web Kliyente. Makipag-ugnayan sa IDX Web disenyo at Humiling ng isang quote

2.) Joomla sa pamamagitan ng Wilco Jansen

Isang award-winning na pamamahala ng nilalaman system (CMS), na nagbibigay-daan sa iyo upang bumuo ng mga Web site at malakas na online na mga application. Maraming aspeto, kabilang ang kadalian ng paggamit at posibilidad na pahabain, ginawa Joomla ang pinaka-popular na mga Web site ng software na magagamit. Pinakamaganda sa lahat, Joomla ay isang bukas na pinagmulan ng solusyon na ay malayang magagamit sa lahat.

3.) WordPress sa pamamagitan ng Ryan Boren

Estado-ng-ang-sining-publish platform na may isang pagtutok sa aesthetics, web pamantayan, at usability. WordPress ay parehong libre at napakahalaga sa parehong oras.
Higit pang mga lamang, WordPress ay kung ano ang ginagamit mo kung kailan mo nais na magtrabaho sa iyong blogging software, hindi labanan ito.

4.) Soholaunch

Isang madaling-gamitin ang paglikha ng website na tool upang matulungan kang bumuo, magpanatili, at pamahalaan ang iyong mga personal o negosyo website. Ito ay tumatakbo mula sa iyong website, madaling kumuha ng mga order ng shopping cart online, lumikha ng mga form, at i-edit ang mga pahina ng site mula sa anumang computer sa mundo!

5.) Drupal

Isang libreng pakete ng software na nagpapahintulot sa isang indibidwal o ng isang komunidad ng mga gumagamit upang madaling-publish, pamahalaan at isaayos ang isang malawak na iba't-ibang mga nilalaman sa isang website. Mga sampu-sampung libo-libo ng mga tao at mga organisasyon ay gumagamit ng Drupal sa mga marka ng kapangyarihan ng iba't-ibang mga web site

Rocky Rasonable

A na Filipino Senior PHP programmer, Web Developer at Webmaster batay sa Davao, Pilipinas. Dalubhasa sa Joomla, WordPress, Soholaunch, Oscommerce, Drupal, Social Media Sites, at iba pa

Higit pang mga Post - Website

PHP MySQL Tutorial

Ang unang bagay na kailangan naming gawin ay kumonekta sa ang database.

mysql_connect("somehost", "username", "password") or die ("Can't connect!");

This will try to connect to the database on somehost and login with “username” as the username and “password” as the password. If it can’t, it will output an error message saying that it can’t connect. For your own code be sure to change somehost to your host (most of the times it’s localhost, ask your admin), username to your username (duh), and password to your password. Another way to connect to a database is to open a persistent connection. To do this, use the mysql_pconnectfunction and pass it the same arguments as mysql_connect. Why open a persistent connection? When you call mysql_pconnect, instead of going out and opening a connection to the database, it sees if one is already open, if it is, the script will use it. Also, when the script has finished executing, the connection to the database will not automatically be closed like it is when using mysql_connect. This way the connection can be used later on. Using a persistent connection is a good idea if your scripts constantly need to connect to the database.

After we have opened a connection to the database, we then select a database.

mysql_select_db("database_name") or die("Can't select database!");

This will try to select the database named “database_name” (for your own code change it to the name of your database). If it can’t select the database, it will output and error. Once you’re actually connected to a database, you will want to query a table in the database to get whatever you want done. A query looks like this:

mysql_query("Some query");

Common queries are SELECTand INSERT For full documentation go to the mysql web site ( http://www.mysql.com ). Another common php function is mysql_num_rows; if it isn’t obvious this gets the number of rows from a query. Here is an example of how it can be used with mysql_query:

<?php

  $result= mysql_query("SELECT * FROM some_table");

  $number_of_rows= @mysql_num_rows($result);

  if ($number_of_rows == 0)

  {

    echo "Sorry there are no rows";

  }

  else {

    echo "Yes! we found some rows!";

  }

?>

Now you may be wondering why I put the @ sign before mysql_num_rows. In php, the @ sign suppress errors; I put it in front of mysql_num_rows so that if there are no rows, MySQL will not output a bunch of errors. So when would mysql_num_rows be useful? Well, you could use it for an authentication script which searchs the database for a username and password and if it doesn’t find any (i.e. if no rows are returned), it tells the user that the username, or password, are not correct.

Another really useful function is mysql_fetch_array, because it gets the rows and puts them in an array that contains the name of the rows. That way instead of having to access each row by number you can do it by name! For example, let’s say that our database looked like this:

We would use the following code to get the users’ names and output them:

<?php

  echo "The users in this database are: <br>";

  $result= mysql_query("SELECT * FROM some_table");

  while ($row= mysql_fetch_array($result))

  {

    $username= $row["User"];

    echo "$username<br>";

  }

?>

This will output all the usernames in a database; you can add error checking if you like. The while statement is read “while there are rows that satisfy the query, put the contents of the row from the column ‘User’ into the variable ‘username,’ and print the usernames (each on a new line) to an HTML page.”

Now let’s cover a couple of functions that actually work with the database. The first is mysql_create_db, don’t you just love how the functions are named you can figure out what they do just by looking at the function name, this one obviously creates a database. Here’s how to use it:

<?php

  echo "I am going to try to create a database...<br>";

  if (mysql_create_db("test_database"))

  {

    echo "Hooray, I've created the database!<br>";

  }

  else {

    echo "Darn couldn't create the database! because: ";

    echo "mysql_error() <br>";

  }

?>

You can see I used a new function, mysql_error, you don’t really need to know too much about it, all it does is return the error string sent by MySQL. Now since we learned how to create a database, how’s about we learn to delete one. To do that use the mysql_drop_db, here is how to use it:

<?php

  echo "I am going to try to delete a database...<br>";

  $result= mysql_drop_db("test_database");

  if (!$result)

  {

    echo "Darn couldn't I couldn't delete the database!<br>";

  }

  else {

    echo "Hooray, I've deleted the database<br>";

  }

?>

You can see that the syntax is very similar to that of mysql_create_db, just pop the name of the database you want to delete into the function.

The next two items aren’t functions, rather they are queries that you can use to manage an existing table. The following query will insert data into a database:

<?php

  echo "I am going to try to insert data into a table...<br>";

  $result= mysql_query("INSERT INTO test_database (username, password) VALUES

	               (Rahim, adfjaldadfsdaf)");

  if (!$result)

  {

    echo "Darn couldn't I couldn't delete the database!<br>";

  }

  else {

    echo "Hooray, I've deleted the database<br>";

  }

?>

This query should be pretty obvious, it inserts the data defined in between the parentheses into the rows. Just a little note to remember, the order in which you write out the column names is the order your data will be entered (i.e. a row with the contents Rahim will be entered under username, not password since we wrote username then pasword, if it was reveresd Rahim would be put under password).

The next query we’ve already gone over, I’m just going to add to it; after I’m done you should be able to use it to help create a simple search engine (upcomming tutorial)! For the sake of brevity I’ll remove all the extra php stuff and just show you the “meat” of the code.

$result= mysql_query("SELECT name FROM some_table WHERE name=Joe AND

         lastname=Sixpack OR lastname=Becker ORDER BY lastname LIMIT 20");

Now I know that looks like a long query, but it’s not really all that bad. What it’s pretty much saying is: “Get me the name from some_table where the name is Joe and the lastname is Sixpack or Becker, oh and by the way while your at it, put it in alphabetical order by the lastname; oh and one last thing, just get the first 20 results please.” MySQL has lots of other filters that you can add on to the SELECT statement, I highly suggest you download the MySQL documentation and give it a perusing.

Rocky Rasonable

A filipino Senior PHP Programmer, Web Developer and Webmaster based in Davao, Philippines. Expert in Joomla, WordPress, Soholaunch, Oscommerce, Drupal, Social Media Sites, and etc.

More Posts - Website