Dipost pada tanggal 31 March 2016
Dear Pak Fransen. saya sudah mengikuti step by step video anda. tapi ada beberapa kendala.
1. ada proses insert selalu error.
2. Localhost dengan hosting kenyataannya tidak sama. gambar di hosting tidak muncul pada klik produk samping kiri.
mohon pencerahannya
submit regis.php
<?php
include "../config/config.php";
include "../classes/database.php";
$customer_name = $_POST["customer_name"];
$customer_email = $_POST["customer_email"];
$phone_no = $_POST["phone_no"];
$gender = $_POST["gender"];
$customer_address = $_POST["customer_address"];
$post_code = $_POST["post_code"];
$country = $_POST["country"];
$province =$_POST["province"];
$city = $_POST["city"];
$username = $_POST["username"];
$password = md5($_POST["password"]);
$term = $_POST['term'];
$db=new database(true);
//dATA PADA TABLE MS_CUSTOMER, field dan field value
$data=array("customer_name"=>"'" . $customer_name . "'",
"customer_email"=>"'" . $customer_email . "'",
"phone_no"=>"'" . $phone_no . "'",
"gender"=>"'" . $gender . "'",
"customer_address"=>"'" . $customer_address . "'",
"post_code"=>"'" . $post_code . "'",
"country"=>"'" . $country . "'",
"province"=>"'" . $province . "'",
"city"=>"'" . $city . "'",
"username"=>"'" . $username . "'",
"password"=>"'" . $password . "'",
"create_date"=>"now()");
$result=$db->db_insert("ms_customer",$data);
//apakah proses insert berhasil?
if($result)
{
header("location:../index.php?regis_success");
}
else
{
header("location:../index.php?regis_error");
}
?>
dan database.php
<?
class database
{
private $db_connection;
private $db_selection;
function __construct($root=false) {
//untuk menambahkan karakter ../
$root_dot="";
//cek variable $root=true
if($root==true)
{
//jika ya variable $root_dot =../
$root_dot="../";
}
else
//jika tidak variable $root_dot =''
{
$root_dot="";
}
//function yang akan dijalankan inisialisasi memory
include($root_dot . "config/database_config.php");
$this->db_connection=mysql_connect($db_server,$db_user,$db_password);
$this->db_selection=mysql_select_db($db_selected,$this->db_connection);
}
function db_queryresult($sql="")
{
$result=array();
if($sql!="")
{
$query=mysql_query($sql,$this->db_connection);
$rows=mysql_fetch_array($query);
if(!empty($rows))
{
do
{
$result[]=$rows;
}while($rows=mysql_fetch_array($query));
}
}
return $result;
}
function db_getonerow($sql=""){
$result=NULL;
if($sql !="")
{
$query=mysql_query($sql,$this->db_connection);
$result=mysql_fetch_array($query);
}
return $result;
}
function db_insert($table="",$fielddata=NULL)
{
//variable untuk hasil output
$result=0;
//variable untuk field
$fields="";
//variable untuk field value
$fieldsvalue="";
//Check $table & $ fielddata ada isinya?
if($table!="" && $fielddata!=NULL)
{
//looping untuk memasukan data field & field value
foreach($fielddata as $rows=>$rowsvalue)
{
$fields=$fields . $rows . ",";
$fieldsvalue=$fieldsvalue . $rowsvalue . ",";
}
//buang koma terakhir
$fields=substr($fields,0,strlen($fields)-1);
$fieldsvalue=substr($fieldsvalue,0,strlen($fieldsvalue)-1);
//Buat sintaks sql
$sql="insert into" . $table . "(" . $fields . ") "
. "values(" . $fieldsvalue . ")";
// Execute syntax sql
$result=mysql_query($sql,$this->db_connection);
}
return $result;
}
}
?>
|