[b]WARNING:[/b] >>No newbie question here. For those who are advance user only Thanks. >>You should have your own idea how to use this code. Not from me. >>You must try to learn the syntax I have made. PREVIEW [url=http://friendster.com/aroldz]HERE[/url] (I use this to save visitor's data) [b]WHY DO I NEED DATABASE?[/b] >> you can save many data using database [i](eg. visitors data)[/i] [b]WHAT IS SQL/MySQL?[/b] >>This is language that is mostly used to save data in websites [i](eg. friendster, yahoo, even friendstertalk! etc.)[/i] [b]WHAT IS THE ODDS[/b] >>This have fast connection compability >>You own your own data >>No one can decode your database encoding [b]WHAT ARE DIS ADVANTAGE[/b] >>This codes have no special features like in SQL language such as ORDER BY, DEFAULT, CREATE DATABASE ([i]cause you don't need to create another database[/i]) I make the codes for you to have your own database without connecting to other SQL server. Just Copy this to your file named [color=red]sql.php[/color] [i](eg. in your [url=http://ripway.com]ripway account)[/url] or other owned website[/i] this is the code: <">then, in any of your PHP files, [i](eg. your overlay profile in ripway)[/i], include the code above like including a <script> in your html page. This is the code: <">How to use this code? Here it is: <">[b]HOW DO I CONNECT TO MY OWN DATABASE?[/b] make any file with empty content, just name it what you want you can name it [color=orange]info.php, database.xml, blah.extension, blah.cute[/color]. then you connect your SQL Object to that URL: <">the SCRIPT ABOVE will be the compiler It will program your file like database [b]WHY NEEDED USERNAME & PASSWORD?[/b] The encodement of the DATABASE will vary depend on your user_name and password you made. It will be the base encoding word for your database. [color=#777788][b]SYNTAXES[/b][/color] [b]CONNECT[/b]: SYNTAX>> [color=#009900][b](SQL Object)[/b]->connect( [b]"URL"[/b],"my_username","my_password");[/color] [i][color=red]*URL must be in your server directory[/color][/i] Use select to get information in database. Like this: <">[b]CREATE TABLE[/b]: SYNTAX>> [color=#009900][b](SQL Object)[/b]->createTable("TABLE_NAME",array_of_field_names,array_of_field_type,array_of_field_increment_option);[/color] [i][color=red]*TABLE_NAME must be alphanumeric, if nOt it will cost severe error! You'll loose all your data![/color][/i] Use select to get information in database. Like this: <">[b]SELECT[/b]: ([i]select/get information from the database table[/i]) SYNTAX>> [color=#009900][b](SQL Object)[/b]->select([i]table_name[/i],[i]array_of_fields[/i])[/color] Use select to get information in database. Like this: <">[b]INSERT:[/b] ([i]insert a data to database[/i]) SYNTAX>> [color=#009900][b](SQL Object)[/b]->insert([i]table_name[/i],[i]array_of_fields[/i],[i]array_of_values[/i])[/color] Like this:<">[b]OTHER:[/b] Just learn the SYNTAXES I've made from the code above. Other fuctions are: [i]UPDATE[/i] [i]DELETE[/i] [i]CATCH ERROR FUNCTION[/i] [i](other function will be updated soon)[/i]

Last edited by zidaine_38 (2011-02-25 08:45:00)