Ngoding PHP bersama Master

Halo para Master.. pasti sudah tidak asing lagi PHP 7 untuk jaman now, karena denger denger php 5 sudah old banget, padahal baru juga belajar PHP tapi udah berubah lagi bahasanya.. eh engga denk.. bahasanya tetap sama yaitu PHP menurut om WIKI.

Mungkin ada sebagian para Master PHP yang sudah terlanjur menggunakan MySQL terutama yang native (tidak berlaku pada framework besar seperti: Codeigniter, Laravel, Dll.) apa perlu merubah 1 per 1 yang asalnya MySQL menjadi MySQLI, yang bener aja sedangkan project nya terbilang lumayan besar dengan fungsi puluhan, ratusan bahkan ribuan.

Tapi untuk kali caranya gampang sekali loh para master, yu ikutin langkah-langkahnya.

1. buat file :

php5.php

2. sertakan code ini :

<?php function is_mysqli_or_resource($r) {
 # get the type of the variable
 switch(gettype($r)) {
  # if it is a resource - could be mysql, file handle etc...
  case 'resource':
   return true;
  # if it is an object - must be a mysqli object then
  case 'object':
   # is this an instance of mysqli?
   if ($r instanceof mysqli) {
    # make sure there is no connection error
    return !($r->connect_error);
   }
   # or is this an instance of a mysqli result?
   if ($r instanceof mysqli_result) {
    return true;
   }
   return false;
  # negative on all other variable types
  default:
   return false;
 }
}

# alias for is_mysqli_or_resource()
function is_mysql_resource($r) {
 return is_mysqli_or_resource($r);
}

# alias for is_mysqli_or_resource()
function is_generic_resource($r) {
 return is_mysqli_or_resource($r);
}

# to check if an item is a resource/object - replace is_resource with this
# old version, this will break if testing file handles too
function is_mysql_resource_old($result) {

 # first try to treat as resource if original mysql is loaded
 if (extension_loaded('mysql')) return is_resource($result);

 # or if mysqli is loaded, try to check object
 if (extension_loaded('mysqli')) return is_object($result);

 die('Fatal error, mysqli extension not loaded.');
}

# only do this is mysql extension is not there
if (!extension_loaded('mysql')) {

 # check if mysqli extension is loaded - its required as we rely on it
 if (!extension_loaded('mysqli')) die('Fatal error, mysqli extension not loaded.');

 # --- helper variables and constants ---------------------------------------------------------------------------------------------------

 # a list of connections, used to get the last one
 $mysql_links = array();

 # our own constants to reach default connection values in INI file
 define('MYSQL_DEFAULT_HOST', ini_get("mysql.default_host"));
 define('MYSQL_DEFAULT_USER', ini_get("mysql.default_user"));
 define('MYSQL_DEFAULT_PASSWORD', ini_get("mysql.default_password"));

 # --- MySQL constants (from PHP.net) ---------------------------------------------------------------------------------------------------

 # MySQL client constants
 define('MYSQL_CLIENT_COMPRESS', MYSQLI_CLIENT_COMPRESS);  # Use compression protocol
 define('MYSQL_CLIENT_IGNORE_SPACE', MYSQLI_CLIENT_IGNORE_SPACE); # Allow space after function names
 define('MYSQL_CLIENT_INTERACTIVE', MYSQLI_CLIENT_INTERACTIVE);  # Allow interactive_timeout seconds
          # (instead of wait_timeout ) of
          # inactivity before closing the connection.
 define('MYSQL_CLIENT_SSL', MYSQLI_CLIENT_SSL);    # Use SSL encryption. This flag is only
          # available with version 4.x of the MySQL
          # client library or newer. Version 3.23.x is
          # bundled both with PHP 4 and Windows binaries
          # of PHP 5.

 # mysql_fetch_array() uses a constant for the different types of result arrays. The following constants are defined:

 # MySQL fetch constants
 define('MYSQL_ASSOC', MYSQLI_ASSOC); # Columns are returned into the array having
      # the fieldname as the array index.

 define('MYSQL_BOTH', MYSQLI_BOTH); # Columns are returned into the array having
      # both a numerical index and the fieldname as
      # the array index.

 define('MYSQL_NUM', MYSQLI_NUM); # Columns are returned into the array having a
      # numerical index to the fields. This index
      # starts with 0, the first field in the result.

 # --- helper functions ---------------------------------------------------------------------------------------------------

 # internal function to convert bitflags of mysqli to flags in text of mysql
 # thanks to andre at koethur dot de at http://www.php.net/manual/en/mysqli-result.fetch-fields.php#101828
 function mysql_field_bitflags_to_flags($flags_num) {

  $flags = array();
  $constants = get_defined_constants(true);
  foreach ($constants['mysqli'] as $c => $n) {
   if (preg_match('/MYSQLI_(.*)_FLAG$/', $c, $m)) {
    if (!array_key_exists($n, $flags)) {
     $flags[$n] = $m[1];
    }
   }
  }
  $result = array();
  foreach ($flags as $n => $t) {
   if ($flags_num & $n) {
    $result[] = $t;
   }
  }
  return implode(' ', $result);
 }

 # function to convert bit-types of mysqli to types in text of mysql
 # thanks to andre at koethur dot de at http://www.php.net/manual/en/mysqli-result.fetch-fields.php#101828
 function mysql_field_bittypes_to_types($type_id) {

  $types = array();
  $constants = get_defined_constants(true);
  foreach ($constants['mysqli'] as $c => $n) {
   if (preg_match('/^MYSQLI_TYPE_(.*)/', $c, $m)) {
    $types[$n] = $m[1];
   }
  }

  return array_key_exists($type_id, $types)? $types[$type_id] : NULL;
 }

 # lib helper function - to ensure mysql link as mysqli always needs one
 # but mysql takes last one
 function mysql_ensure_link($link_identifier) {
  # no link specified
  if ($link_identifier === NULL) {
   global $mysql_links;

   # no connection at all - then go null
   if (!count($mysql_links)) return NULL;

   # get the last item of the array
   $last = end($mysql_links);

   # return the last stored link
   return $last['link'];
  }

  return $link_identifier;
 }

 # --- MySQL functions (from PHP.net) ---------------------------------------------------------------------------------------------------

 # mysql_affected_rows - Get number of affected rows in previous MySQL operation
 # int mysql_affected_rows ([ resource $link_identifier = NULL ] )
 # int mysqli_affected_rows ( mysqli $link )
 function mysql_affected_rows($link_identifier = NULL) {
  # mysql_affected_rows = -1 if the last query failed
  # mysqli_affected_rows = -1 indicates that the query returned an error
  $temp = mysqli_affected_rows(mysql_ensure_link($link_identifier));
  if ($temp === NULL || $temp === false) {
   return -1;
  }
  return $temp;
 }

 # mysql_client_encoding - Returns the name of the character set
 # string mysql_client_encoding ([ resource $link_identifier = NULL ] )
 # mysqli_character_set_name ( mysqli $link )
 function mysql_client_encoding($link_identifier = NULL) {
  # note that mysqlI_client_encoding ALSO is deprecated, so we cannot use that
  # mysql_client_encoding/mysqli_character_set_name = Returns the default character set name for the current connection.
  $temp = mysqli_character_set_name(mysql_ensure_link($link_identifier));
  if ($temp === NULL) {
   return false;
  }
  return $temp;
 }

 # mysql_close - Close MySQL connection
 # bool mysql_close ([ resource $link_identifier = NULL ] )
 # bool mysqli_close ( mysqli $link )
 function mysql_close($link = NULL) {

  # mysql_close/mysqli_close = returns TRUE on success or FALSE on failure.

  global $mysql_links;
  $link = mysql_ensure_link($link);

  $thread_id = isset($link->thread_id) && is_numeric($link->thread_id) ? $link->thread_id : false;

  $result = mysqli_close($link);

  # did the removal suceed and and we have thread id
  if ($result && $thread_id) {
   # walk the links
   foreach ($mysql_links as $k => $v) {

    # does this thread-id match the one we just removed?
    if ($v['thread_id'] === $thread_id) {
     # then remove it from connection array
     array_splice($mysql_links, $k, 1);
     break;
    }
   }

  # when connection already has been closed this error appears:
  # Couldn't fetch mysqli in mysql.php on line xxx
  # and this gives null instead of false
  } else if ($result === null) {
   return false;
  }

  return $result;
 }

 # mysql_connect - Open a connection to a MySQL Server
 # resource mysql_connect ([ string $server = ini_get("mysql.default_host") [, string $username = ini_get("mysql.default_user") [, string $password = ini_get("mysql.default_password") [, bool $new_link = false [, int $client_flags = 0 ]]]]] )
 # mysqli mysqli_connect ([ string $host = ini_get("mysqli.default_host") [, string $username = ini_get("mysqli.default_user") [, string $passwd = ini_get("mysqli.default_pw") [, string $dbname = "" [, int $port = ini_get("mysqli.default_port") [, string $socket = ini_get("mysqli.default_socket") ]]]]]] )
 function mysql_connect($server = MYSQL_DEFAULT_HOST, $username = MYSQL_DEFAULT_USER, $password = MYSQL_DEFAULT_PASSWORD, $new_link = false, $client_flags = 0) {
  global $mysql_links;

  # no newlink but s/u/p matches prev ones-take last link
  if (!$new_link) {
   global $mysql_links;

   # are there prev links?
   if (count($mysql_links)) {

    # get the last one made
     $last = end($mysql_links);

    # does the s/u/p match last one?
    if ($server === $last['server'] && $username === $last['username'] && $password === $last['password'] && is_resource($last['link'])) {
     # then take that
     return mysql_ensure_link(NULL);
    }
   }
  }

  # try to connect using current credentials
  $link = mysqli_connect($server,$username,$password,"");

  if (mysqli_connect_errno()) {
   # printf("Connect failed: %s\n", mysqli_connect_error());
   # die();
   return false;
  }

  # store this
  $mysql_links[] = array(
   'thread_id' => $link->thread_id,
   'server' => $server,
   'username' => $username,
   'password' => $password,
   'link' => $link
  );

  return $link;
 }

 # mysql_create_db - Create a MySQL database
 # bool mysql_create_db ( string $database_name [, resource $link_identifier = NULL ] )
 # CREATE DATABASE
 function mysql_create_db($database_name, $link_identifier = NULL) {
  # mysql_create_db/mysql_query+CREATE DATABASE = false on error
  return mysql_query('CREATE DATABASE '.mysql_real_escape_string($database_name), $link_identifier);
 }

 # mysql_data_seek - Move internal result pointer
 # bool mysql_data_seek ( resource $result , int $row_number )
 # bool mysqli_data_seek ( mysqli_result $result , int $offset )
 function mysql_data_seek($result , $row_number) {
  # mysql_data_seek/mysqli_data_seek = false on error
  $temp = mysqli_data_seek($result, $row_number);
  if ($temp === NULL) {
   return false;
  }
  return true;
 }

 # mysql_db_name - Retrieves database name from the call to # mysql_list_dbs
 # string mysql_db_name ( resource $result , int $row [, mixed $field = NULL ] )
 # SELECT DATABASE()
 function mysql_db_name($result , $row, $field = NULL) {
  # return mysql_query('SELECT DATABASE()', mysql_ensure_link($link_identifier));

  # null does not fit mysql_result
  $field = $field === null ? 0 : $field;

  return mysql_result($result, $row, $field);
 }

 # mysql_db_query - Selects a database and executes a query on it
 # resource mysql_db_query ( string $database , string $query [, resource $link_identifier = NULL ] )
 # mysqli_select_db() then the query
 function mysql_db_query($database, $query, $link_identifier = NULL) {
  # mysql_db_query = false on error, mysql_query+sql = false on error
  if (mysql_select_db($database, $link_identifier) !== true) {
   return false;
  }
  return mysql_query($query, $link_identifier);
 }

 # mysql_drop_db - Drop (delete) a MySQL database
 # bool mysql_drop_db ( string $database_name [, resource $link_identifier = NULL ] )
 # DROP DATABASE
 function mysql_drop_db($database_name, $link_identifier = NULL) {
  # mysql_drop_db = false on error, mysql_query+DROP DATABASE = false on error
  return mysql_query('DROP DATABASE '.mysql_real_escape_string($database_name), $link_identifier);
 }

 # mysql_errno -Returns the numerical value of the error message from previous MySQL operation
 # int mysql_errno ([ resource $link_identifier = NULL ] )
 # int mysqli_errno ( mysqli $link )
 function mysql_errno($link_identifier = NULL) {
  # mysql_errno/mysqli_errno = returns a number, 0 if no error
  $temp = mysqli_errno (mysql_ensure_link($link_identifier));
  if ($temp === NULL) {
   return false;
  }
  return $temp;
 }

 # mysql_error - Returns the text of the error message from previous MySQL operation
 # string mysql_error ([ resource $link_identifier = NULL ] )
 # string mysqli_error ( mysqli $link )
 function mysql_error($link_identifier = NULL) {
  # mysql_error/mysqli_error = returns empty string on no error
  $temp = mysqli_error(mysql_ensure_link($link_identifier));
  if ($temp === NULL) {
   return false;
  }
  return $temp;
 }

 # mysql_escape_string - Escapes a string for use in a # mysql_query
 # string mysql_escape_string ( string $unescaped_string )
 # string mysqli::real_escape_string ( string $escapestr )
 function mysql_escape_string($unescaped_string) {
  # mysql_escape_string = returns the escaped string
  # mysql_real_escape_string = returns FALSE on error
  return mysql_real_escape_string($unescaped_string);
 }

 # mysql_fetch_array - Fetch a result row as an associative array, a numeric array, or both
 # array mysql_fetch_array ( resource $result [, int $result_type = MYSQL_BOTH ] )
 # mixed mysqli_fetch_array ( mysqli_result $result [, int $resulttype = MYSQLI_BOTH ] )
 function mysql_fetch_array($result, $result_type = MYSQL_BOTH) {

  # mysql_fetch_array = Returns an array of strings that corresponds to the fetched row, or FALSE if there are no more rows
  # mysqli_fetch_array = Returns an array of strings that corresponds to the fetched row or NULL if there are no more rows in resultset

  # store the result in a temporarily array
  $temp = mysqli_fetch_array($result, $result_type);

  # is the result null?
  if ($temp === NULL) {
   # then return false as the old function did
   return false;
  }
  return $temp;
 }

 # mysql_fetch_assoc - Fetch a result row as an associative array
 # array mysql_fetch_assoc ( resource $result )
 # array mysqli_fetch_assoc ( mysqli_result $result )
 function mysql_fetch_assoc ($result) {
  # mysql_fetch_assoc = returns FALSE if there are no more rows
  # mysqli_fetch_assoc = returns NULL if there are no more rows in resultset
  $temp = mysqli_fetch_assoc($result);

  # is the result null?
  if ($temp === NULL) {
   # then return false as the old function did
   return false;
  }
  return $temp;
 }

 # mysql_fetch_field - Get column information from a result and return as an object
 # object mysql_fetch_field ( resource $result [, int $field_offset = 0 ] )
 # object mysqli_fetch_field ( mysqli_result $result ) - but field_offset is missing
 function mysql_fetch_field($result, $field_offset = NULL) {
  # if field offset is specified
  if (is_numeric($field_offset)) {
   # then seek to that
   mysqli_field_seek($result, $field_offset);
  }
  $temp = mysqli_fetch_field($result);

  if ($temp === NULL) {
   return false;
  }
  return $temp;
 }

 # mysql_fetch_lengths - Get the length of each output in a result
 # array mysql_fetch_lengths ( resource $result )
 # array mysqli_fetch_lengths ( mysqli_result $result )
 function mysql_fetch_lengths($result) {
  # mysql_fetch_lengths/mysqli_fetch_lengths = FALSE on error
  $temp = mysqli_fetch_lengths($result);
  if ($temp === NULL) {
   return false;
  }
  return $temp;
 }

 # mysql_fetch_object - Fetch a result row as an object
 # object mysql_fetch_object ( resource $result [, string $class_name [, array $params ]] )
 # object mysqli_fetch_object ( mysqli_result $result [, string $class_name [, array $params ]] )
 function mysql_fetch_object ($result, $class_name=NULL, $params=NULL) {

  # mysql_fetch_object = FALSE if there are no more rows
  # mysqli_fetch_object = NULL if there are no more rows in resultset

  if ($class_name !== NULL && $params !== NULL) {
   $temp = mysqli_fetch_object($result, $class_name, $params);
  } else if ($class_name !== NULL) {
   $temp = mysqli_fetch_object($result, $class_name);
  } else {
   $temp = mysqli_fetch_object($result);
  }

  # is the result null?
  if ($temp === NULL) {
   # then return false as the old function did
   return false;
  }
  return $temp;
 }

 # mysql_fetch_row - Get a result row as an enumerated array
 # array mysql_fetch_row ( resource $result )
 # mixed mysqli_fetch_row ( mysqli_result $result )
 function mysql_fetch_row ($result) {

  # mysql_fetch_row = FALSE if there are no more rows
  # mysqli_fetch_row = NULL if there are no more rows in result set

  $temp = mysqli_fetch_row($result);

  # is the result null?
  if ($temp === NULL) {
   # then return false as the old function did
   return false;
  }
  return $temp;
 }

 # mysql_field_flags - Get the flags associated with the specified field in a result
 # string mysql_field_flags ( resource $result , int $field_offset )
 # mysqli_fetch_field_direct() [flags]
 # -> object mysqli_fetch_field_direct ( mysqli_result $result , int $fieldnr )
 function mysql_field_flags($result, $field_offset) {
  # mysql_field_flags = FALSE on failure
  # mysqli_fetch_field_direct = FALSE if no field information for specified fieldnr is available
  $tmp = mysqli_fetch_field_direct($result, $field_offset);
  if (!is_object($tmp)) return false;
  $tmp = (array)$tmp;
  return isset($tmp['flags']) ? mysql_field_bitflags_to_flags($tmp['flags']) : false;
 }

 # mysql_field_len - Returns the length of the specified field
 # int mysql_field_len ( resource $result , int $field_offset )
 # mysqli_fetch_field_direct() [length]
 # -> object mysqli_fetch_field_direct ( mysqli_result $result , int $fieldnr )
 function mysql_field_len($result, $field_offset) {
  # mysql_field_len = FALSE on failure
  # mysqli_fetch_field_direct = FALSE if no field information for specified fieldnr is available
  $tmp = mysqli_fetch_field_direct($result, $field_offset);
  if (!is_object($tmp)) return false;
  $tmp = (array)$tmp;
  return isset($tmp['length']) ? $tmp['length'] : false;
 }

 # mysql_field_name - Get the name of the specified field in a result
 # string mysql_field_name ( resource $result , int $field_offset )
 # mysqli_fetch_field_direct() [name] or [orgname]
 # -> object mysqli_fetch_field_direct ( mysqli_result $result , int $fieldnr )
 function mysql_field_name($result, $field_offset) {
  # mysql_field_name = FALSE on failure
  # mysqli_fetch_field_direct = FALSE if no field information for specified fieldnr is available
  $tmp = mysqli_fetch_field_direct($result, $field_offset);
  if (!is_object($tmp)) return false;
  $tmp = (array)$tmp;
  return isset($tmp['name']) ? $tmp['name'] : false;
 }

 # mysql_field_seek - Set result pointer to a specified field offset
 # bool mysql_field_seek ( resource $result , int $field_offset )
 # bool mysqli_field_seek ( mysqli_result $result , int $fieldnr )
 function mysql_field_seek($result, $field_offset) {
  # mysql_field_seek/mysqli_field_seek = FALSE on failure
  $temp = mysqli_field_seek($result, $field_offset);
  if ($temp === NULL) {
   return false;
  }
  return $temp;
 }

 # mysql_field_table - Get name of the table the specified field is in
 # string mysql_field_table ( resource $result , int $field_offset )
 # mysqli_fetch_field_direct() [table] or [orgtable]
 # -> object mysqli_fetch_field_direct ( mysqli_result $result , int $fieldnr )
 function mysql_field_table($result, $field_offset) {
  # mysql_field_table = error return value not defined
  # mysqli_fetch_field_direct = FALSE if no field information for specified fieldnr is available
  $tmp = mysqli_fetch_field_direct($result, $field_offset);
  if (!is_object($tmp)) return false;
  $tmp = (array)$tmp;
  return isset($tmp['table']) ? $tmp['table'] : false;
 }

 # mysql_field_type - Get the type of the specified field in a result
 # string mysql_field_type ( resource $result , int $field_offset )
 # mysqli_fetch_field_direct() [type]
 # -> object mysqli_fetch_field_direct ( mysqli_result $result , int $fieldnr )
 function mysql_field_type($result, $field_offset) {
  # mysql_field_type = error return value not defined
  # mysqli_fetch_field_direct = FALSE if no field information for specified fieldnr is available
  $tmp = mysqli_fetch_field_direct($result, $field_offset);
  if (!is_object($tmp)) return false;
  $tmp = (array)$tmp;
  return isset($tmp['type']) ? mysql_field_bittypes_to_types($tmp['type']) : false;
 }

 # mysql_free_result - Free result memory
 # bool mysql_free_result ( resource $result )
 # void mysqli_free_result ( mysqli_result $result )
 function mysql_free_result($result) {
  # mysql_free_result = FALSE on failure
  # mysqli_free_result = No value is returned.
  mysqli_free_result($result);
  # note that mysqli does not return any boolean, so we do it
  return true;
 }

 # mysql_get_client_info - Get MySQL client info
 # string mysql_get_client_info ( void )
 # string mysqli_get_client_info ( mysqli $link )
 function mysql_get_client_info($link_identifier = null) {
  # mysql_get_client_info/mysqli_get_client_info = not defined what is returned on error
  # note that mysql does not have a link argument while mysqli does
  return mysqli_get_client_info(mysql_ensure_link($link_identifier));
 }

 # mysql_get_host_info - Get MySQL host info
 # string mysql_get_host_info ([ resource $link_identifier = NULL ] )
 # string mysqli_get_host_info ( mysqli $link )
 function mysql_get_host_info ($link_identifier = NULL) {
  # mysql_get_host_info = FALSE on failure
  # mysqli_get_host_info = error return value not defined
  $temp = mysqli_get_host_info(mysql_ensure_link($link_identifier));
  if ($temp === NULL) {
   return false;
  }
  return $temp;
 }

 # mysql_get_proto_info - Get MySQL protocol info
 # int mysql_get_proto_info ([ resource $link_identifier = NULL ] )
 # int mysqli_get_proto_info ( mysqli $link )
 function mysql_get_proto_info($link_identifier = NULL) {
  # mysql_get_proto_info = FALSE on failure
  # mysqli_get_proto_info = error return value not defined
  $temp = mysqli_get_proto_info(mysql_ensure_link($link_identifier));
  if ($temp === NULL) {
   return false;
  }
  return $temp;
 }

 # mysql_get_server_info - Get MySQL server info
 # string mysql_get_server_info ([ resource $link_identifier = NULL ] )
 # string mysqli_get_server_info ( mysqli $link )
 function mysql_get_server_info($link_identifier = NULL) {
  # mysql_get_server_info = FALSE on failure
  # mysqli_get_server_info = error return value not defined
  $temp = mysqli_get_server_info(mysql_ensure_link($link_identifier));
  if ($temp === NULL) {
   return false;
  }
  return $temp;
 }

 # mysql_info - Get information about the most recent query
 # string mysql_info ([ resource $link_identifier = NULL ] )
 # string mysqli_info ( mysqli $link )
 function mysql_info($link_identifier = NULL) {
  # mysql_info = FALSE on failure
  # mysqli_info = returns empty string on failure
  $temp = mysqli_info(mysql_ensure_link($link_identifier));
  if ($temp === NULL) {
   return false;
  }
  return $temp;
 }

 # mysql_insert_id - Get the ID generated in the last query
 # int mysql_insert_id ([ resource $link_identifier = NULL ] )
 # mixed mysqli_insert_id ( mysqli $link )
 function mysql_insert_id($link_identifier = NULL) {
  # mysql_insert_id = FALSE if no MySQL connection was established
  # mysqli_insert_id = error value not defined
  $temp = mysqli_insert_id(mysql_ensure_link($link_identifier));
  if ($temp === null) {
   return false;
  }
  return $temp;
 }

 # mysql_list_dbs - List databases available on a MySQL server
 # resource mysql_list_dbs ([ resource $link_identifier = NULL ] )
 # SQL Query: SHOW DATABASES
 function mysql_list_dbs ($link_identifier = NULL) {
  global $mysql_list_dbs_cache;

  # mysql_list_dbs/mysql_query = FALSE on failure
  $temp = mysql_query('SHOW DATABASES', mysql_ensure_link($link_identifier));

  $mysql_list_dbs_cache = $temp;

  # when no working link is passed we get null
  if ($temp === NULL) {
   return false;
  }

  return $temp;
 }

 # mysql_list_fields - List MySQL table fields
 # resource mysql_list_fields ( string $database_name , string $table_name [, resource $link_identifier = NULL ] )
 # SQL Query: SHOW COLUMNS FROM sometable
 function mysql_list_fields ($database_name, $table_name, $link_identifier = NULL) {
  # mysql_list_fields/mysql_query = FALSE on failure
  return mysql_query('SHOW COLUMNS FROM '.mysql_real_escape_string($database_name).'.`'.mysql_real_escape_string($table_name).'`', mysql_ensure_link($link_identifier));
 }

 # mysql_list_processes - List MySQL processes
 # resource mysql_list_processes ([ resource $link_identifier = NULL ] )
 # mysqli_thread_id()
 function mysql_list_processes($link_identifier = NULL) {
  # mysql_list_processes = FALSE on failure
  $temp = mysql_query("SHOW PROCESSLIST", mysql_ensure_link($link_identifier));
  if ($temp === null) {
   return false;
  }
  return $temp;
 }

 # mysql_list_tables - List tables in a MySQL database
 # resource mysql_list_tables ( string $database [, resource $link_identifier = NULL ] )
 # SQL Query: SHOW TABLES FROM sometable
 function mysql_list_tables ($database_name, $table_name, $link_identifier = NULL) {
  # mysql_list_tables/mysql_query = FALSE on failure
  return mysql_query('SHOW TABLES FROM '.mysql_real_escape_string($database_name), mysql_ensure_link($link_identifier));
 }

 # mysql_num_fields - Get number of fields in result
 # int mysql_num_fields ( resource $result )
 # int mysqli_field_count ( mysqli $link )
 function mysql_num_fields ($result) {

  # mysql_num_fields/mysqli_fetch_fields = FALSE on failure

  # mysql takes a result, where mysqli takes link and takes the most recent query
  # so instead we fetch all the fields and then count that
  $tmp = mysqli_fetch_fields($result);
  if ($tmp === null) {
   return false;
  }
  return count($tmp);
 }

 # mysql_num_rows - Get number of rows in result
 # int mysql_num_rows ( resource $result )
 # int mysqli_num_rows ( mysqli_result $result )
 function mysql_num_rows($result) {
  # mysql_num_rows = FALSE on failure
  # mysqli_num_rows = error return value not defined
  return mysqli_num_rows($result);
 }

 # mysql_pconnect - Open a persistent connection to a MySQL server
 # resource mysql_pconnect ([ string $server = ini_get("mysql.default_host") [, string $username = ini_get("mysql.default_user") [, string $password = ini_get("mysql.default_password") [, int $client_flags = 0 ]]]] )
 # mysqli_connect() with p: host prefix
 function mysql_pconnect($server = MYSQL_DEFAULT_HOST, $username = MYSQL_DEFAULT_USER, $password = MYSQL_DEFAULT_PASSWORD, $client_flags = 0) {
  # mysql_pconnect/mysql_connect = FALSE on error
  return mysql_connect('p:'.$server, $username, $password, true, $client_flags);
 }

 # mysql_ping - Ping a server connection or reconnect if there is no connection
 # bool mysql_ping ([ resource $link_identifier = NULL ] )
 # bool mysqli_ping ( mysqli $link )
 function mysql_ping($link_identifier = NULL) {
  # mysql_ping/mysqli_ping = FALSE on error
  $temp = mysqli_ping(mysql_ensure_link($link_identifier));
  if ($temp === NULL) {
   return false;
  }
  return $temp;
 }

 # mysql_query - Send a MySQL query
 # resource mysql_query ( string $query [, resource $link_identifier = NULL ] )
 # mixed mysqli_query ( mysqli $link , string $query [, int $resultmode = MYSQLI_STORE_RESULT ] )
 function mysql_query ($query, $link_identifier = NULL) {
  # mysql_query/mysqli_query = FALSE on error
  return mysqli_query(mysql_ensure_link($link_identifier), $query);
 }

 # mysql_real_escape_string - Escapes special characters in a string for use in an SQL statement
 # string mysql_real_escape_string ( string $unescaped_string [, resource $link_identifier = NULL ] )
 # string mysqli_real_escape_string ( mysqli $link , string $escapestr )
 function mysql_real_escape_string($unescaped_string, $link_identifier = NULL) {
  # mysql_real_escape_string = FALSE on error
  # mysqli_real_escape_string = error return value not defined
  return mysqli_real_escape_string(mysql_ensure_link($link_identifier), $unescaped_string);
 }

 # mysql_result - Get result data
 # string mysql_result ( resource $result , int $row [, mixed $field = 0 ] )
 # no equivalent function exists in mysqli - mysqli_data_seek() in conjunction with mysqli_field_seek() and mysqli_fetch_field()
 function mysql_result($result , $row , $field = 0) {
  # mysql_result = FALSE on failure
  # try to seek position, returns false on failure
  if (mysqli_data_seek($result, $row) === false) return false;
  $row = mysqli_fetch_array($result);
  if ($row === NULL || !isset($row[$field])) return false;
  return $row[$field];
 }


 # mysql_select_db - Select a MySQL database
 # bool mysql_select_db ( string $database_name [, resource $link_identifier = NULL ] )
 function mysql_select_db ($database_name, $link_identifier = NULL) {
  # mysql_select_db/mysqli_select_db = FALSE on failure
  return mysqli_select_db(mysql_ensure_link($link_identifier), $database_name);
 }

 # mysql_set_charset - Sets the client character set
 # bool mysql_set_charset ( string $charset [, resource $link_identifier = NULL ] )
 # bool mysqli_set_charset ( mysqli $link , string $charset )
 function mysql_set_charset($charset, $link_identifier = NULL) {
  # mysql_set_charset/mysqli_set_charset = FALSE on failure
  return mysqli_set_charset(mysql_ensure_link($link_identifier), $charset);
 }

 # mysql_stat - Get current system status
 # string mysql_stat ([ resource $link_identifier = NULL ] )
 # string mysqli_stat ( mysqli $link )
 function mysql_stat($link_identifier = NULL) {
  # mysql_stat = NULL on error
  # mysqli_stat = FALSE on error
  $temp = mysqli_stat(mysql_ensure_link($link_identifier));
  if ($temp === FALSE) {
   return NULL;
  }
  return $temp;
 }

 # mysql_tablename - Get table name of field
 # string mysql_tablename ( resource $result , int $i )
 # no mysqli equivalent exists - SHOW TABLES [FROM db_name] [LIKE 'pattern']
 function mysql_tablename ($result, $i) {
 # return mysql_query('SHOW COLUMNS FROM "'.mysql_real_escape_string($database_name).'.'.mysql_real_escape_string($table_name).'"', mysql_ensure_link($link_identifier));
  return mysql_result($result, $i);
 }

 # mysql_thread_id - Return the current thread ID
 # int mysql_thread_id ([ resource $link_identifier = NULL ] )
 # int mysqli_thread_id ( mysqli $link )
 function mysql_thread_id($link_identifier = NULL) {
  # mysql_thread_id = FALSE on failure
  # mysqli_thread_id = no error return value defined
  $temp = mysqli_thread_id(mysql_ensure_link($link_identifier));
  if ($temp === NULL) {
   return false;
  }
  return $temp;
 }
}

