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
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