Help naman po sa Error ko sa Php :(

ScreamAimsFire · Aug 9, 2017

King James Harden Jr said:
base sa warning error atleast 2 parameter

try this later $result=mysqli_query($conn, $search_sql);

pero pede mo ba gawin to? print_r($conn); parang hindi nkaconnect ung include or may error siya. i copy mo ung buong code ng connection.php. from there tignan ntin kung san tlga may error.

Line 32 na lang po yung error

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, string given in C:\xampp\htdocs\learningcrud\fullview.php on line 32

Code:

<?php

	include("connection.php");

	if ($conn->connect_error) {

		die("Connection Failed" . $conn->connect_error);
	}

	$name_id = $_GET['id'];

	echo $name_id;

	$queryString = "SELECT name_id, name_list, section FROM employee WHERE id='$name_id'";

	$result = mysqli_query($conn,$queryString);

	while ($result = mysqli_fetch_array($queryString)){

		print_r($conn);

?>

At eto naman po yung connection.php ko

Code:

<?php

	$host = "localhost";
	$user = "root";
	$password = "";
	$dbname = "crud";

	$conn = new mysqli($host, $user, $password, $dbname);

	if ($conn->connect_error) {
		
		die("Connection Error" . $conn->connect_error);
	}
?>

jskhulitz · Aug 10, 2017

Code:

<?php

	include("connection.php");

	if ($conn->connect_error) {

		die("Connection Failed" . $conn->connect_error);
	}

	$name_id = $_GET['id'];

	echo $name_id;

	[COLOR="#FF0000"]$queryString[/COLOR] = "SELECT name_id, name_list, section FROM employee WHERE id='$name_id'";

	//nandito sa mga next lines ang problema mo. Bakit? yung result ng query execution mo ay nandun sa $result, pero ang nilagay mo sa fetch array procedure mo ay yung $queryString, meaning, nagfefetch ka ng result from a query string lang, which is STRING lang talaga. walang array na ire-return, see corrected code on the next code block
	[COLOR="#FF0000"]$result [/COLOR]= mysqli_query($conn,$queryString);

	while ($result = mysqli_fetch_array([COLOR="#FF0000"]$queryString[/COLOR])){

		print_r($conn);

?>

Code:

<?php

	include("connection.php");

	if ($conn->connect_error) {

		die("Connection Failed" . $conn->connect_error);
	}

	$name_id = $_GET['id'];

	echo $name_id;

[COLOR="#FF0000"]	$queryString = "SELECT name_id, name_list, section FROM employee WHERE id='$name_id'";
	$result = mysqli_query($conn,$queryString);

	while ($rows = mysqli_fetch_array($result)){
		echo '<pre>';
			print_r($rows);
		echo '</pre>';
	}[/COLOR]
?>

ScreamAimsFire · Aug 10, 2017

jskhulitz said:

Code:

<?php

	include("connection.php");

	if ($conn->connect_error) {

		die("Connection Failed" . $conn->connect_error);
	}

	$name_id = $_GET['id'];

	echo $name_id;

	[COLOR="#FF0000"]$queryString[/COLOR] = "SELECT name_id, name_list, section FROM employee WHERE id='$name_id'";

	//nandito sa mga next lines ang problema mo. Bakit? yung result ng query execution mo ay nandun sa $result, pero ang nilagay mo sa fetch array procedure mo ay yung $queryString, meaning, nagfefetch ka ng result from a query string lang, which is STRING lang talaga. walang array na ire-return, see corrected code on the next code block
	[COLOR="#FF0000"]$result [/COLOR]= mysqli_query($conn,$queryString);

	while ($result = mysqli_fetch_array([COLOR="#FF0000"]$queryString[/COLOR])){

		print_r($conn);

?>

Code:

<?php

	include("connection.php");

	if ($conn->connect_error) {

		die("Connection Failed" . $conn->connect_error);
	}

	$name_id = $_GET['id'];

	echo $name_id;

[COLOR="#FF0000"]	$queryString = "SELECT name_id, name_list, section FROM employee WHERE id='$name_id'";
	$result = mysqli_query($conn,$queryString);

	while ($rows = mysqli_fetch_array($result)){
		echo '<pre>';
			print_r($rows);
		echo '</pre>';
	}[/COLOR]
?>

try ko po ngaun sir jskhulitz salamat

- - - Updated - - -

ScreamAimsFire said:
try ko po ngaun sir jskhulitz salamat

sir eto naman po error ko

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\learningcrud\fullview.php on line 31

Code:

<?php

	include("connection.php");

	if ($conn->connect_error) {

		die("Connection Failed" . $conn->connect_error);
	}

	$name_id = $_GET['id'];

	echo $name_id;

	$queryString = "SELECT name_id, name_list, section FROM employee WHERE id='$name_id'";
	$result = mysqli_query($conn,$queryString);

	while ($rows = mysqli_fetch_array($result)){  <------------Line 31
		echo '<pre>';
			print_r($rows);
		echo '</pre>';
	
?>

jskhulitz · Aug 10, 2017

kulang pala yung parameters nung fetch na binigay ko

Code:

// Numeric array
while($rows=[COLOR="#FF0000"]mysqli_fetch_array($result,MYSQLI_NUM)[/COLOR]{
echo row["Lastname"] . ' - ' . $row["Age"] . '<br>';
}

// Associative array
while($rows=[COLOR="#FF0000"]mysqli_fetch_array($result,MYSQLI_ASSOC)[/COLOR]{
echo row["Lastname"] . ' - ' . $row["Age"] . '<br>';
}

ScreamAimsFire · Aug 10, 2017

jskhulitz said:

kulang pala yung parameters nung fetch na binigay ko

Code:

// Numeric array
while($rows=[COLOR="#FF0000"]mysqli_fetch_array($result,MYSQLI_NUM)[/COLOR]{
echo row["Lastname"] . ' - ' . $row["Age"] . '<br>';
}

// Associative array
while($rows=[COLOR="#FF0000"]mysqli_fetch_array($result,MYSQLI_ASSOC)[/COLOR]{
echo row["Lastname"] . ' - ' . $row["Age"] . '<br>';
}

May error po Sir

Parse error: syntax error, unexpected 'echo' (T_ECHO) in C:\xampp\htdocs\learningcrud\fullview.php on line 34

Code:

$queryString = "SELECT name_id, name_list, section FROM employee WHERE id='$name_id'";
	$result = mysqli_query($conn,$queryString);

	// Associative array
		while($rows=mysqli_fetch_array($result,MYSQLI_ASSOC){

		[COLOR="#FF0000"]echo $row["name_list"] . ' - ' . $row["section"] . '<br>';[/COLOR]

		}

domondon1 · Aug 10, 2017

$queryString = "SELECT name_id, name_list, section FROM employee WHERE id='{$name_id}'";
try mo to TS

ScreamAimsFire · Aug 10, 2017

domondon1 said:
$queryString = "SELECT name_id, name_list, section FROM employee WHERE id='{$name_id}'";
try mo to TS

may error pa din po

Parse error: syntax error, unexpected 'echo' (T_ECHO) in C:\xampp\htdocs\learningcrud\fullview.php on line 34

King James Harden Jr · Aug 10, 2017

ScreamAimsFire said:
May error po Sir

Parse error: syntax error, unexpected 'echo' (T_ECHO) in C:\xampp\htdocs\learningcrud\fullview.php on line 34

Code:

$queryString = "SELECT name_id, name_list, section FROM employee WHERE id='$name_id'"; $result = mysqli_query($conn,$queryString); // Associative array while($rows=mysqli_fetch_array($result,MYSQLI_ASSOC){ [COLOR="#FF0000"]echo $row["name_list"] . ' - ' . $row["section"] . '<br>';[/COLOR] }

may error pa ung naka red? hirap walang thanks dito sa thread. mag upload n lng ako sa Adults Forum baka mas dumami ung thanks :rofl:

jskhulitz · Aug 10, 2017

kulang ako ng isang closing parenthesis sa dulo

Code:

// Numeric array
while($rows=mysqli_fetch_array($result,MYSQLI_NUM)[COLOR="#FF0000"])[/COLOR]{
echo row["Lastname"] . ' - ' . $row["Age"] . '<br>';
}

// Associative array
while($rows=mysqli_fetch_array($result,MYSQLI_ASSOC)[COLOR="#FF0000"])[/COLOR]{
echo row["Lastname"] . ' - ' . $row["Age"] . '<br>';
}

ScreamAimsFire · Aug 10, 2017

King James Harden Jr said:
may error pa ung naka red? hirap walang thanks dito sa thread. mag upload n lng ako sa Adults Forum baka mas dumami ung thanks

sige po sir, nag thathanks lang po ako sa nag tyatyaga at hindi nag sasawang tumulong hehe. kung thanks lang po yung habol nyo

- - - Updated - - -

jskhulitz said:

kulang ako ng isang closing parenthesis sa dulo

Code:

// Numeric array
while($rows=mysqli_fetch_array($result,MYSQLI_NUM)[COLOR="#FF0000"])[/COLOR]{
echo row["Lastname"] . ' - ' . $row["Age"] . '<br>';
}

// Associative array
while($rows=mysqli_fetch_array($result,MYSQLI_ASSOC)[COLOR="#FF0000"])[/COLOR]{
echo row["Lastname"] . ' - ' . $row["Age"] . '<br>';
}

sir jskhulitz may error pa din po

hay
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\learningcrud\fullview.php on line 33

Code:

<?php

	include("connection.php");

	if ($conn->connect_error) {

		die("Connection Failed" . $conn->connect_error);
	}

	$name_id = $_GET['id'];

	echo $name_id;

	$queryString = "SELECT name_id, name_list, section FROM employee WHERE id='$name_id'";
	$result = mysqli_query($conn,$queryString);


		// Associative array
	while($rows=mysqli_fetch_array($result,MYSQLI_ASSOC)){   [COLOR="#FF0000"]<---Line 33[/COLOR]

	echo row["name_id"] . ' - ' . $row["name_list"] . '<br>';
	
	}


?>

jskhulitz · Aug 10, 2017

may mali sa query mo, after ng $result wag mo na muna isama yung script mula while hanggang matapos, ito ang ipalit mo

Code:

if (!$result) {
    printf("Error: %s\n", mysqli_error($conn));
    exit();
}

kapag false or hindi nagtuloy yung query mo, iyan ang magdidisplay ng error na na-encounter. ipost mo dito yung error

ScreamAimsFire · Aug 10, 2017

jskhulitz said:
may mali sa query mo, after ng $result wag mo na muna isama yung script mula while hanggang matapos, ito ang ipalit mo

Code:

if (!$result) { printf("Error: %s\n", mysqli_error($conn)); exit(); }

kapag false or hindi nagtuloy yung query mo, iyan ang magdidisplay ng error na na-encounter. ipost mo dito yung error

View attachment 320534

THANK YOU PO SIR jskhulitz!! maraming salamat po sa walang sawang pag tyaga na mag turo. aaralin ko po lahat ng tinuro nyo. SALAMAT :salute:

Help naman po sa Error ko sa Php :(

More options

ScreamAimsFire

Proficient

jskhulitz

Symbianize Shaman

ScreamAimsFire

Proficient

jskhulitz

Symbianize Shaman

ScreamAimsFire

Proficient

domondon1

Professional

ScreamAimsFire

Proficient

King James Harden Jr

The Patriot

jskhulitz

Symbianize Shaman

ScreamAimsFire

Proficient

jskhulitz

Symbianize Shaman

ScreamAimsFire

Proficient

Attachments

Similar threads