DiskPie

Upload
Upload
<table width="100%" border="0" cellspacing="0" cellpadding="0">
 <tr> 
 <td colspan="2"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">MySQL 
  Databases seem like a lot of work to use but it's not really that hard. 
  Let's start.</font></td>
 </tr>
 <tr> 
 <td width="5%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
 <td width="95%"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
 </tr>
 <tr> 
 <td colspan="2"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">To 
  connect to a MySQL database you need to do the following:</font></td>
 </tr>
 <tr> 
 <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
 <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>$link 
  = mysql_connect("host","user","pass");</strong></font></td>
 </tr>
 <tr> 
 <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
 <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">details: $link 
  is the value that will enable you to work with the database afterwards (eg: 
  close it), the mysql_connect tells php to open a connection to mysql host 
  "host" then use user and pass for username and password. The following 
  line of code is recommended before you do anything else with the database:</font></td>
 </tr>
 <tr> 
 <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
 <td> <p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>if 
  (! $link)<BR>
  die("Error: Could not connect to MySQL"); </strong></font></p></td>
 </tr>
 <tr> 
 <td> </td>
 <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">details: this 
  means if the link is empty then kill the script because mysql did not respond 
  to the request and there is nothing to work with.</font></td>
 </tr>
 <tr> 
 <td> </td>
 <td> </td>
 </tr>
 <tr> 
 <td colspan="2"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">The 
  to open a database to work with you need to do the following:</font></td>
 </tr>
 <tr> 
 <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
 <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>mysql_select_db("dbname");</strong></font></td>
 </tr>
 <tr> 
 <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
 <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">details: this 
  tells MySQL to open "dbname" to work within. The following is 
  what is recommended to write for this line of code:</font></td>
 </tr>
 <tr> 
 <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
 <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>mysql_select_db("dbname") 
  or die("Error: Could not open database");</strong></font></td>
 </tr>
 <tr> 
 <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
 <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">details: this 
  tells PHP if the database could not be open then kill the script with the 
  text "Error: Could not open database"</font></td>
 </tr>
 <tr> 
 <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
 <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
 </tr>
 <tr> 
 <td colspan="2"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">To 
  write informations not existing into the database you need to do the following:</font></td>
 </tr>
 <tr> 
 <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
 <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>mysql_query("INSERT 
  INTO tablenamehere VALUES( 'val1', 'val2', ETC.)");</strong> </font></td>
 </tr>
 <tr> 
 <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
 <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">details: This 
  inserts values in order to MySQL. You can add only same amount of values 
  to the database has their are existing columns. to skip a column you just 
  add blank wich is ''</font></td>
 </tr>
 <tr> 
 <td> </td>
 <td> </td>
 </tr>
 <tr> 
 <td colspan="2"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">To 
  update a row in the database you need to do the following:</font></td>
 </tr>
 <tr> 
 <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></td>
 <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>mysql_query("UPDATE 
  tablenamehere SET valname = 'val1', valname2 = 'val2', etc.");</strong></font></td>
 </tr>
 <tr> 
 <td> </td>
 <td> </td>
 </tr>
 <tr> 
 <td colspan="2"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">To 
  read how many rows is there in your database that are matching with something 
  you need to do the following:</font></td>
 </tr>
 <tr> 
 <td> </td>
 <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>$query 
  = mysql_query("SELECT * FROM tablenamehere WHERE valname = 'something'");<BR>
  $all_records = mysql_num_rows($query);</strong></font></td>
 </tr>
 <tr> 
 <td> </td>
 <td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">details: this 
  gets all values that match 'something' in 'tablenamehere'. * means everything 
  you can change that with a specific column<BR>
  $all_records will now hold the number of rows matching with your query.</font></td>
 </tr>
 <tr> 
 <td colspan="2"> </td>
 </tr>
 <tr> 
 <td colspan="2"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">To 
  get each column into a variable to be able to print it to the user you need 
  to do the following:</font></td>
 </tr>
 <tr> 
 <td> </td>
 <td><strong><font size="2" face="Verdana, Arial, Helvetica, sans-serif">$query 
  = mysql_query("SELECT * FROM tablenamehere WHERE valname = 'something'");<BR>
  $row = mysql_fetch_array($query);<BR>
  echo $row["valname1"];</font></strong></td>
 </tr>
 <tr> 
 <td> </td>
 <td> </td>
 </tr>
 <tr> 
 <td colspan="2"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">The 
  following is required after all your pages that uses mysql:</font></td>
 </tr>
 <tr> 
 <td> </td>
 <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>mysql_close($link);</strong></font></td>
 </tr>
 <tr> 
 <td> </td>
 <td> </td>
 </tr>
 <tr> 
 <td colspan="2"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">This 
  should be enough to help you start out with mysql. Comment and Rate :)</font></td>
 </tr>
</table>