Advertisement
3_2004-2005 Graphics/ Sound #145856

ENERGiE - Particle Engine v2.26

PARTICLE SYSTEM ENGINE, use this class to create fantastic GFX effects in OpenGL! Try to change the default settings and will be simple to create flame, portal, bombFX, snow and other similar particle FXs!

AI

AI Summary: This codebase represents a historical implementation of the logic described in the metadata. Our preservation engine analyzes the structure to provide context for modern developers.

Source Code
original-source
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>
Upload
Original Comments (3)
Recovered from Wayback Machine