Welcome Guest, Not a member yet? Register   Sign In
Set autoincrement value for each value in row -- php
#3

[eluser]masentinel900[/eluser]
Friend many thanks by your response, But I believe that doesn't works for me. I going to expose of the better way my problem.

[DB]
CREATE TABLE "processOrder"
(
"idOrderProcess" serial NOT NULL,
idproceso integer NOT NULL,
"conseFunction" integer NOT NULL,
idfuncion integer NOT NULL,
creadopor integer NOT NULL,
fechacreacion date NOT NULL,
CONSTRAINT "pkOrderProcess" PRIMARY KEY ("idOrderProcess"),
CONSTRAINT "fKFunction" FOREIGN KEY (idfuncion)
REFERENCES funciones (idfuncion) MATCH SIMPLE
ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "fKProcess" FOREIGN KEY (idproceso)
REFERENCES procesos (idproceso) MATCH SIMPLE
ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "fKUser" FOREIGN KEY (creadopor)
REFERENCES usuario (idusuario) MATCH SIMPLE
ON UPDATE CASCADE ON DELETE CASCADE
)

[Controller]
Code:
function postFunctionByProcess(){
  $insertprocessOrder = $this->input->post('insertprocessOrder');
  $session_data = $this->session->userdata('logged_in');
  $SprocessOrder = $this->input->post('processOrder');
  $ordFunction = $this->input->post('ordFunction');
  $ordProcess = $this->input->post('ordProcess');
  date_default_timezone_set('UTC');
  $this->load->helper('date');
  $datestring = "%Y-%m-%d";
  if($ordFunction || $ordProcess == 0){
   echo "Seleccione 2 opciones antes de enviar";
  }else{
    $data = array(
    'idproceso' => $ordProcess,
    'conseFunction' => $conseFunction,
    'idfuncion' => $ordFunction,
    'creadopor' => $data['idusuario'] = $session_data['idusuario'],
    'fechacreacion' =>mdate($datestring)
    );
   }}

[Jquery]
Code:
function postFunctOrder(){
$("#five form").submit(function(evnt){
evnt.preventDefault()
$.post('functionPortal/postFunctionByProcess',{'ordProcess':$(this).children('select[name="ordProcess"]').val(), 'ordFunction':$(this).children('select[name="ordFunction"]').val()},function(data){
  $("#data").html(data)
  })
})
}


[HTML]
Code:
<div id="five" >
&lt;form method="post"&gt;
<fieldset>Select Process</fieldset>
<select class="selecInput" name="ordProcess">
<option disabled="disabled" selected="selected" value="0">Select Process</option>
    &lt;?php foreach($selectProcess->result_array() as $row):?&gt;
    <option value="&lt;?php echo $row['idproceso'];?&gt;">&lt;?php echo $row['nombreProceso'];?&gt;</option>
    &lt;?php endforeach;?&gt;
</select>
<fieldset>Select Function</fieldset>
<select class="selecInput" name="ordFunction">
<option disabled="disabled" selected="selected" value="0">Select Function</option>
    &lt;?php foreach($ViewFunciones->result_array() as $row):?&gt;
    <option value="&lt;?php echo $row['idfuncion'];?&gt;">&lt;?php echo $row['descripcioncorta'];?&gt;</option>
    &lt;?php endforeach;?&gt;
</select><br />
&lt;input type="submit" class="button-style" value="Enviar" /&gt;
<div id="data"></div>
&lt;/form&gt;
</div>


Messages In This Thread
Set autoincrement value for each value in row -- php - by El Forum - 04-29-2013, 02:48 PM
Set autoincrement value for each value in row -- php - by El Forum - 04-29-2013, 09:19 PM
Set autoincrement value for each value in row -- php - by El Forum - 04-30-2013, 08:12 AM
Set autoincrement value for each value in row -- php - by El Forum - 05-01-2013, 05:03 AM
Set autoincrement value for each value in row -- php - by El Forum - 05-08-2013, 06:21 AM



Theme © iAndrew 2016 - Forum software by © MyBB