ESH/insertdata.php
2024-10-23 18:28:06 +05:30

26 lines
605 B
PHP

<?php
include ('techsyn_header.php');
include ('includes/config/config.php');
error_reporting(E_ERROR | E_PARSE);
$query_sql="select * from checkup_form";
$result_query = @mysqli_query($conn,$query_sql);
$num=mysqli_num_rows($result_query);
$a=array(12.5,10.5,14.5,17.5,14.9,12.3,18.6,18.1,18.4,12.3,17.5,19.5);
$j=0;
for($i=0;$i<$num;$i++){
if(count($a)<j){
$j=0;
}
$query="insert into checkup_form_key_value (checkup_form_id,checkup_form_key,checkup_form_value) select checkup_id,'hb','".$a[$j]."'from checkup_form";
$j++;echo $query;
@mysqli_query($conn,$query);
}
?>