Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- note: pag gusto mo makuha yung uniquie na id or target event ng nasa table na naka loop need mo gumamit ng event target
- Source: https://stackoverflow.com/questions/11026056/getting-the-class-of-the-element-that-fired-an-event-using-jquery
- for example: eto yung a tag or ahref tag na naka loop
- $view = "<a href=\"#\" class=\"btn btn-flat btn-xs bg-green\" title=\"View\" data-toggle=\"modal\" id=\"cesqt',cesqt_id,'\" data-id=\"',cesqt_id,'\" data-sy_id=\"',cesqt.sy_id,'\" data-target=\"#modal-success\">View Transaction</a>";
- //ajax code
- <script>
- var cesqt = $('a'); //note a tag to hindi to id or class value
- cesqt.click(function(){
- // alert(event.target.id + " and " + $(event.target).attr('data-id')); //uncomment mo tong alert
- var cesqt_id = $(event.target).attr('data-id');
- $.ajax({
- url: "registrar.php?",
- type: "GET",
- data: {
- statpos:'enroll_subjects_queue',
- action:'get_subjects_queue',
- cesqt_id:cesqt_id,
- sy_id:cesqt.attr('cesqt.sy_id')
- },
- success: function(data){
- console.log(data[0].ppd_firstname);
- var cnt = 0;
- var td = "";
- $('#subjects_queue').find('tbody').append(td);
- data.forEach(function(value){
- td+="<tr>"
- +"<td>"+value.subjects['subjname_shortname']+"</td>"
- +"<td>"+value.subjects['subjname_name']+"</td>"
- +"<td>"+value.subjects['ccc_lec_unit']+"</td>"
- +"<td>"+value.subjects['ccc_lab_unit']+"</td>"
- +"<td>"+value.subjects['sched'][0]['block_name']+"</td>"
- +"<td>"+value.subjects['fullname']+"</td>"+
- "</tr>";
- });
- document.getElementById("stud_name").innerHTML=data[0].ppd_lastname+', '+data[0].ppd_firstname;
- $('#subjects_queue').find('tbody').empty().append(td);
- //document.getElementById("test").innerHTML=td;
- },
- dataType: 'json'
- });
- });
- </script>
- eto yung json format kung pano mo e loloop yung json using foreach javascript api to
- Array
- (
- [0] => Array
- (
- [cesq_id] => 30
- [emp_id] => 18
- [cesq_date] => 2020-11-07 09:12:33
- [cesqt_id] => 29
- [cses_id] => 5833
- [csm_id] => 28
- [sy_id] => 23
- [cesq_id_status] => 0
- [sai_id] => 16306
- [ppd_lastname] => BERNALES
- [ppd_firstname] => MAY ZARITHA
- [subjects] => Array
- (
- [ccc_id] => 103
- [cses_id] => 5833
- [cc_id] => 27
- [is_included] => 20
- [subjname_name] => Fundamental of Games & Sports
- [subjname_shortname] => PE 3
- [ccc_lec_unit] => 2.00
- [ccc_lab_unit] => 0.00
- [college_day] => [{"sunday":0,"monday":1,"tuesday":0,"wednesday":0,"thursday":0,"friday":0,"saturday":1}]
- [college_subject_schedule_id] => 2980
- [room] =>
- [timee] => 08:00 PM-10:00 PM
- [fullname] => Edgardo Garingan
- [action] =>
- [csh_id] => 72
- [days] => M Sat
- [sched] => Array
- (
- [0] => Array
- (
- [college_subject_schedule_id] => 2980
- [college_time_in] => 08:00 PM
- [college_time_out] => 10:00 PM
- [roomdata] =>
- [fullname] => Edgardo Garingan
- [college_day] => [{"sunday":0,"monday":1,"tuesday":0,"wednesday":0,"thursday":0,"friday":0,"saturday":1}]
- [block_name] => BSN BLOCK 2A
- [extracteddays] => M Sat
- [schedsummary] => M Sat | 08:00 PM-10:00 PM
- [prof] => Edgardo Garingan
- [schedjson] => {"day":" M Sat","time":"08:00 PM-10:00 PM","room":null,"prof":"Edgardo Garingan"}
- )
- )
- )
- )
- [1] => Array
- (
- [cesq_id] => 31
- [emp_id] => 18
- [cesq_date] => 2020-11-07 09:12:33
- [cesqt_id] => 29
- [cses_id] => 5834
- [csm_id] => 28
- [sy_id] => 23
- [cesq_id_status] => 0
- [sai_id] => 16306
- [ppd_lastname] => BERNALES
- [ppd_firstname] => MAY ZARITHA
- [subjects] => Array
- (
- [ccc_id] => 385
- [cses_id] => 5834
- [cc_id] => 27
- [is_included] => 20
- [subjname_name] => Kontekstwalisadong Komunikasyon sa Filipino (KOMFIL)
- [subjname_shortname] => Fil 1
- [ccc_lec_unit] => 3.00
- [ccc_lab_unit] => 0.00
- [college_day] => [{"sunday":0,"monday":0,"tuesday":0,"wednesday":0,"thursday":0,"friday":0,"saturday":1}]
- [college_subject_schedule_id] => 3202
- [room] =>
- [timee] => 01:00 PM-04:00 PM
- [fullname] => Rodora Briguela
- [action] =>
- [csh_id] => 1888
- [days] => Sat
- [sched] => Array
- (
- [0] => Array
- (
- [college_subject_schedule_id] => 3202
- [college_time_in] => 01:00 PM
- [college_time_out] => 04:00 PM
- [roomdata] =>
- [fullname] => Rodora Briguela
- [college_day] => [{"sunday":0,"monday":0,"tuesday":0,"wednesday":0,"thursday":0,"friday":0,"saturday":1}]
- [block_name] => BSN BLOCK 2A
- [extracteddays] => Sat
- [schedsummary] => Sat | 01:00 PM-04:00 PM
- [prof] => Rodora Briguela
- [schedjson] => {"day":" Sat","time":"01:00 PM-04:00 PM","room":null,"prof":"Rodora Briguela"}
- )
- )
- )
- )
- )
- [{"cesq_id":"30","emp_id":"18","cesq_date":"2020-11-07 09:12:33","cesqt_id":"29","cses_id":"5833","csm_id":"28","sy_id":"23","cesq_id_status":"0","sai_id":"16306","ppd_lastname":" BERNALES","ppd_firstname":"MAY ZARITHA","subjects":{"ccc_id":"103","cses_id":"5833","cc_id":"27","is_included":"20","subjname_name":"Fundamental of Games & Sports","subjname_shortname":"PE 3","ccc_lec_unit":"2.00","ccc_lab_unit":"0.00","college_day":"[{\"sunday\":0,\"monday\":1,\"tuesday\":0,\"wednesday\":0,\"thursday\":0,\"friday\":0,\"saturday\":1}]","college_subject_schedule_id":"2980","room":null,"timee":"08:00 PM-10:00 PM","fullname":"Edgardo Garingan","action":" ","csh_id":"72","days":" M Sat","sched":[{"college_subject_schedule_id":"2980","college_time_in":"08:00 PM","college_time_out":"10:00 PM","roomdata":null,"fullname":"Edgardo Garingan","college_day":"[{\"sunday\":0,\"monday\":1,\"tuesday\":0,\"wednesday\":0,\"thursday\":0,\"friday\":0,\"saturday\":1}]","block_name":"BSN BLOCK 2A","extracteddays":" M Sat","schedsummary":" M Sat | 08:00 PM-10:00 PM
- ","prof":"Edgardo Garingan","schedjson":"{\"day\":\" M Sat\",\"time\":\"08:00 PM-10:00 PM\",\"room\":null,\"prof\":\"Edgardo Garingan\"}"}]}},{"cesq_id":"31","emp_id":"18","cesq_date":"2020-11-07 09:12:33","cesqt_id":"29","cses_id":"5834","csm_id":"28","sy_id":"23","cesq_id_status":"0","sai_id":"16306","ppd_lastname":" BERNALES","ppd_firstname":"MAY ZARITHA","subjects":{"ccc_id":"385","cses_id":"5834","cc_id":"27","is_included":"20","subjname_name":"Kontekstwalisadong Komunikasyon sa Filipino (KOMFIL)","subjname_shortname":"Fil 1","ccc_lec_unit":"3.00","ccc_lab_unit":"0.00","college_day":"[{\"sunday\":0,\"monday\":0,\"tuesday\":0,\"wednesday\":0,\"thursday\":0,\"friday\":0,\"saturday\":1}]","college_subject_schedule_id":"3202","room":null,"timee":"01:00 PM-04:00 PM","fullname":"Rodora Briguela","action":" ","csh_id":"1888","days":" Sat","sched":[{"college_subject_schedule_id":"3202","college_time_in":"01:00 PM","college_time_out":"04:00 PM","roomdata":null,"fullname":"Rodora Briguela","college_day":"[{\"sunday\":0,\"monday\":0,\"tuesday\":0,\"wednesday\":0,\"thursday\":0,\"friday\":0,\"saturday\":1}]","block_name":"BSN BLOCK 2A","extracteddays":" Sat","schedsummary":" Sat | 01:00 PM-04:00 PM
- ","prof":"Rodora Briguela","schedjson":"{\"day\":\" Sat\",\"time\":\"01:00 PM-04:00 PM\",\"room\":null,\"prof\":\"Rodora Briguela\"}"}]}}]
Add Comment
Please, Sign In to add comment