- Beranda
- Komunitas
- Tech
- Website, Webmaster, Webdeveloper
Neeed Heeeelpp gaaan !!
TS
asepsetiawan050
Neeed Heeeelpp gaaan !!
[B]Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /opt/lampp/htdocs/Aplikasi/03-view.php on line 68[/B]
itu ane nerusin kerjaan orang gaan jadi ga ada databasenya ane bikin lagi dah tuh ane perhatiin sedikit demi sedikit script dan akhirnya jadilah seperti itu
itu kenapa ya gan ?
nih ane kasih liat scriptnya..
<?php
session_start();
if(!isset($_SESSION['user_id'])) {
header("Location: index.php");
}
?>
<?php
$flagQ=0;
$total=0;
$sumtotal=0;
$conn =mysql_connect("localhost","root","");
$db = mysql_select_db("dbcmsportal",$conn);
$co_id=$_SESSION['co_id'];
if($co_id == 0) {
$flagQ +=1;
$sql = "SELECT code,tittle,sum(price*number_dl) price,sum(number_dl) number_dl FROM `tblcmsportal` Group BY code,tittle ORDER BY `tblcmsportal`.`code` ASC ";
$hasil = mysql_query($sql,$conn);
//echo 'sql1'.$sql;
}else if($co_id>0){
$flagQ +=1;
$sql = "SELECT code,tittle,sum(price*number_dl) price,sum(number_dl) number_dl FROM `tblcmsportal` where co_id='$co_id' Group BY code,tittle ORDER BY `tblcmsportal`.`code` ASC ";
$hasil = mysql_query($sql,$conn);
//echo 'sql2';
}
?>
<div id="container">
<div id="header">
<h1>MENU UTAMA</h1>
</div>
<div id="menu">
<a href="00-home.php">Home</a>
<a href="01-upload.php">Upload</a>
<a href="03-view.php" class="active">View</a>
<a href="#">Report</a>
</div>
<link rel="stylesheet" type="text/css" href="css/style2.css">
<link rel="stylesheet" type="text/css" href="css/tcal.css" />
[removed][removed]
<form method="post" action="03-search.php">
<div>Code Product : <input type="text" name="code"> Date From: <input type="text" name="date1" class="tcal" value="" /> To : <input type="text" name="date2" class="tcal" value="" />
<input type="SUBMIT" name="SUBMIT" id="SUBMIT" value="search" ><br><br>
</div>
</form>
<link rel="stylesheet" type="text/css" href="css/button.css" />
<a class="cms" href="03-download.php"> Download CMS</a>
<h1 align="center" >Data CMS</h1>
<br>
<span><span style="font-style: italic;"><span style="font-style: italic;"><div style="height: 590px; width: 1200px; font: 20px/35px Georgia,Garamond,Serif; overflow: scroll;">
<center><table width="1180" border="3" cellspacing="0" cellpadding="0"><center>
<tr height="50" bgcolor="grey">
<th width="300"><font>Code Product</td>
<th width="300">Tittle Product</td>
<th width="150">Image</td>
<th width="50">Price</td>
<th width="150">Number Download</td>
</tr>
<?php
if($flagQ>0) {
while ($data = mysql_fetch_row($hasil)){
?>
<?php
$rupiah=number_format($data[2],0,'','.');
//$format1 = date('d F Y', strtotime($data[7]));
$sumtotal+=$data[2];
$total+= $data[3];
?>
<tr>
<td><p style="text-align:center;"><?php echo '<a href="#" style="text-decoration:none">' . $data[0]; echo'</a>';?></td>
<td><p style="text-align:center;"><?php echo '<a href="#" style="text-decoration:none">' . $data[1]; echo'</a>';?></td>
<td width="200" height="150"></td>
<td><p style="text-align:right;"><?php echo $rupiah;?></p></td>
<td><p style="text-align:center;"><?php echo $data[3];?></p></td>
</tr>
<?php } } ?>
<tr>
<td colspan="3"></td>
<td height="50"><p style="text-align:right;"><b>Total :
<?php
$totalprice=number_format($sumtotal,0,'','.');
echo $totalprice;
?>
</p></b>
</td>
<td><p style="text-align:center;"><b>Total :
<?php
$jumlah=number_format($total,0,'','.');
echo $jumlah;
?></p></b>
</td>
</tr>
</table>
</div>
</span></span></span>
</div>
minta pencerahannya ya gann..
itu ane nerusin kerjaan orang gaan jadi ga ada databasenya ane bikin lagi dah tuh ane perhatiin sedikit demi sedikit script dan akhirnya jadilah seperti itu
itu kenapa ya gan ?
nih ane kasih liat scriptnya..
<?php
session_start();
if(!isset($_SESSION['user_id'])) {
header("Location: index.php");
}
?>
<?php
$flagQ=0;
$total=0;
$sumtotal=0;
$conn =mysql_connect("localhost","root","");
$db = mysql_select_db("dbcmsportal",$conn);
$co_id=$_SESSION['co_id'];
if($co_id == 0) {
$flagQ +=1;
$sql = "SELECT code,tittle,sum(price*number_dl) price,sum(number_dl) number_dl FROM `tblcmsportal` Group BY code,tittle ORDER BY `tblcmsportal`.`code` ASC ";
$hasil = mysql_query($sql,$conn);
//echo 'sql1'.$sql;
}else if($co_id>0){
$flagQ +=1;
$sql = "SELECT code,tittle,sum(price*number_dl) price,sum(number_dl) number_dl FROM `tblcmsportal` where co_id='$co_id' Group BY code,tittle ORDER BY `tblcmsportal`.`code` ASC ";
$hasil = mysql_query($sql,$conn);
//echo 'sql2';
}
?>
<div id="container">
<div id="header">
<h1>MENU UTAMA</h1>
</div>
<div id="menu">
<a href="00-home.php">Home</a>
<a href="01-upload.php">Upload</a>
<a href="03-view.php" class="active">View</a>
<a href="#">Report</a>
</div>
<link rel="stylesheet" type="text/css" href="css/style2.css">
<link rel="stylesheet" type="text/css" href="css/tcal.css" />
[removed][removed]
<form method="post" action="03-search.php">
<div>Code Product : <input type="text" name="code"> Date From: <input type="text" name="date1" class="tcal" value="" /> To : <input type="text" name="date2" class="tcal" value="" />
<input type="SUBMIT" name="SUBMIT" id="SUBMIT" value="search" ><br><br>
</div>
</form>
<link rel="stylesheet" type="text/css" href="css/button.css" />
<a class="cms" href="03-download.php"> Download CMS</a>
<h1 align="center" >Data CMS</h1>
<br>
<span><span style="font-style: italic;"><span style="font-style: italic;"><div style="height: 590px; width: 1200px; font: 20px/35px Georgia,Garamond,Serif; overflow: scroll;">
<center><table width="1180" border="3" cellspacing="0" cellpadding="0"><center>
<tr height="50" bgcolor="grey">
<th width="300"><font>Code Product</td>
<th width="300">Tittle Product</td>
<th width="150">Image</td>
<th width="50">Price</td>
<th width="150">Number Download</td>
</tr>
<?php
if($flagQ>0) {
while ($data = mysql_fetch_row($hasil)){
?>
<?php
$rupiah=number_format($data[2],0,'','.');
//$format1 = date('d F Y', strtotime($data[7]));
$sumtotal+=$data[2];
$total+= $data[3];
?>
<tr>
<td><p style="text-align:center;"><?php echo '<a href="#" style="text-decoration:none">' . $data[0]; echo'</a>';?></td>
<td><p style="text-align:center;"><?php echo '<a href="#" style="text-decoration:none">' . $data[1]; echo'</a>';?></td>
<td width="200" height="150"></td>
<td><p style="text-align:right;"><?php echo $rupiah;?></p></td>
<td><p style="text-align:center;"><?php echo $data[3];?></p></td>
</tr>
<?php } } ?>
<tr>
<td colspan="3"></td>
<td height="50"><p style="text-align:right;"><b>Total :
<?php
$totalprice=number_format($sumtotal,0,'','.');
echo $totalprice;
?>
</p></b>
</td>
<td><p style="text-align:center;"><b>Total :
<?php
$jumlah=number_format($total,0,'','.');
echo $jumlah;
?></p></b>
</td>
</tr>
</table>
</div>
</span></span></span>
</div>
minta pencerahannya ya gann..
Diubah oleh asepsetiawan050 14-10-2014 14:29
0
1.2K
1
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Urutan
Terbaru
Terlama
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Komunitas Pilihan