<?php
$datetoday = date('dmy');
$row_Num = '1';
$i = 0;
$count = 0;
// I added this line to take care of how many times the loop runs
foreach ($_REQUEST as $key => $value) { (strstr($key, 'date')) ? $count++ : NULL; }
// Changed '<=' to '<' since it would loop 3 times since we start $i at 0
while ($i < $count) {
${'date_' . $i} = $_REQUEST["date_$i"];
${'text_' . $i} = $_REQUEST["text_$i"];
${'con_name_' . $i} = $_REQUEST["con_name_$i"];
${'con_phone_' . $i} = $_REQUEST["con_phone_$i"];
$values = array(
${"date_" . $i},
${"text_" . $i},
${"con_name_" . $i},
${"con_phone_" . $i}
);
echo '<pre>', print_r($values, true), '</pre>';
$sql = "INSERT INTO `data`.`".$datetoday."` (`KEY`,`DATE`,`COLOR`,`TEXT`,`CON_NAME`,`PHONE`) VALUES
(
'".$i."',
'".$values[0]."',
'FFFFFF',
'".$values[1]."',
'".$values[2]."',
'".$values[3]."'
)";
echo '<pre>', $sql, '</pre>';
//$result = mysql_query($sql, $link) or die ('Could not insert values: '.mysql_error());
$i++;
}
- Output for 4.3.0 - 4.3.11, 4.4.0 - 4.4.9, 5.0.0 - 5.0.5, 5.1.0 - 5.1.6, 5.2.0 - 5.2.17, 5.3.0 - 5.3.29, 5.4.0 - 5.4.45, 5.5.0 - 5.5.38, 5.6.0 - 5.6.38, 7.0.0 - 7.0.33, 7.1.0 - 7.1.33, 7.2.0 - 7.2.33, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.6
preferences:
288.01 ms | 406 KiB | 452 Q