Save Lalu jangan lupa untuk include ke file php kalian.
mungkin untuk sekedar saran saja includenya ke file config database karena untuk include hanya 1x, semoga bermanfaat yah untuk para master, terima kasih :)

Halo master udah kenal kan sama Framework yang ini ?
Ya sebelumnya udah pernah dikenalin kan di sini. kalo udah kenalan ya jangan PHP dong kita pelajari hehehe.

Apa aja yang disiapkan untuk memulai ?
 -Siapin alat perang nya dulu (Text editor). [Post sebelumnya]
 -XAMPP sudah terinstall dan running. [Post sebelumnya]
 -Secangkir Kopi hangat dan sebatang Rokok (Not recommended)
 -Keinginan untuk belajar, dan niat.

Sebelumnya kita download dulu file master nya si Codeigniter ini sebenernya ada banyak cara menuju roma, tapi disini pake cara termudah aja ya, hasilnya bakalan sama ko.

Download dulu file Codeigniter 3.x di website resminya atau langsung disini.

kalo sudah jangan lupa di extract ke htdocs :

C:\XAMPP\htdocs

nanti kalo udah pasti jadi gini :

C:\XAMPP\htdocs\CodeIgniter-3.x.x

*seri codeigniter.
Nanti rename aja foldernya jadi ci.master-php, dan bakalan seperti ini :

C:\XAMPP\htdocs\ci.master-php

Gmn udah deg degan belum? masih mau lanjut kan?
Hayu atuh kita mulai aja buka browser kecintaan para Master dan nanti masukin ulr nya
localhost/ci.master-php
dan.....taraaaa akan nampil seperti ini :


Nah yaudah, sekarang tinggal nunggu tutorial selanjutnya :)

Halo para Master.... kalo ngoding biasanya pake aplikasi apa? notepad++? sublime text? dll.. saking banyaknya admin gatau harus nulis apa hehehe. Kali ini admin mau sedikit share temen plus sahabat ngoding yang ga pernah berkhianat yaitu Atom? loh.. ko Atom? iya Atom.. web resminya bisa Master lihat di link ini Atom.io.



Kenapa harus Atom? kalo admin rasa Atom ini ga pernah muluk muluk terutama dari harga yang penting free alias gratis hehehe.. padahal packages nya lumayan banyak serta penginstallanya kebilang mudah juga bisa di gunakan di Operaning System Ubuntu & Windows, pasti para Master penasaran kan?..

Kalo para master mau coba ngoding menggunakan Atom bisa download link dibawah :

OS	Download Link
Windows	Download
Ubuntu	Mohon maaf link belum tersedia.

Jangan lupa komen yang udah ngerasain hebatnya Atom, terima kasih.

Membuat web memang tidak mudah. Ada banyak source yang terkait didalamnya,  PHP mungkin menjadi salah satunya. Bahasa pemrograman ini memang dirancang untuk para pengembang web agar dapat menciptakan suatu halaman web yang bersifat dinamis. Sekilas tentang PHP, PHP pertama kali dibuat oleh Rasmus Lerdorf pada tahun 1995 dan terus dikembangkan hingga saat ini. Ada banyak sekali web termasuk CMS yang dibuat menggunakan bahasa PHP seperti WordPress dll.
Itu sekilas tentang PHP. Namun apa itu PHP Framework ?

Bisa dilihat dari namanya. Framework dapat diartikan sebagai sebuah kerangka kerja. Kerangka kerja dimana dapat memudahkan pekerjaan kita. Jika dikaitkan dengan PHP maka dapat diartikan sebagai suatu kerangka kerja yang telah terpola dan memudahkan pengembang web dalam pembuatan web yang menggunakan script PHP. Mempermudah yang dimaksud misalnya, Dalam membuat sebuah aplikasi web kita sering menulis script PHP secara keseluruhan (konvensional) dan itu pun kita ulang pada halaman yang lain. Bukankah itu begitu tidak efesien disamping berat ketika diload ? Dengan PHP Framework semua bisa teratasi. Semuanya sudah diatur menjadi pola-pola tertentu yang disebut dengan class. Pola/class inilah yang meringankan kita dalam penulisan script dan load halaman web.
PHP Framework berbeda jika dibandingkan dengan CMS (Content Management System), meski sama-sama meringankan dalam pembuatan web. Jika menggunakan CMS, kita tidak perlu pusing menulis script. Semuanya telah dibuat menjadi Fix dan kita hanya perlu mengatur bagian content dan interfacenya saja. Tidak demikian dengan Framework. Membangun sebuah aplikasi web dengan menggunakan framework, kita tetap harus menuliskan kode perintah PHP sesuai dengan ruang lingkungan yang disediakan oleh framework.
PHP Framework menggunakan metode pengembangan berbasis MVC. Namun apa itu MVC ? MVC merupakan suatu metode untuk memisahkan bagian-bagian dari suatu web aplikasi. MVC adalah kependekan dari Model View Controller. MVC terdiri dari tiga bagian yaitu;

1. Model : Model mewakili struktur data. Biasanya model berisi fungsi-fungsi yang membantu kita dalam pengelolaan database seperti memasukkan data ke database, update data dan lain-lain.
2. View : View adalah bagian yang mengatur tampilan ke user. Bisa di katakan berupa halaman web.
3. Controller : Controller merupakan bagian yang menjembatani model dan view. Controller berisi script-script php yang berfungsi untuk memproses suatu data dan mengirimkannya ke halaman web.

Disinilah letak perbedaan utama antara framework dengan CMS atau PHP konvensional. Dengan metode MVC, bagian tampilan, logika serta query database diletakkan secara terpisah namun tetap sinkron sehingga pembuatan aplikasi menjadi lebih terstruktur dan sederhana. Model digunakan dalam menuliskan script database, Controller untuk mengembangkan logika pemrogramannya, sedangkan View berfungsi dalam menampilkan layout dari aplikasi yang kita buat. Kelebihan framework antara lain sebagai berikut :

1. Ringan dan cepat. Framework hanya melakukan pemanggilan pustaka/kelas yang dibutuhkan sehingga meminimalkan resource yang diperlukan sehingga ketika kita me-load sebuah halaman akan menjadi ringan dan cepat.
2. Menggunakan metode MVC. Seperti yang telah dijelaskan sebelumnya, dengan metode MVC akan mempermudah kita dalam memahami alur pemrograman karena untuk bagian tampilan, logika dan query database telah dipecah sedemikian rupa.
3. Mayortitas mendukung berbagai jenis database.

Berikut beberapa contoh PHP Framework beserta kelebihan yang dibawanya :
CodeIgniter

• Mudah digunakan dan tidak memerlukan konfigurasi yang rumit
• Fungsi-fungsi pendukung yang cukup lengkap
• Mendkung PHP4 dan PHP5
• Mungkin merupakan Framework MVC paling populer dan paling banyak digunakan
• Dokumentasi yang sangat bagus, friendly dan didukung oleh forum, wiki, dan komunitas yang besar

• Tidak mendukung AJAX, dan ORM
• Meyediakan dan memisahan file-file dalam MVC pattern, tapi masih memberikan kebebasan user untuk melanggar aturan MVC

• Dukungan terhadap AJAX, ORM
• Automagic function seperti validasi input, dll, yang mempercepat coding
• Support PHP4 dan PHP5
• Lebih mencerminkan MVC yang sesungguhnya dibandingkan CI
• Komunitas pengguna yang besar dan forum cukup baik

• Manual yang ada tidak selengkap CI.
• Butuh waktu belajar yang lebih lama untuk menguasai framework ini dibanding CI. Tapi jika sudah benar-benar mengerti, banyak kelebihan dibanding CI. Beberapa situs menyarankan anda untuk belajar dan terbiasa dulu
  dengan CodeIgniter baru kemudian mempelajari CakePHP.
