Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Foreach could be used for this as well. It doesn't HAVE to loop over and insert all records. However, here is how it can be done with a for statement</p> <pre><code>//indexes are 0-indexed, meaning $xml[0] = first, $xml[119] = last (for 120 records) for($i=0;$i&lt;119;$i++) { $user = $xml[$i]; //Provided that the element you are looping over is an array of entities //Database insert logic here } </code></pre> <p>Please, please for the love of little puppies consider PDO and prepared statements, rather than using deprecated mysql_* functions, and unsanitized input. If your XML contains the name "O'malley" it WILL break your query!!</p> <p>Updated to include sample for foreach and with fields referenced:</p> <pre><code>//indexes are 0-indexed, meaning $xml[0] = first, $xml[119] = last (for 120 records) for($i=0;$i&lt;119;$i++) { $user = $xml[$i]; //Provided that the element you are looping over is an array of entities $name = $user-&gt;name; $sex = $user-&gt;sex; $address = $user-&gt;address; $result = mysql_query("insert into abc (name,sex,address) values ($name,$sex,$address)",$con) } echo $i+1." "."Records successfully added"; </code></pre> <p>With Foreach:</p> <pre><code>$limit = 119; $i = 0; //indexes are 0-indexed, meaning $xml[0] = first, $xml[119] = last (for 120 records) for($xml as $user) { if($i &gt; $limit) { break; } $name = $user-&gt;name; $sex = $user-&gt;sex; $address = $user-&gt;address; $result = mysql_query("insert into abc (name,sex,address) values ($name,$sex,$address)",$con) $i++; } echo $i+1." "."Records successfully added"; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POread and insert xml file's records using php mysql via For statement not Foreach Loop
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJC.
    1. USJC.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COjc, please 1. let me have d sample of d insert statement showing each corresponding fields. Thanks 2. how can d above question be explicitly achieved using d Foreach statement ?
      singulars
      1. PO
      1. USGentlesule
    2. COThanks, you d Big 'BOSS'
      singulars
      1. PO
      1. USGentlesule
    3. COProf. JC, please from d above case, if my database contains some previous records, how can I query each db row before new record can be inserted from my xml file to prevent duplicated insertions for every xml file load or read sessions. Thanks. Prof.
      singulars
      1. PO
      1. USGentlesule
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload