php දන්නා කෙනෙක් හෙල්ප් එකක් දෙන්න,,,,
මචන්ලා මෙන්න මේ ERROR එක එනවනේ....
about widget corp
( ! ) Warning: mysqli_error() expects exactly 1 parameter, 0 given in C:\wamp64\www\widget_corp\includes\functions.php on line 7
Call Stack
# Time Memory Function Location
1 0.0003 238864 {main}( ) ...\content.php:0
2 0.0035 259416 get_pages_for_subjects( ) ...\content.php:20
3 0.0037 259816 confirm_query( ) ...\functions.php:30
4 0.0037 259864 mysqli_error ( ) ...\functions.php:7
Database query failed :
CONTENT.PHP
DB_CONNECTION.PHP
FUNCTIONS.PHP
දන්නා කෙනෙක් හෙල්ප් එකක් දෙන්නකෝ..ලොකු උදව්වක්>>>>>>>
මචන්ලා මෙන්න මේ ERROR එක එනවනේ....
about widget corp
( ! ) Warning: mysqli_error() expects exactly 1 parameter, 0 given in C:\wamp64\www\widget_corp\includes\functions.php on line 7
Call Stack
# Time Memory Function Location
1 0.0003 238864 {main}( ) ...\content.php:0
2 0.0035 259416 get_pages_for_subjects( ) ...\content.php:20
3 0.0037 259816 confirm_query( ) ...\functions.php:30
4 0.0037 259864 mysqli_error ( ) ...\functions.php:7
Database query failed :
CONTENT.PHP
PHP:
<?php require_once("includes/db_connection.php");?>
<?php require_once("includes/functions.php");?>
<?php include("includes/header.php");?>
<table id="Structure">
<tr>
<td id="navigation">
<ul class="subjects">
<?php
//perform database query
$subject_set=get_all_subjects();
//use returned data from database
while($subject=mysqli_fetch_array($subject_set)){
echo "<li>{$subject["menue_name"]}</li>" ;
//perform database query
$page_set=get_pages_for_subjects($subject["id"]);
echo "<ul class=\"pages\">";
//use returned data from database
while($page=mysqli_fetch_array($page_set)){
echo "<li>{$page["menue_name"]}</li>" ;
}
echo "</ul>";
}
?>
</ul>
</td>
<td id="page">
<h2>Content Area</h2>
</td>
</tr>
</table>
</div>
<?php
require("includes/footer.php");
?>DB_CONNECTION.PHP
PHP:
<?php
//reffer to constatn files in the same includes direcory
require("constants.php");
//create a database connection
$connection=mysqli_connect(DB_SERVER,DB_USER,DB_PASS);
if(!$connection){
die("Database connection failed : " . mysqli_error());
}
//select a database to use
$db=mysqli_select_db($connection,DB_NAME);
if(!$db){
die("Database Selection Error : " . mysqli_error());
}
?>FUNCTIONS.PHP
PHP:
<?php
// This file includes all basic functions for the pages
/*confirm the query errors*/
function confirm_query($result_set){
if (!$result_set){
die("Database query failed : " . mysqli_error());
}
}
/*return the subject from the database*/
function get_all_subjects(){
global $connection;
$query1= "SELECT * FROM subjects ORDER BY position ASC";
$subject_set=mysqli_query($connection , $query1);
confirm_query($subject_set);//reffer functionf.php
return $subject_set;
}
function get_pages_for_subjects($subject_id){
global $connection;
$query2= "SELECT * FROM pages Where subject_id={$subject_id}
ORDER BY ASC";
$page_set=mysqli_query($connection , $query2);
confirm_query($page_set);//reffer functionf.php
return $page_set;
}
?>දන්නා කෙනෙක් හෙල්ප් එකක් දෙන්නකෝ..ලොකු උදව්වක්>>>>>>>
