Undefined index

[nitesh]

Hi,

Currently i am having issues with the following php i keep getting the following error message :

Notice: Undefined index: keyword in C:\xampp\htdocs\ode.php on line 34

[php]

<td><strong>Actual Result</strong></td>

<td ><strong>Pass/Fail/Not Tested</strong></td>
<td ><strong>Jira Number</strong></td>
<td ><strong>Actions</strong></td>

<?php require_once "dbc.php"; if(isset($_POST['keyword'])) //$WH = '%ODE%'; $WH = '%' . trim($_POST['keyword']) .'%'; LINE34 = $result = mysql_query("SELECT * FROM ode_testscript WHERE test_desc LIKE '%" . $_POST['keyword'] . "%' ORDER BY test_script_id ASC"); $nr = mysql_num_rows($result); if($nr > 0) { while($r = mysql_fetch_array($result)) { echo ''; } } else { echo '' .htmlspecialchars("No Record Found").' '; } ?>

Test Number	Test Step	Expected Result
'.htmlspecialchars($r['test_script_id']).'	'.htmlspecialchars($r['test_desc']).'	'.htmlspecialchars($r['expect_result']).'	'.htmlspecialchars($r['actual_result']).'	'.htmlspecialchars($r['test_status']).'	'.htmlspecialchars($r['jira_number']).'	Edit

[/php]

[sarthakpatel]

hello nitesh replace your below code with my code [php] #replce this code require_once "dbc.php"; if(isset($_POST['keyword'])) //$WH = '%ODE%'; $WH = '%' . trim($_POST['keyword']) .'%'; LINE34 = $result = mysql_query("SELECT * FROM ode_testscript WHERE test_desc LIKE '%" . $_POST['keyword'] . "%' ORDER BY test_script_id ASC"); $nr = mysql_num_rows($result); if($nr > 0) { while($r = mysql_fetch_array($result)) { echo ' '.htmlspecialchars($r['test_script_id']).' '.htmlspecialchars($r['test_desc']).' '.htmlspecialchars($r['expect_result']).' '.htmlspecialchars($r['actual_result']).' '.htmlspecialchars($r['test_status']).' '.htmlspecialchars($r['jira_number']).' Edit '; } } else { echo ''.htmlspecialchars("No Record Found").''; } ?> [/php]

use below my modified code
[php]
#use this code

<?php require_once "dbc.php"; if(isset($_POST['keyword']) && !empty($_POST['keyword'])) { $result = mysql_query("SELECT * FROM ode_testscript WHERE test_desc LIKE '%".$_POST['keyword']."%' ORDER BY test_script_id ASC"); $nr = mysql_num_rows($result); if($nr > 0) { while($r = mysql_fetch_array($result)){ echo ''; echo ''.htmlspecialchars($r['test_script_id']).' '.htmlspecialchars($r['test_desc']).' '.htmlspecialchars($r['expect_result']).''; echo ''.htmlspecialchars($r['actual_result']).' '.htmlspecialchars($r['test_status']).' '.htmlspecialchars($r['jira_number']).''; echo 'Edit'; echo ''; } } else{ echo ''.htmlspecialchars("No Record Found").''; } } ?>

[/php]

i hope this will helpful for you.
Reply your feedback
SR

[nitesh]

Hi thank you for your help, I was wondering if in the database you have enum how would you represent that in PHP.
Thanks

[sarthakpatel]

Hello nitesh, if in the database you have enum, than you can simply treat them as any varchar field. if you have any issue regarding enum, post your issues here. i will help you. Enjoy.. :) :D ~~SR~~