Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //function examples
- <?php
- require_once('resources.php');
- //$anzu['db_query']:
- //Execute a sql query
- $anzu['db_query']('query');
- //$anzu['db_insert']:
- //Used to insert rows to a table.
- $anzu['db_insert']('table', array('row'), array('value'));
- //$anzu['db_select']:
- $db_return = $anzu['db_select']("table", '*', '');
- while($posts = mysql_fetch_assoc($db_return, MYSQL_ASSOC)){
- echo $posts['row_element'];
- }
- ?>
- //config.php
- <?php
- $db_host = 'localhost';
- $db_user = 'user';
- $db_pass = 'pass';
- $db_name = 'db';
- ?>
- //resources.php
- <?php
- require_once('config.php');
- //our array functions
- $anzu = array(
- 'db_query' => 'tb_db_query',
- 'db_insert' => 'tb_db_insert',
- 'db_select' => 'tb_db_select'
- );
- function tb_db_connect(){
- //lets get our vars for the db connect
- global $db_host, $db_user, $db_name, $db_pass;
- //lets connect
- $connect = mysql_connect($db_host, $db_user, $db_pass) or die ('Error connecting to database');
- //select the db
- mysql_select_db($db_name);
- return $connect;
- }
- function tb_db_select($table, $fields, $special){
- $connect = tb_db_connect();
- if($fields != '*'){
- $str = implode(', ',$fields);
- }
- //seup the query
- $db_query = 'SELECT '.$str.' FROM '.$table.' '.$special;
- //run the query
- $db_return = mysql_query($db_query) or die(mysql_error());
- //close the db connection
- mysql_close($connect);
- //return what the db had to say
- return $db_return;
- }
- //database
- function tb_db_query($string){
- $connect = tb_db_connect();
- //do the thing with the stuff
- $db_return = mysql_query($string) or die(mysql_error());
- //close it
- mysql_close($connect);
- //return?
- return $db_return;
- }
- function tb_db_insert($db_table, $fields, $values){
- $connect = tb_db_connect();
- //setup the array for the clean vars
- $clean = array();
- //clean them for sql
- foreach($values as $v){
- array_push($clean, mysql_real_escape_string($v));
- }
- //seup the query
- $db_query = 'INSERT INTO '.$db_table.' ('.implode(',',$fields).') VALUES("'.implode('", "',$clean).'")';
- //run the query
- $db_return = mysql_query($db_query) or die(mysql_error());
- //close the db connection
- mysql_close($connect);
- //return what the db had to say
- return $db_return;
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement