FANDOM


// coba koneksi ke MySQL database

$conn = mysql_connect("localhost", "username", "password");


// jika koneksi gagal, display error dan exit program

if(!$conn) {
  die('Could not connect: '.mysql_error());
}


// pilih database yang akan digunakan

mysql_select_db("databaseku");


// query database

$result = mysql_query("sql statement");
// cek keberhasilan query 

if(!$result)
  die('Query gagal: '.mysql_error());


// cek berapa banyak record yang dikembalikan oleh SELECT statement

$num = mysql_num_rows($result);
if($num == 0) echo 'No record';


// cek berapa banyak record yg diupdate oleh INSERT, UPDATE, REPLACE, DELETE
$num = mysql_affected_rows($result);


// get records

while ($row = mysql_fetch_assoc($result)) {
  echo $row["column1"];
  echo $row["column2"];
}


// free result sets -- ngga perlu juga kecuali memang maunya sendiri
mysql_free_result($result);
// setelah selesai menggunakan database sebaiknya tutup koneksinya

// Note: tidak perlu karena resource akan di bebaskan secara otomatis
mysql_close($conn);


mysql_affected_rows Get number of affected rows in previous MySQL operation
mysql_client_encoding Returns the name of the character set
mysql_close Close MySQL connection
mysql_connect Open a connection to a MySQL Server
mysql_create_db Create a MySQL database
mysql_data_seek Move internal result pointer
mysql_db_name Get result data
mysql_db_query Send a MySQL query
mysql_drop_db Drop (delete) a MySQL database
mysql_errno Returns the numerical value of the error message from previous MySQL operation
mysql_error Returns the text of the error message from previous MySQL operation
mysql_escape_string Escapes a string for use in a mysql_query
mysql_fetch_array Fetch a result row as an associative array, a numeric array, or both
mysql_fetch_assoc Fetch a result row as an associative array
mysql_fetch_field Get column information from a result and return as an object
mysql_fetch_lengths Get the length of each output in a result
mysql_fetch_object Fetch a result row as an object
mysql_fetch_row Get a result row as an enumerated array
mysql_field_flags Get the flags associated with the specified field in a result
mysql_field_len Returns the length of the specified field
mysql_field_name Get the name of the specified field in a result
mysql_field_seek Set result pointer to a specified field offset
mysql_field_table Get name of the table the specified field is in
mysql_field_type Get the type of the specified field in a result
mysql_free_result Free result memory
mysql_get_client_info Get MySQL client info
mysql_get_host_info Get MySQL host info
mysql_get_proto_info Get MySQL protocol info
mysql_get_server_info Get MySQL server info
mysql_info Get information about the most recent query
mysql_insert_id Get the ID generated in the last query
mysql_list_dbs List databases available on a MySQL server
mysql_list_fields List MySQL table fields
mysql_list_processes List MySQL processes
mysql_list_tables List tables in a MySQL database
mysql_num_fields Get number of fields in result
mysql_num_rows Get number of rows in result
mysql_pconnect Open a persistent connection to a MySQL server
mysql_ping Ping a server connection or reconnect if there is no connection
mysql_query Send a MySQL query
mysql_real_escape_string Escapes special characters in a string for use in an SQL statement
mysql_result Get result data
mysql_select_db Select a MySQL database
mysql_set_charset Sets the client character set
mysql_stat Get current system status
mysql_tablename Get table name of field
mysql_thread_id Return the current thread ID
mysql_unbuffered_query Send an SQL query to MySQL without fetching and buffering the result rows.

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.