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

Correohs · January 22, 2013

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

---------

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'; ?>

<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 field="lo_client_id">Client #</th>

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

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

</tr>

</thead>

</table>

<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>

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

<?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>

<?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>

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

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

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

<option value="4">April</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>

</div>

<?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>

<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>

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

</form>

</div>

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

</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.'));

}

?>

Sign In

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

Recommended Posts

Correohs

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information