<?php
$my_array = array();
$my_array['id'] = 4127 ;
$my_array['nick'] = 'Jonas';
$my_array['dte79855545'] = 5;
$my_array['dte79855545'] = 5;
$my_array['dte1111'] = 1;
$my_array['dte2222'] = 2;
$my_array['dte3333'] = 3;
$my_array['dte4444'] = 4;
$my_array_of_dte = array();
$dte_inc = 0;
foreach($my_array as $key => $value)
{
if (substr($key,0,3)=='dte')
{
$my_array_of_dte[$dte_inc]['id'] = substr($key,3);
$my_array_of_dte[$dte_inc]['value'] = $value;
$dte_inc++;
}
}
for($inc=0;$inc<$dte_inc;$inc++)
{
$query = "INSERT INTO user_count (id, nick, dte, count) VALUES ('".$my_array['id']."', '".$my_array['nick'] = 'Jonas'."', '".$my_array_of_dte[$inc]['id']."', '".$my_array_of_dte[$inc]['value']."')";
// $result = mysql_query($query);
echo $query."\n";
}
?>
- 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.40, 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
- INSERT INTO user_count (id, nick, dte, count) VALUES ('4127', 'Jonas', '79855545', '5')
INSERT INTO user_count (id, nick, dte, count) VALUES ('4127', 'Jonas', '1111', '1')
INSERT INTO user_count (id, nick, dte, count) VALUES ('4127', 'Jonas', '2222', '2')
INSERT INTO user_count (id, nick, dte, count) VALUES ('4127', 'Jonas', '3333', '3')
INSERT INTO user_count (id, nick, dte, count) VALUES ('4127', 'Jonas', '4444', '4')
preferences:
285.25 ms | 406 KiB | 460 Q