Jump to content

Retrieve data from Table1/2/3/4, display data, cannot save it in Table5

Correohs

By Correohs
in PHP Coding Help

Recommended Posts

Correohs Newbie

Correohs

Posted
Posted

I'm working in a system. Retrieve info using LEFT JOIN and I'd like to save this info in another table. passing those variable using $_POST

 

I want to display $act_id_numb ( Activity ID Number ) passing to save.php page. to INSERT it to the table.

in 3 days I coudnt figure that out. Any help its really apreciate it. Thanks in Advance! Angel.

 

System retrieve some info from database and display it. to add a new record system open a new windows. and bring even more info from DB. when I try to save it. the sytem loose some info. 1- its because I dont know how to send a $act_id_numb to the Save page using $_POST it should be $_POST [ 'act_id_numb']

how can I convert form $act_id_numb to act_id_numb ( with no $ sign )

 

System Idea is Employees are working for Clients doing different job for them, I want to track the time that each employee spend with the Client and if there was a Power Outage be able to know about it.

 

Image01 - retrieve data from DB ( upload it using phpmyadmin into to tbl_Layout.

Image02 - I want to add a new record. but I coudnt make it to work.

 

You can see te.php , get_te.php, save_te.php ( just for new records )

 

Thanks!

---------

te.php

---------

<script type="text/javascript" src="http://code.jquery.c...n.js"></script>

<script type="text/javascript" src="http://www.jeasyui.c...n.js"></script>

<script type="text/javascript">

var url;

function newUser(){

$('#dlg').dialog('open').dialog('setTitle','New Activity');

$('#fm').form('clear');

url = 'save_te.php';

}

function editUser(){

var row = $('#dg').datagrid('getSelected');

if (row){

$('#dlg').dialog('open').dialog('setTitle','Edit');

$('#fm').form('load',row);

url = 'update_te.php?id='+row.id;

}

}

function saveUser(){

$('#fm').form('submit',{

url: url,

onsubmit: function(){

return $(this).form('validate');

},

success: function(result){

var result = eval('('+result+')');

if (result.success){

$('#dlg').dialog('close'); // close the dialog

$('#dg').datagrid('reload'); // reload the user data

} else {

$.messager.show({

title: 'Error',

msg: result.msg

});

}

}

});

}

function removeUser(){

var row = $('#dg').datagrid('getSelected');

if (row){

$.messager.confirm('Confirm','Are you sure?',function®{

if ®{

$.post('remove_te.php',{emp_id:row.emp_id},function(result){

if (result.success){

$('#dg').datagrid('reload'); // reload the user data

} else {

$.messager.show({ // show error message

title: 'Error',

msg: result.msg

});

}

},'json');

}

});

}

}

</script>

</head>

<body>

<?php include 'conn.php'; ?>

<h2 align="center"><a href="index.php">Main Menu </a></h2>

<div class=container>

<h2 style="text-align: left;">TEMS 2013 [ C.R.U.D.]</h2>

 

<div class="demo-info" style="margin-bottom:10px">

<div class="demo-tip icon-tip"> </div>

<div>Click the buttons on datagrid toolbar to do crud actions.</div>

</div>

 

<table id="dg" title="TEMS Activities" class="easyui-datagrid" style="width:900px;height:350px"

url="get_te.php"

toolbar="#toolbar" pagination="true"

rownumbers="true" fitColumns="true" singleSelect="true">

<thead>

<tr>

<th align="center" field="lo_id">Rec.</th>

<th field="lo_client_id">Client #</th>

<th align="center" field="client_desc">Name</th>

<th align="center" field="lo_empl_id">Empl #</th>

 

<th field="emp_last_name"> Firt N.</th>

<th field="emp_first_name"> Last N.</th>

<th align="center" field = "lo_act_id"> Act.# </th>

<th align="center" field = "act_id_numb"> Act.2 </th>

<th field = "act_desc"> Desc.</th>

<th align="center" field="lo_time"> Time </th>

<th field = "lo_desc"> Cause </th>

<th field="m_desc"> Month</th>

<th field="lo_year"> Year</th>

</tr>

</thead>

</table>

 

 

 

<div id="toolbar">

<a href="#" class="easyui-linkbutton" iconCls="icon-add" plain="true" onclick="newUser()">New</a>

<a href="#" class="easyui-linkbutton" iconCls="icon-edit" plain="true" onclick="editUser()">Edit</a>

<a href="#" class="easyui-linkbutton" iconCls="icon-remove" plain="true" onclick="removeUser()">Remove</a>

</div>

 

<div id="dlg" class="easyui-dialog" style="width:600px;height:480px;padding:10px 20px"

closed="true" buttons="#dlg-buttons">

<div class="ftitle">Information</div>

 

<form id="fm" method="post" novalidate>

<?php // --------- Form Start ---------------- ?>

 

 

<div class="fitem">

<?php

include 'conn.php';

 

$sqlc = "SELECT client_desc,client_code FROM tbl_Client";

$resultc = mysql_query($sqlc);

 

echo "<select name='lo_client_id'>";

echo "<OPTION selected>--Select--</OPTION>";

while ($rowc = mysql_fetch_array($resultc)) {

echo "<option value='" . $rowc['client_code'] . "'>" . $rowc['client_desc'] . " - ".$rowc['client_code'] . "</option>";

}

echo "</select>";

?>

</div>

 

 

<div class="fitem">

<?php

$sql1 = "SELECT emp_code, emp_last_name,emp_first_name FROM tbl_Employee";

$result1 = mysql_query($sql1);

echo "<select name='lo_empl_id'>";

echo "<OPTION selected>--Select--</OPTION>";

while ($row1 = mysql_fetch_array($result1)) {

echo "<option value='" . $row1['emp_code'] . "'>" . $row1['emp_last_name']. ", ".$row1['emp_first_name'] . "</option>";

}

echo "</select>";

?>

</div>

 

<div class="fitem">

<select name="lo_month" size="1">

<option value="1">January</option>

<option value="2">February</option>

<option value="3">March</option>

<option value="4">April</option>

<option value="5">May</option>

<option value="6">June</option>

<option value="7">July</option>

<option value="8">August</option>

<option value="9">September</option>

<option value="10">October</option>

<option value="11">November</option>

<option value="12">December</option>

</select>

 

<select name="lo_year" size="1">

<option value="2013">2013</option>

<option value="2014">2014</option>

<option value="2015">2015</option>

</select>

 

</div>

<div class="fitem">

 

 

<?php

 

$sql_act = "SELECT * FROM tbl_Activ where act_id_numb=$lo_act_id ORDER BY act_title_id_numb";

$result_act = mysql_query($sql_act);

 

?>

 

<br>

<table id="tb" cellspacing="0">

 

<thead><tr><th>Title ID</th><th>Act ID</th><th>Desc</th><th>Time</th></tr></thead>

<tbody>

 

<?php

 

while ($row_act = mysql_fetch_array($result_act)) {

 

$act_title_id_numb = $row_act['act_title_id_numb'];

$act_id_numb = $row_act['act_id_numb'];

$act_desc = $row_act['act_desc'];

 

echo '<tr>';

echo

'<td align="right"><b>' . $act_title_id_numb . '</b></td>' .

'<td align="right">' . $act_id_numb . '</td>' .

'<td class="even">' . $act_desc . '</td>';

?>

 

 

<?php

echo '</tr>';

 

}

?>

 

 

</tbody>

</table>

 

 

</div>

 

 

</div>

<?php // --------- Form End ------------- ?>

</form>

</div>

<div id="dlg-buttons">

<a href="#" class="easyui-linkbutton" iconCls="icon-ok" onclick="saveUser()">Save</a>

<a href="#" class="easyui-linkbutton" iconCls="icon-cancel" onclick="javascript:$('#dlg').dialog('close')">Cancel</a>

</div>

 

</div>

</body>

</html>

 

 

--------------

get_te.php

--------------

<?php

$page = isset($_POST['page']) ? intval($_POST['page']) : 1;

$rows = isset($_POST['rows']) ? intval($_POST['rows']) : 10;

$offset = ($page-1)*$rows;

$result = array();

 

include 'conn.php';

 

$rs = mysql_query("select count(*) from tbl_Layout");

$row = mysql_fetch_row($rs);

$result["total"] = $row[0];

 

$rs = mysql_query("SELECT * FROM tbl_Layout

LEFT JOIN tbl_Client ON lo_client_id=client_code

LEFT JOIN tbl_Employee on lo_empl_id = emp_code

LEFT JOIN tbl_Activ on lo_act_id = act_id_numb

LEFT JOIN tbl_Month on lo_month = m_numb

limit $offset,$rows");

 

 

$items = array();

while($row = mysql_fetch_object($rs)){

array_push($items, $row);

}

$result["rows"] = $items;

 

echo json_encode($result);

?>

 

-----------------

save_te.php

----------------

 

<?php

$lo_client_id = $_REQUEST['lo_client_id'];

$lo_empl_id = $_REQUEST['lo_empl_id'];

$lo_month = $_REQUEST['lo_month'];

$lo_year = $_POST['lo_year'];

$act_id_numb = $_POST['act_id_numb'];

$act_time = $_REQUEST['act_time'];

$lo_desc = $_REQUEST['act_desc'];

 

//**********************************************************************************

//

// I just start using POST instead of REQUEST ( I read about the risk of $_REQUEST )

// windows.onload:

// To check and see the variables sent by te.php

//

// This page receive

// YES = $lo_client_id, $lo_empl_id, $lo_month , $lo_year

// No = $act_id_numb, $act_time, $lo_desc

//

//**********************************************************************************

 

echo '<script type="text/javascript"> window.onload=function(){alert("' . $lo_client_id . " - " . $lo_empl_id . " - " . $lo_month . " - " . $lo_year ." - " . $act_id_numb . " - " . $act_time . " - " . $lo_desc . '");} </script>';

 

include 'conn.php';

 

 

$result = @mysql_query($sql);

if ($result){

echo json_encode(array('success'=>true));

} else {

echo json_encode(array('msg'=>'Some errors occured.'));

}

?>

post-84895-0-94880600-1358878692_thumb.jpg

post-84895-0-82921200-1358878699_thumb.jpg

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.