D
Deleted member 622421
Guest
help me po sana sa mga masters dyan 
thanks in advance guys.
thanks in advance guys.
- Status
Imkaiser101
Honorary Poster
$search = "";
if(isset($_GET['submit'])){
$search = $_GET['search'];
}
if(isset($_GET['submit'])){
$search = $_GET['search'];
}
Imkaiser101
Honorary Poster
<?php
include 'connection.php';
$search = "";
if(isset($_GET['submit'])){
$search = $_GET['search'];
}
?>
<!DOCTYPE html>
<html>
<head>
<title>View Contacts</title>
</head>
<body>
<div align="center">
<div style="display: inline-block;">Click Here to<a href="index.php"> add </a>Contacts</div>
<div style="display: inline-block;">
<form method="GET" action="">
<input type="text" name="search" placeholder="SEARCH HERE">
<input type="submit" name="submit" value="submit" >
</form>
</div>
<div>
<table border="1">
<tr>
<th>ID</th>
<th>NAME</th>
<th>PHONE NUM</th>
<th>EMAIL</th>
<th colspan="2">ACTION</th>
</tr>
<?php
$getresultsql = mysqli_query($connect,"SELECT * FROM contacts WHERE (name LIKE '%$search%' OR id = '$search')");
while($getresult = mysqli_fetch_array($getresultsql)){
$id = $getresult[0];
$name = $getresult[1];
$phone = $getresult[2];
$email = $getresult[3];
?>
<tr>
<td><?php echo $id; ?></td>
<td><?php echo $name; ?></td>
<td><?php echo $phone; ?></td>
<td><?php echo $email; ?></td>
<td><a href="<?php echo "update.php?getid=".$id; ?>"><button>View</button></a></td>
<td><a href="<?php echo "delete.php?getid=".$id; ?>"><button>Delete</button></a></td>
</tr>
<?php
}
?>
</table>
</div>
</div>
</body>
</html>
Yan buong php para alam mo
include 'connection.php';
$search = "";
if(isset($_GET['submit'])){
$search = $_GET['search'];
}
?>
<!DOCTYPE html>
<html>
<head>
<title>View Contacts</title>
</head>
<body>
<div align="center">
<div style="display: inline-block;">Click Here to<a href="index.php"> add </a>Contacts</div>
<div style="display: inline-block;">
<form method="GET" action="">
<input type="text" name="search" placeholder="SEARCH HERE">
<input type="submit" name="submit" value="submit" >
</form>
</div>
<div>
<table border="1">
<tr>
<th>ID</th>
<th>NAME</th>
<th>PHONE NUM</th>
<th>EMAIL</th>
<th colspan="2">ACTION</th>
</tr>
<?php
$getresultsql = mysqli_query($connect,"SELECT * FROM contacts WHERE (name LIKE '%$search%' OR id = '$search')");
while($getresult = mysqli_fetch_array($getresultsql)){
$id = $getresult[0];
$name = $getresult[1];
$phone = $getresult[2];
$email = $getresult[3];
?>
<tr>
<td><?php echo $id; ?></td>
<td><?php echo $name; ?></td>
<td><?php echo $phone; ?></td>
<td><?php echo $email; ?></td>
<td><a href="<?php echo "update.php?getid=".$id; ?>"><button>View</button></a></td>
<td><a href="<?php echo "delete.php?getid=".$id; ?>"><button>Delete</button></a></td>
</tr>
<?php
}
?>
</table>
</div>
</div>
</body>
</html>
Yan buong php para alam mo
Imkaiser101
Honorary Poster
Isa yan sa mga codes ko ikaw na bahala magpagana sa code mo pag ilalagay muna sayo
Fitzflor17
Addict
tnks sa mga nag turo
Hindi mo na kailangan i-declare yung variable $search bago gamitin. Delikado yung queries mo, risk sa sql injection.
jokerger25
Honorary Poster
may mysqli_real_escape_string() /mysqli_escape_string() naman
walang ganun sa code na binigay niya.may mysqli_real_escape_string() /mysqli_escape_string() naman
Heizengberg
Eternal Poster
dataTable ka nalang pre
Khenjhie17
Addict
input lang yang
Easiest way is gamit ka ajax/javascript.
boss pasilip kung pano baka may sample ka boss or reference
TIAhttps://phcorner.net/threads/716219/
ito kasi problema koDatatable'based search is only applicable if you are using datatable (of course) and only wanna do client side search
Ideally if your goal is like Google Search's search feature, you should have a backend api powered by something like ElasticSearch and a frontend component that utilizes async calls aka AJAX.
Now if you are just making a db search aka db query, then your standard db queries should work.
If you are only searching like 10 static items, then frontend, client side search is probably the most practical. 10 items are nothing. That's easily searchable via JavaScript.
Ideally if your goal is like Google Search's search feature, you should have a backend api powered by something like ElasticSearch and a frontend component that utilizes async calls aka AJAX.
Now if you are just making a db search aka db query, then your standard db queries should work.
If you are only searching like 10 static items, then frontend, client side search is probably the most practical. 10 items are nothing. That's easily searchable via JavaScript.
- Status
Similar threads
-
-
Course HTML and CSS for Beginners From Basic to Advance UDEMY COUPON
- Started by PHC - JANG
- Replies: 2
-
Tutorial HTML and CSS Templates [Source Code]
- Started by PHC - Raymond
- Replies: 53
-
-
Course UDEMY CSS, JavaScript,PHP And Python Programming All in One Course
- Started by PyroKhalifa
- Replies: 4
Popular Tags
android
api
app
arduino
bot
c
c++
capstone
capstone project
code
coding
coding and programming
css
database
developer
development
help
how
how to
html
in
java
javascript
language
laravel
mag
mysql
need
patulong
php
program
programmer
programming
programming language
project
python
question
react
script
sql
system
thesis
tutorial
udemy
vb.net
visual basic
web
web development
website
with