• (http://www.zenperfect.com/2007/07/15/faceoff-codeigniter-vs-cakephp/)

• Dukungan terhadap AJAX, ORM.
• Kompatibel dengan berbagai macam database.
• Banyak library dan fungsi symfony yang sudah tersedia. Bahkan hampir mendekati CMS. Sehingga ada yang mengatakan ”Symphony is a CMS with a heart of a framework.” ini menjadi kelebihan sekaligus kekurangan.

• Tidak mendukung PHP4.
• Relatif butuh waktu lama untuk mengerti framework ini.
• Instalasi dan konfigurasinya cukup rumit.

• Dukungan terhadap AJAX, ORM.
• Berdasarkan informasi dari situs resminya, disebutkan bahwa fokus dari Zend Framework ini adalah untuk membangun aplikasi berbasis Web dan untuk memudahkan dalam mengakses API dari berbagai vendor seperti Google, Amazon, Yahoo!, dan Flickr.

• Tidak mendukung PHP4.
• Manual yang ada kurang mengakomodasi kebutuhan.
• Performanya relatif lambat (mungkin karena banyaknya library).
• Konon katanya Framework ini hanya cocok untuk orang dengan skill PHP yang sudah sangat tinggi.

• Dukungan terhadap PHP4, PHP5, AJAX, ORM (cukup lengkap dan cukup mengakomodasi semua kebutuhan yang umum dari aplikasi php)

• Kurang adanya dukungan komunitas. Mungkin karena masih relatif baru
• Beberapa forum mengatakan bahwa framewok ini cukup banyak memakan memory

Ingin mengetahui lebih lengkap ? Silahkan lihat disini

Halo para Master kita coba buat program pertama yuu...

Senjata yang harus disiapkan :

• Notepad++
• Web Browser

Sebelumnya para Master harus aktifin dulu XAMPP nya supaya MySQL buat ngejalanan PHP nya, kalo para master bingung gatau cara aktifin XAMPP nya gimana, bisa liat dulu postingan sebelumnya di Cara installasi XAMPP di Windows. Kalo sudah para master siapkan senjata pertama yaitu Notepad++ tapi kalo belum punya bisa Master download secara gratis di Download Notepad++ Terbaru. 


Jika senjata sudah siap maka kita akan eksekusi!! 
pertama buat sebuah Folder di dalam 

C:\XAMPP\htdocs

 Buat folder dengan nama master-php jadi struktur Folder para Master menjadi 

C:\XAMPP\htdocs\master-php

C adalah tempat default instalan XAMPP.

 Lalu buka notepad++ dan ketik kode dibawa ini :

<?php
   echo "Hello World"
?>

Kalo sudah tinggal save ke dalam folder master-php yang sebelumnya sudah disiapkan dengan nama helloworld.php harus berekstensi .php save as type nya ubah yah Master jangan lupa, jadi seperti ini :

Save as Hello World

Taadaa!!.. program pertama Master sudah siap kita lihat di browser kecintaan para Master dan tulis

localhost/master-php/helloworld.php

Jika merasa kesulitan silahkan komentar di bawah ini, Terima kasih.