[eluser]Greg Aker[/eluser]
Hello,
First off, I have pretty limited PHP/MySQL knowledge, and after watching the tutorials on this site and doing some searching on php.net, I'm getting the swing of building an admin app that will work for me. For now, there are only two admins that will need to access a table that will line up with my ee db, the table is "outside" (b/c I can not dissect the {exp:weblog:entries} tags to make it work for me) of ee, so I am building a simple backend to access it. I am not having to duplicating any services between ee & ci, they will compliment each other well. Anyway, getting onto my question.
On the tutorial, following the "blog $_POST" part, I am able to insert information into my db table. now, I'd REALLY like to figure out how to (in another function) to be able to call that info by the auto-incrementing id, display all of the info in the row into the <table> I put it in with. I have tried to add things like:
Code:
value="<?=$row->row_name?>"
Into my inputs, but they all seem to throw php errors.
Can anyone help with that?
When I can get this working, I'll add form validation.
Here is the code from my controller, as it is now.
Code:
function update()
{
$data['title'] = "Update the Question";
$data['heading'] = "Update the Question";
$data['query'] = $this->db->get('test');
$this->db->where('ques_num', $this->uri->segment(3));
$this->load->view('questionUpdate_view', $data);
}
here's my view file:
Code:
<?php include('includes/phpIncludes/top.inc.php');?>
<body>
<div class="masthead">
<div class="mastheadLogo"></div>
<?php include('includes/phpIncludes/nav.inc.php');?>
</div>
<div class="wrapper">
<div id="box-top">
<h1><?=$title?></h1>
<?php foreach($query->result as $row): ?>
<h2>Category: <?=$row->cat_id?></h2>
<div style="float:left;">
<p><?=$row->question?></p>
<ol>
<li><?=$row->ans_1?></li>
<li><?=$row->ans_2?></li>
<li><?=$row->ans_3?></li>
<li><?=$row->ans_4?></li>
</ol>
</div>
<div style="float:right; margin:0 0 10px 10px;">
<?php if (file_exists('full_server_path/images/practice_test/$row->img ')) {
echo "<img src=/images/practice_test/$row->img />";
}
?>
</div>
<div style="clear:both"></div>
<p><strong>Answer:</strong> <?=$row->real_ans?>,
<?php if ($row->real_ans == 1) {echo $row->ans_1;}elseif($row->real_ans == 2){echo $row->ans_2;}elseif ($row->real_ans == 3){echo $row->ans_3;}elseif ($row->real_ans == 4){echo $row->ans_4;}?></p>
<p><strong>Reasoning:</strong><br />
<?=$row->extra?></p>
<hr />
<?=form_open('questions/questionInsert');?>
<table width="800px" border="0" cellspacing="0" cellpadding="3px">
<tr>
<td><strong>Category ID</strong></td>
<td><select name="cat_id">
<option value="1">Basic Sciences (Anatomy, physiology, pathophysiology)</option>
<option value="2">Equipment, Instrumentation, Technology</option>
<option value="3">Basic Principles</option>
<option value="4">Advanced Principles</option>
<option value="5">Professional Aspects</option>
</select>
</td>
</tr>
<tr>
<td><strong>Question:</strong></td>
<td><textarea name="question" rows="6" cols="43"></textarea></td>
</tr>
<tr>
<td><strong>Possible Answer 1:</strong></td>
<td><textarea name="ans_1" rows="2" cols="43"></textarea></td>
</tr>
<tr>
<td><strong>Possible Answer 2:</strong></td>
<td><textarea name="ans_2" rows="2" cols="43"></textarea></td>
</tr>
<tr>
<td><strong>Possible Answer 3:</strong></td>
<td><textarea name="ans_3" rows="2" cols="43"></textarea></td>
</tr>
<tr>
<td><strong>Possible Answer 4:</strong></td>
<td><textarea name="ans_4" rows="2" cols="43"></textarea></td>
</tr>
<tr>
<td><strong>Real Answer:</strong></td>
<td><select name="real_ans">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
</select>
</td>
</tr>
<tr>
<td><strong>Justification & Further Reading:</strong></td>
<td><textarea name="extra" rows="10" cols="43"></textarea></td>
</tr>
<tr>
<td><strong>Image URL:</strong></td>
<td><input type="text" name="img" cols="43" /></td>
</tr>
</table>
<input type="submit" value="Submit New Question" />
</form>
<?php endforeach;?>
</div>
<div class="clear"></div>
</div> <!-- END .wrapper -->
<div class="containerBottom"></div>
</body>
</html>
I really hope everything above makes sense.
In advance, many thanks,
-greg
