Postingan lainnya
kenapa data tidak masuk ke database
Assalamualaikum teman teman sekolah koding, saya ada problem input database, kenapa ketika saya sudah inputkan datanya tetapi data tersebut tidak masuk ke database? mohon bantuannya
register.php
<div id="container-user-akses">
<form action="<?php BASE_URL."proses_register.php";?>" method="POST">
<div class="element-form">
<label>Nama Lengkap</label>
<span><input type="text" name="nama_lengkap"/></span>
</div>
<div class="element-form">
<label>Email</label>
<span><input type="text" name="email"/></span>
</div>
<div class="element-form">
<label>Nomor Telepon</label>
<span><input type="text" name="phone"/></span>
</div>
<div class="element-form">
<label>Alamat</label>
<span><textarea name="alamat"></textarea></span>
</div>
<div class="element-form">
<label>password</label>
<span><input type="password" name="password"/></span>
</div>
<div class="element-form">
<label>Re-type Password</label>
<span><input type="password" name="re_password"/></span>
</div>
<div class="element-form">
<span><input type="submit" value="register"/></span>
</div>
</div>
koneksi.php
<?php
$server = "localhost";
$username = "root";
$password = "";
$database = "weshop";
$koneksi = mysqli_connect ($server, $username, $password, $database) or die ("koneksi ke database gagal");
proses_register.php
<?php
include_once("function/koneksi.php");
include_once("function/helper.php");
$level = "customer";
$status = "on";
$nama_lengkap = $_POST['nama_lengkap'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$alamat = $_POST['alamat'];
$password = md5($_POST['password']);
$re_password = $_POST['re_password'];
mysqli_query ($koneksi, "INSERT INTO user (level, nama, email, alamat, phone, password, status)
VALUES ('$level','$nama_lengkap','$email','$alamat','$phone','$password','$status')");
?>
10 Jawaban:
pesan errornya gk ada mas cuman data yg saya input tidak masuk ke database MySQL
coba ini kasih setelah mysqli_query
echo "INSERT INTO user (level, nama, email, alamat, phone, password, status)
VALUES ('$level','$nama_lengkap','$email','$alamat','$phone','$password','$status')";
jadinya kayak gini kan?
<?php
include_once("function/koneksi.php");
include_once("function/helper.php");
$level = "customer";
$status = "on";
$nama_lengkap = $_POST['nama_lengkap'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$alamat = $_POST['alamat'];
$password = $_POST['password'];
$re_password = $_POST['re_password'];
mysqli_query ($koneksi, "INSERT INTO user (level, nama, email, alamat, phone, password, status)
VALUES ('$level','$nama_lengkap','$email','$alamat','$phone','$password','$status')");
echo "INSERT INTO user (level, nama, email, alamat, phone, password, status)
VALUES ('$level','$nama_lengkap','$email','$alamat','$phone','$password','$status')";
udah saya coba gk bisa mas datanya tetap gk masuk ke database. makasih
Coba cek fieldnya berurutan gak?Soalnya kalo input data harus berurutan sesuai fieldnya. Coba juga mysqli_querynya masukin ke variabel atau ke if statement
base_url itu setau saya fungsi jadinya gini mas base_url()
#nubi #CMIIW
Jawaban Terpilih
Coba base_url diganti BASE_URL(). buat functionnya
function BASE_URL(){
if(isset($_SERVER['HTTPS'])){
$protocol = ($_SERVER['HTTPS'] && $_SERVER['HTTPS'] != "off") ? "https" : "http";
}
else{
$protocol = 'http';
}
return $protocol . "://" . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'];
}
pahamkan gan
makasih @farhansyam salahnya di base_url kurang echo
iya mas @lionkip salah di base url oke saya coba
<form action="<?php echo BASE_URL."proses_register.php";?>"
thank you semuanya
@Mind oke saya kira pake framework :v mantap semangat ! sama sama belajar