PHP从值X创建X量的MySQL条目

Question

I need some assistance with a project, I am clueless on creating this type of advanced code that I need to complete the project.

I retrieve a certain value "X" (1 - 1000), and need to create the same amount of MySQL entries of the value "X", each entry has different information, this is retrieved through JSON url.

Here is the data I retrieve that I need to save to the database:

1. Title (Does not change)
2. ID (New ID with each value "X", eg, 1 = itv23, 2 = itb12 ...)
4. Detail (Changes per ID)

I have a working JSON Phrase, however dont know how to automate the entries to the database so that it creates the "X" amount of entries to a certain Table in the Database.

Answer 1

With the information you gave is a little bit difficult to answer but I thin this at least will give you a boost

$titles = array("title1", "title2", "title3",....);
$details = array("details1","details2","details3",....);
$times = $X;

foreach ($times as $time){
  $id = $time. "something";
  $title = $titles[$time];
  $detail = $details[$time];
  mysql_query("INSERT INTO tableName (id,title,details) 
  VALUES ('$id', '$title',$details)");
}

I didn't quite understand the JSON part but if you have a JSON you can decode it and use it in PHP like this:

$json = '{"a":1,"b":2,"c":3,"d":4,"e":5,.....}';
$jsonTophp = json_decode($json);