-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathaction-form.ajax.php
34 lines (31 loc) · 1.73 KB
/
action-form.ajax.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
<?php include_once('config.php');
if(isset($_REQUEST['action']) and $_REQUEST['action']=="addDataRow"){
?>
<tr>
<td align="center" class="text-danger"><button type="button" data-toggle="tooltip" data-placement="right" title="Click To Remove" onclick="if(confirm('Are you sure to remove?')){$(this).closest('tr').remove();}" class="btn btn-danger"><i class="fa fa-fw fa-trash-alt"></i></button></td>
<td align="center"><?php echo date('Y-m-d H:i:s');?></td>
<td><input type="text" name="username[]" class="form-control" required="required"></td>
<td>
<select name="usercountry[]" id="usercountry" class="form-control selectpicker" data-live-search="true" data-size="10" required="required">
<option value="">Select</option>
<?php
$result = $db->query("SELECT * FROM countries WHERE 1 ORDER BY countryName ASC ");
while($val = $result->fetch_assoc()){
?>
<option value="<?php echo $val['id']?>" data-subtext="(<?php echo $val['continentName']?>)"><?php echo mb_strtoupper($val['countryName'],'UTF-8')?></option>
<?php }?>
</select>
</td>
<td><input type="email" name="useremail[]" class="form-control" required="required"></td>
<td><input type="text" name="userphone[]" class="form-control" required="required"></td>
</tr>
<?php
echo '|***|addmore';
}
if(isset($_REQUEST['action']) and $_REQUEST['action']=="saveAddMore"){
extract($_REQUEST);
foreach($username as $key=>$un){
$db->query('INSERT INTO reorderusers (username, useremail, userphone, usercountry) VALUES ("'.$un.'", "'.$useremail[$key].'", "'.$userphone[$key].'", "'.$usercountry[$key].'") ');
}
echo '<div class="alert alert-success"><i class="fa fa-fw fa-thumbs-up"></i> Record added successfully!</div>|***|add';
}