Record sequence between 2 fields

marcelotguedes

Hello, I'm back and would like everyone's help, how do I write in mysql a sequence of numbers coming from a form, like this:

in form they would have 3 fields being name, start and end

field name: test
***start: 0001
*****end: 0010

when writing to BD would look like

+------+------+
| name |test|
+------+------+
| test |0001|
| test |0002|
| test |0003|
| test |0004|
| test |0005|
| test |0006|
| test |0007|
| test |0008|
| test |0009|
| test |0010|
+------+------+

I did so

for ($i = (int)$POST['start'];
$i <= (int)$POST['end']; $i++)
echo "$i\n","<br>";

But I could not do the INSERT INTO, please help me

marcelotguedes

please

traq

I don't understand your question. It seems you might need to look at some basic tutorials about how to read POST data. And you don't show us your SQL at all. You need to describe what you want to do in more detail, explain what you already tried (and show us the code!), and what happened (vs. what you expected to happen).

barand

try

<?php
$db = new mysqli(HOST, USERNAME, PASSWORD, DATABASE);

$db->query("DROP TABLE IF EXISTS test_1");
$db->query("CREATE TABLE test_1 (
    name VARCHAR(10),
    test INT(4) ZEROFILL,
    PRIMARY KEY (name,test)
)");

if (isset($_POST['start'])) {
$start = $_POST['start'];
$finish = $_POST['end'];
$data = array();

for ($i=$start; $i<=$finish; $i++) {
    $data[] = sprintf("('%s', %d)", 'test', $i);
}
$sql = "INSERT INTO test_1 VALUES\n" . join(",\n", $data);
$db->query($sql);
$sql = "SELECT name, test FROM test_1";
echo query2HTMLtable($db,$sql);
}
else die("values required");
?>

RESULTS

+------+------+
| name | test |
+------+------+
| test | 0001 |
| test | 0002 |
| test | 0003 |
| test | 0004 |
| test | 0005 |
| test | 0006 |
| test | 0007 |
| test | 0008 |
| test | 0009 |
| test | 0010 |
+------+------+