🔒 Closed Help!

joseephftw · Aug 23, 2018

Ayaw madisplay nung mga ininput kong mga information help please!

<!DOCTYPE html>
<html>
<head>
<title>PHP/MySQLi CRUD Operation using Bootstrap/Modal</title>
<script src="You do not have permission to view the full content of this post. Log in or register now."></script>
<link rel="stylesheet" href="You do not have permission to view the full content of this post. Log in or register now." />
<script src="You do not have permission to view the full content of this post. Log in or register now."></script>
</head>
<body>
<div class="container">
<div style="height:50px;"></div>
<div class="well" style="margin:auto; padding:auto; width:80%;">
<span style="font-size:25px; color:blue"><center><strong>Guidance Management System</strong></center></span>
<span class="pull-left"><a href="#addnew" data-toggle="modal" class="btn btn-primary"><span class="glyphicon glyphicon-plus"></span> Add New</a></span>
<div style="height:50px;"></div>
<table class="table table-striped table-bordered table-hover">
<thead>
<th>Firstname</th>
<th>Lastname</th>
<th>Address</th>
<th>Course</th>
<th>Year</th>
<th>Contact Number</th>
<th>Action</th>
</thead>
<tbody>
<?php
include('conn.php');

$query=mysqli_query($conn,"select * from `user`");
while($row=mysqli_fetch_array($query)){
?>
<tr>
<td><?php echo $row['firstname']; ?></td>
<td><?php echo $row['lastname']; ?></td>
<td><?php echo $row['address']; ?></td>
<td><?php echo $row['course']; ?></td>
<td><?php echo $row['year']; ?></td>
<td><?php echo $row['contactnumber']; ?></td>
<td>
<a href="#edit<?php echo $row['userid']; ?>" data-toggle="modal" class="btn btn-warning"><span class="glyphicon glyphicon-edit"></span> Edit</a> ||
<a href="#del<?php echo $row['userid']; ?>" data-toggle="modal" class="btn btn-danger"><span class="glyphicon glyphicon-trash"></span> Delete</a>
<?php include('button.php'); ?>
</td>
</tr>
<?php
}

?>
</tbody>
</table>
</div>
<?php include('add_modal.php'); ?>
</div>
</body>
</html>

Eto yung index.php ko help please

the_flash · Aug 23, 2018

bakit deleted agad? sana di nalang pinost hehe

all she wrote · Aug 23, 2018

Help!...

me if you can, I'm feeling down,,,

joseephftw · Aug 23, 2018

bluesharkboy_05 said:
bakit deleted agad? sana di nalang pinost hehe

Boss pahelp

Android Jc · Aug 23, 2018

ung select query mo mali may kulang

joseephftw · Aug 23, 2018

Android Jc said:
ung select query mo mali may kulang

pa correct naman ng code sir yung select query

Android Jc · Aug 23, 2018

joseephftw said:
pa correct naman ng code sir yung select query

SELECT firstname, lastname, address, course, year, contactnumber FROM user

Android Jc · Aug 23, 2018

at sa database mo lagyan mo ng isang column for id importante yan dapat may id lagi

joseephftw · Aug 23, 2018

Android Jc said:
at sa database mo lagyan mo ng isang column for id importante yan dapat may id lagi

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\guidancemanagementsystem\index.php on line 32

error sir

Android Jc said:
SELECT firstname, lastname, address, course, year, contactnumber FROM user

joseephftw · Aug 23, 2018

Android Jc said:
at sa database mo lagyan mo ng isang column for id importante yan dapat may id lagi

merong id sa db ko srir

Android Jc · Aug 23, 2018

joseephftw said:
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\guidancemanagementsystem\index.php on line 32

error sir

pa ss nga ng database mo

joseephftw · Aug 24, 2018

Android Jc said:
pa ss nga ng database mo

Eto sir

joseephftw · Aug 24, 2018

Android Jc said:
pa ss nga ng database mo

sir nasan kana kailangan ko ng tulong mo

dudoylami · Aug 24, 2018

try mo tanggalin yung single quote sa table na user

"select * from user"

then try mo rin tanggalin yung $conn

Android Jc · Aug 24, 2018

joseephftw said:
sir nasan kana kailangan ko ng tulong mo

$jc = mysql_query("SELECT * FROM user"); // pag ayaw pa din palitan mo ung query ng "SELECT * FROM user LIMIT 30"

echo '<table border=1px>';
echo'<th>Id</th><th>firstname</th><th>lastname</th><th>address</th>'; //dagdagan mo nalang pag gumana

while($data = mysql_fetch_array($jc))
{

echo'<tr>';
echo '<td>'.$data['id'].'</td>
<td>'.$data['firstname'].'</td><td>'.$data['lastname'].'</td><td>'.$data['address'].'</td>';
echo'</tr>'; // tanggalin mo nlng ung id pag ayaw mo
}

echo '</table>';

joseephftw · Aug 24, 2018

dudoylami said:
try mo tanggalin yung single quote sa table na user

"select * from user"

then try mo rin tanggalin yung $conn

Ayaw pa din maretrieve nung nilalagay ko e. ayaw pa din madisplay error naman pag tinanggal $conn

joseephftw · Aug 24, 2018

Android Jc said:
$jc = mysql_query("SELECT * FROM user"); // pag ayaw pa din palitan mo ung query ng "SELECT * FROM user LIMIT 30"

echo '<table border=1px>';
echo'<th>Id</th><th>firstname</th><th>lastname</th><th>address</th>'; //dagdagan mo nalang pag gumana

while($data = mysql_fetch_array($jc))
{

echo'<tr>';
echo '<td>'.$data['id'].'</td>
<td>'.$data['firstname'].'</td><td>'.$data['lastname'].'</td><td>'.$data['address'].'</td>';
echo'</tr>'; // tanggalin mo nlng ung id pag ayaw mo
}

echo '</table>';

sa index.php yan sir?

Android Jc · Aug 24, 2018

joseephftw said:
sa index.php yan sir?

oo

joseephftw · Aug 24, 2018

Android Jc said:
$jc = mysql_query("SELECT * FROM user"); // pag ayaw pa din palitan mo ung query ng "SELECT * FROM user LIMIT 30"

echo '<table border=1px>';
echo'<th>Id</th><th>firstname</th><th>lastname</th><th>address</th>'; //dagdagan mo nalang pag gumana

while($data = mysql_fetch_array($jc))
{

echo'<tr>';
echo '<td>'.$data['id'].'</td>
<td>'.$data['firstname'].'</td><td>'.$data['lastname'].'</td><td>'.$data['address'].'</td>';
echo'</tr>'; // tanggalin mo nlng ung id pag ayaw mo
}

echo '</table>';

sir need ko lang maretrieve yung mga info na nilalagay ko T_T

dudoylami · Aug 24, 2018

yung fetch_array gawin mong fetch_assoc

🔒 Closed Help!

Honorary Poster

Attachments

Forum Expert

Honorary Poster

Honorary Poster

Eternal Poster

Honorary Poster

Eternal Poster

Eternal Poster

Honorary Poster

Honorary Poster

Eternal Poster

Honorary Poster

Attachments

Honorary Poster

Honorary Poster

Eternal Poster

Honorary Poster

Honorary Poster

Eternal Poster

Honorary Poster

Honorary Poster

Similar threads

About this Thread

Trending Topics

Online now

Forum statistics