Postingan lainnya
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? saya sudah koreksi semua dari mulai koneksi, form inputan dan proses input database nya pun sudah saya kroscek tetapi tetap saja tidak masuk ke database. ada yang bisa bantu? ini scriptnya :
ini script form inputan nya :
<?php
include "koneksi.php";
$data=mysql_query("SELECT * FROM news");
$r=mysql_fetch_array($data);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Admin</title>
</head>
<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" integrity="sha384-1q8mTJOASx8j1Au+a5WDVnPi2lkFfwwEAa8hDDdjZlpLegxhjVME1fgjWPGmkzs7" crossorigin="anonymous">
<!-- Optional theme -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap-theme.min.css" integrity="sha384-fLW2N01lMqjakBkx3l/M9EahuwpSfeNvV63J5ezn3uZzapT0u7EYsXMjQV+0En5r" crossorigin="anonymous">
<!-- Latest compiled and minified JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js" integrity="sha384-0mSbJDEHialfmuBBQP6A4Qrprq5OVfW37PRR3j5ELqxss1yVqOtnepnHVP9aJ7xS" crossorigin="anonymous"></script>
<body>
<div class="container">
<div class="row main">
<div class="panel-heading">
<div class="panel-title text-center">
<hr>
</div>
</div>
<div class="main-login main-center">
<form class="form-horizontal" action="proses.php" method="post">
<div class="form-group">
<label for="judul" class="cols-sm-2 control-label">Judul</label>
<div class="cols-sm-10">
<div class="input-group">
<span class="input-group-addon"><i class="glyphicon glyphicon-user" aria-hidden="true"></i></span>
<input type="text" class="form-control" name="judul" id="judul" value="<?php echo $r['judul'];?>">
</div>
</div>
</div>
<div class="form-group">
<label for="isi_berita" class="cols-sm-2 control-label">Isi Berita</label>
<div class="cols-sm-10">
<div class="form-group">
<textarea class="form-control" name="isi_berita" rows="10" id="isi_berita" value="<?php echo $r['isi_berita'];?>"></textarea>
</div>
</div>
</div>
</div>
<div class="form-group ">
<button type="submit" name="submit" value="Simpan" class="btn btn-primary btn-lg btn-block login-button">Input</button>
</div>
</form>
</div>
</div>
</div>
</body>
</html>
script koneksi :
<?php
$koneksi=mysql_connect("localhost","root","");
mysql_select_db("berita");
?>
script proses penyimpanan ke database :
<?php
include 'koneksi.php';
if(isset($_POST['submit'])){
date_default_timezone_set("Asia/jakarta");
$judul=$_POST['judul'];
$isi=$_POST['isi_berita'];
$date= date("Y/m/d");
//Query untuk menyimpan ke database
$sql=mysql_query("INSERT INTO news VALUES
('', '$judul','$isi','$date')");
if($sql){
echo "<center>DATA BERHASIL DISIMPAN</center><br>";
echo "<a href='index.php'>Kembali</a>";
}else{
echo "<center>DATA TIDAK MASUK</center><br>";
echo "<a href='index.php'>Kembali</a>";
}
}
?>
<a href="../index.php"><button type="submit" class="btn btn-default">lihat berita</button></a>
7 Jawaban:
kemungkinan kesalahan nya disini gan.. coba penulisan nya kaya gini...
<?php
$koneksi=mysql_connect("localhost","root","","nama database agan belom dimasukin disini");
?>
coba ganti jangan pakai mysql, pakai mysqli aja
^ coba koneksinya pakai kayak gini mas
<?php
$host = 'localhost';
$user = 'root';
$password = '';
$db = 'namadatabase';
$connection = mysqli_connect( $host, $user, $password, $db ) or die( mysqli_error() );
?>
kalau pake mysqi malah eror om, soalnya setau saya kalau mysqli itu OOP kan?
muncul pesan eror nya seperti ini om : Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\coba\frontend\test\admin\input.php on line 4
itu phpnya versi berapa gan? coba pake php 7