Gud afternoon! Ako ay nagbabalik nahuman naku ako tutorial sa PHP and MYSQL("Thank God") and karon nagbuhat ko ug a simple Student Information System kay murag kana ako nahuna2.an as practice sa ako gstudyhan simple lang na approach ako gina buhat like add student, search , delete , edit , and view. na buhat na nku ang add, search, view wala pa ang uban.. ang problema nku karon once na magsearch ko tapos mu balik ko ug home then sa pagbalik nku ug search npud naa pa ang previous result. ako g try ug SESSION ang ka2ng g keyword para e destroy lang kung maghawa sa page pero naa siyay error ana, also naa pud 2 error basta dili pa ko magsearch about a2ng index sa POST pero kung maka search nku ma wala ra man adik kaau. unsa mga possible na solution for this problem mga master.. kabalo ko na ma search ra ni sa google pero mas ok kung sainu gkan kay mga master bia mu and also daghan pa man gud ko mga further question and clarification about sa PHP/MYSQL.. so, kani lang sa..
Thank you daan!
God Bless as all!
Results 1 to 10 of 15
Thread: PHP help again :D
-
10-29-2012, 04:50 PM #1Junior Member
- Join Date
- Aug 2012
- Gender
- Posts
- 143
PHP help again :D
-
10-29-2012, 05:49 PM #2Junior Member
- Join Date
- Oct 2009
- Gender
- Posts
- 493
Re: PHP help again :D
too vague haha, mas maayo pa idescribe ug tarong
God Bless
-
10-29-2012, 06:47 PM #3Senior Member
- Join Date
- Nov 2009
- Gender
- Posts
- 972
Re: PHP help again :D
ang pina ka nindot nga searching technique is mag AJAX ka... base lang pd na sakong ma suggest nmo naay dghang styles pero nindot ang AJAX kay dynamic.... bali ang prob nmo is mag search ka then mo transfer kag lain link then mo balik ka naa japon imong query basin saup imong na link nga nabutang... dunno ha try to explore searching using AJAX sir simple rajud xa... copy paste rang codes except sa queries nmo.
-
10-29-2012, 07:13 PM #4Junior Member
- Join Date
- Aug 2012
- Gender
- Posts
- 143
Re: PHP help again :D
ahaha! too vague bitaw masking ako kung balikon ug basa kung wala kay idea ma libug ka.. salamat! ehehe!
Originally Posted by -_-
-
10-29-2012, 07:25 PM #5Junior Member
- Join Date
- Aug 2012
- Gender
- Posts
- 143
Re: PHP help again :D
sakto sir kung magtransfer ko sa lain link tapos mu balik npud ko ug search naa 2 ako previous na g search, gus2 tana nku wala na 2 siya.. (AJAX) unya na basin ko mag.ambak sa lain na topic sir. e set aside nlang sa 2 nku na problema.. mag explore sa ko ug maau sa PHP.. dili pa pud kaau ko kabalo ug javascript next mission pa nku na.. Salamat kaau sa imu idea dili nku kalimtan.. ehehe!
pero kung naa ka code sample sa search ayaw lang nang AJAX dili nku ma sabtan..
Thank you sainu!
Godbless!
-
10-29-2012, 08:40 PM #6C.I.A.
- Join Date
- Oct 2007
- Gender
- Posts
- 2,752
Re: PHP help again :D
pwede nmo ma post imong code, kadto naay PHP lng?
btw, try daw e initialize imong variable g handle sa search if gi inani nimo.
on top of page.
$_SESSION['imong_variable'] = '';
-
10-29-2012, 09:13 PM #7Junior Member
- Join Date
- Aug 2012
- Gender
- Posts
- 143
Re: PHP help again :D
gtry nku ang $_SESSION boss pero nag error siya ,dili pa jud mu search adik kaau. Pero ka2ng POST mu search siya pero naa ghpon error..
"Notice: Undefined index: keyword in C:\xampp\htdocs\Tutorial\Own\SIS\search_form.php on line 106"
mao ni ako code: Beginner ra ko
</style>
</head>
<body>
<div id="wrapper">
<div id="header"><div id="header"><img src="images/SISlgo_01.gif"/></div></div>
<div id="reg">
<form method="POST" action="search_form.php">
<table>
<ul>
<li class="text">Enter Search Keyword</li>
<li><input type="text" name="keyword"/></li>
<li><input type="submit" value="Search"/></li>
</ul><br>
<tr style="background: #666666; color: #ffffff;">
<td>Student #</td>
<td>Student Name</td>
<td>Birthday</td>
<td>Course/Year</td>
<td>E-mail</td>
<td>Contact #</td>
<td></td>
</tr>
<?php
$search = $_POST['keyword'];
$flag = 0;
$sqlQuery = "SELECT * FROM student WHERE stud_id LIKE '%$search%' or firstname LIKE '%$search%' or lastname LIKE '%$search%'";
$result = mysql_query($sqlQuery);
while($row = mysql_fetch_array($result))
{
$flag = 1;
echo "<tr>";
echo "<td>".$row[0]."</td>"." ";
echo "<td>".$row[5].",".$row[3]." ".$row[4]."</td>"." ";
echo "<td>".$row[6]."</td>";
echo "<td>".$row[7]."/".$row[8]."</td>";
echo "<td>".$row[11]."</td>";
echo '<td><a href="edit.php?id=' . $row[0] . '">Edit |</a><a href="delete.php?id=' . $row[0] . '"> Delete</a>\'</td>';
echo "</tr><br>";
}
if($flag==0)
{
echo "<tr><td colspan='3' align='center' style='color:red;'>Record not found</td></tr>";
}
?>
</table>
</form>
</div>
<div id="button">
<span><a href="home.html"><img src="images/icon_12.gif"/></a></span>
<span id="right"><a href="home.html"><img src="images/icon_13.gif"/></a></span>
</div>
<div id="footer">
<p>Proposed Project by A Beautiful Affair.<br>October 26, 2012</p>
</div>
</div>
</body>
</html>
Salamat sainu!
-
10-29-2012, 11:39 PM #8Junior Member
- Join Date
- Oct 2010
- Gender
- Posts
- 290
Re: PHP help again :D
Hello Brader,
This error:Refers to this line of code:PHP Code:"Notice: Undefined index: keyword in C:\xampp\htdocs\Tutorial\Own\SIS\search_form.php on line 106"
Sa first page load wala pa ma set ang $_POST['keyword'] kay wala pmn ma submit ang form. Bali you're trying to store non-existent data to $search. Ang solution ana is simple, use isset().PHP Code:$search = $_POST['keyword'];
bale i-check sah niya kung naa bay value ang variable before niya i-assign to $search.PHP Code:if( isset($_POST['keyword'] ) {
$search = $_POST['keyword'];
}
From PHP manual:
Also, side note lng brader. Sanitize your inputs. Placing variables directly into your SQL queries, is one web development's biggest no-noes since this opens you up to SQL injection and, in effect, other conventional hacks.Returns TRUE if var exists and has value other than NULL, FALSE otherwise.
It's OK to use these now, since you are only testing and you are on a local machine. Pero please remember that once you put this out to the world, the box that you use to host your site will be open to one of the easiest hacking methods available.
Read this article for some healthy practices.
Good luck.
-
10-30-2012, 01:50 AM #9Elite Member
- Join Date
- May 2011
- Gender
- Posts
- 1,647
Re: PHP help again :D
very broad
-
10-30-2012, 08:59 AM #10C.I.A.
- Join Date
- Oct 2007
- Gender
- Posts
- 2,752
Re: PHP help again :D
try this:
$search = isset($_POST['keyword']) ? $_POST['keyword'] : "";
to debug(after saimong $sqlQuery) pra kabalo ka unsy itsura asimong QUery statement:
if(!empty($_POST['keyword'])){
echo $sqlQuery;
exit();
}Last edited by ondoy; 10-30-2012 at 09:34 AM.
Reply With Quote Advertisement
Similar Threads |
|
Posting Permissions
|