StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
17925327
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-07-29T13:25:35.747
FavoriteCount
0
LastActivityDate
2013-07-29T14:12:33.250
LastEditDate
2013-07-29T14:12:33.250
LastEditorUserId
1490306
OwnerUserId
1490306
ParentId
17831498
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
<p>i am not sure i understand the question that well. if you are doing ajax posting and dynamic updating of the form, you may want to consider using the json_encode (php) and $.parseJson (jQuery) to send the parameters back to the client. that way you can send a ready-made html straight to the browser id.</p> <p>The cities function in javascript is a bit confusing to me. the parameters are: success:function (data, textStatus, jqXHR)</p> <p>the ajax.post function parameters are: jQuery.post( url [, data ] [, success(data, textStatus, jqXHR) ] [, dataType ] ) so, the data is something like: var data = {product_id:$('#product_id').val()}; this will send the data through as a POST variable, instead of as a GET variable as is the case in your code.</p> <p>some comments: in the view, end the change the line:</p> <pre><code><form action="<?php echo base_url(); ?>welcome/add" method="post"> </code></pre> <p>into:</p> <pre><code><form action="<?php echo base_url('index.php'.DIRECTORY_SEPARATOR.'welcome'.DIRECTORY_SEPARATOR.'add'); ?>" method="post"> </code></pre> <hr> <p>in the model, don't have the ?> closing tag, this all becomes: (which worked for me!)</p> <p>controller:</p> <pre><code><?php if (!defined('BASEPATH')) exit('No direct script access allowed'); class Welcome extends CI_Controller { public function __construct() { parent::__construct(); $this->load->model('welcome_model'); } public function index() { $data = array(); $data['category'] = $this->welcome_model->select_category(); $data['product'] = $this->welcome_model->select_product(); $this->load->view('purchase_entry', $data); } function get_products($category) { header('Content-Type: application/x-json; charset=utf-8'); echo(json_encode($this->welcome_model->select_product_by_category($category))); } function add() { $result = $this->welcome_model->select_product_by_id($this->input->post('product_id', TRUE)); $insert = array( 'id' => $this->input->post('product_id', true), 'qty' => $this->input->post('quantity', true), 'price' => $this->input->post('unit_price', true), 'name' => $result->product_name ); $this->cart->insert($insert); redirect("welcome/index"); } } </code></pre> <p>model:</p> <pre><code><?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); class Welcome_Model extends CI_Model { public function select_category() { $this->db->select('*'); $this->db->from('category'); $query_result= $this->db->get(); $result=$query_result->result(); return $result; } public function select_product() { $this->db->select('*'); $this->db->from('product'); $query_result= $this->db->get(); $result=$query_result->result(); return $result; } public function select_product_by_category($category_id) { $this->db->select('*'); $this->db->from('product'); $this->db->where('category_id',$category_id); $query_result= $this->db->get(); $result=$query_result->result(); return $result; } public function select_product_by_id($product_id) { $this->db->select('*'); $this->db->from('product'); $this->db->where('product_id',$product_id); $query_result= $this->db->get(); $result=$query_result->row(); return $result; } } </code></pre> <p>view</p> <pre><code><html> <head> <title></title> <script type="text/javascript" src="<?php echo base_url(); ?>js/jquery.min.js"></script> <script> $(document).ready(function(){ $('#category_id').change(function(){ $("#product_id > option").remove(); var category_id = $('#category_id').val(); $.ajax({ type: "POST", url: "<?php echo base_url('index.php/welcome/get_products/').'/';?>"+category_id, success: function(cities) { $.each(cities,function(id,name) { var opt = $('<option />'); opt.val(id.product_id); opt.text(name.product_name); $('#product_id').append(opt); }); } }); }); }); </script> <style type="text/css"> a{text-decoration: none;} </style> </head> <body> <form action="<?php echo base_url('index.php'.DIRECTORY_SEPARATOR.'welcome'.DIRECTORY_SEPARATOR.'add'); ?>" method="post"> <table width="400px" align="center"> <caption><h3>Purchase Invoice</h3></caption> <tr> <td>Invoice Date :</td> <td> <input type="text" name="invoice_date" value=""/> </td> </tr> <tr> <td>Select Category :</td> <td> <select name="category_id" id="category_id"> <option>--- Select Category ---</option> <?php foreach ($category as $aCategory) { ?> <option value="<?php echo $aCategory->category_id; ?>"><?php echo $aCategory->category_name; ?></option> <?php } ?> </select> </td> </tr> <tr> <td>Select Product :</td> <td> <select name="product_id" id="product_id"> </select> </td> </tr> <tr> <td>Unit Price :</td> <td> <input type="text" name="unit_price" value=""/> </td> </tr> <tr> <td>Quantity :</td> <td> <input type="text" name="quantity" value=""/> </td> </tr> <tr> <td>&nbsp;</td> <td> <input type="submit" value="Submit"/> </td> </tr> </table> </form> <form action="" method="post"> <h2 align="center">Invoice Details</h2> <table border="1px" cellpadding="5px" cellspacing="1px" style="margin-top:10px;border-collapse:collapse" width="500px" align="center"> <tr align="center" style="font-family:Arial, Helvetica, sans-serif; font-size:12px;"> <th>Serial</th> <th>Product Name</th> <th>Quantity</th> <th>Unit Price</th> <th>Amount</th> <th>Action</th> </tr> <?php if ($cart = $this->cart->contents()) ?> <?php $i = 1; foreach ($cart as $item) { ?> <tr> <td><?php echo $i++; ?></td> <td><?php echo $item['name']; ?></td> <td><?php echo $item['qty']; ?></td> <td><?php echo $item['price']; ?></td> <td><?php echo $item['subtotal']; ?></td> <td> <a href="">Update</a>&nbsp;|&nbsp;<a href="">Remove</a> </td> </tr> <?php } ?> </table> </form> </body> </html> </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to pass jQuery dropdown selected change value as a parameter from view file to controller
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USpgee70
UserOwnerUserId
1. USpgee70
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.