Skip to main content
Code Review

Return to Question

deleted 27 characters in body; edited title
Source Link
Jamal
  • 35.2k
  • 13
  • 134
  • 238

simplify mysql Simplify MySQL INSERT query

Is there a way to simplify the codescode below? I have the codes below and i I want to simplify themit, but iI don't know if it is possible.

In the table below i, I insert data which will end-up up in a mysqlMySQL table.

htmlHTML

<table border="0">
 <tr>
 <td align="center">Dată / Interval orar</td>
 <td align="center">Denumire</td>
 <td align="center">Moderatori</td>
 <td align="center">Detalii</td>
 </tr>
 <tr>
 <td align="center"><input name="DataInterval1" type="text" id="DataInterval1"></td>
 <td align="center"><input name="Denumire1" type="text" id="Denumire1"></td>
 <td align="center"><input name="Moderatori1" type="text" id="Moderatori1"></td>
 <td align="center"><input name="Detalii1" type="text" id="Detalii1"></td>
 </tr>
 <tr>
 <td align="center"><input name="DataInterval2" type="text" id="DataInterval2"></td>
 <td align="center"><input name="Denumire2" type="text" id="Denumire2"></td>
 <td align="center"><input name="Moderatori2" type="text" id="Moderatori2"></td>
 <td align="center"><input name="Detalii2" type="text" id="Detalii2"></td>
 </tr>
 ...
 <tr>
 <td align="center"><input name="DataIntervaln" type="text" id="DataIntervaln"></td>
 <td align="center"><input name="Denumiren" type="text" id="Denumiren"></td>
 <td align="center"><input name="Moderatorin" type="text" id="Moderatorin"></td>
 <td align="center"><input name="Detaliin" type="text" id="Detaliin"></td>
 </tr>
</table>

partPart of the phpPHP code that iI want to simplify:

$DataInterval1=$_POST['DataInterval1'];
$Denumire1=$_POST['Denumire1'];
$Moderatori1=$_POST['Moderatori1'];
$Detalii1=$_POST['Detalii1']; 
$DataInterval2=$_POST['DataInterval2'];
$Denumire2=$_POST['Denumire2'];
$Moderatori2=$_POST['Moderatori2'];
$Detalii2=$_POST['Detalii2'];
...
$DataIntervaln=$_POST['DataIntervaln'];
$Denumiren=$_POST['Denumiren'];
$Moderatorin=$_POST['Moderatorin'];
$Detaliin=$_POST['Detaliin']; 
// Insert data into mysql
$sql="INSERT INTO tabel (DataInterval, Denumire, Moderatori, Detalii)VALUES
('".$DataInterval1."', '".$Denumire1."', '".$Moderatori1."', '".$Detalii1."'),
('".$DataInterval2."', '".$Denumire2."', '".$Moderatori2."', '".$Detalii2."'),
... 
('".$DataIntervaln."', '".$Denumiren."', '".$Moderatorin."', '".$Detaliin."')";
$result=mysql_query($sql);

simplify mysql INSERT query

Is there a way to simplify the codes below? I have the codes below and i want to simplify them but i don't know if it is possible.

In the table below i insert data which will end-up in a mysql table.

html

<table border="0">
 <tr>
 <td align="center">Dată / Interval orar</td>
 <td align="center">Denumire</td>
 <td align="center">Moderatori</td>
 <td align="center">Detalii</td>
 </tr>
 <tr>
 <td align="center"><input name="DataInterval1" type="text" id="DataInterval1"></td>
 <td align="center"><input name="Denumire1" type="text" id="Denumire1"></td>
 <td align="center"><input name="Moderatori1" type="text" id="Moderatori1"></td>
 <td align="center"><input name="Detalii1" type="text" id="Detalii1"></td>
 </tr>
 <tr>
 <td align="center"><input name="DataInterval2" type="text" id="DataInterval2"></td>
 <td align="center"><input name="Denumire2" type="text" id="Denumire2"></td>
 <td align="center"><input name="Moderatori2" type="text" id="Moderatori2"></td>
 <td align="center"><input name="Detalii2" type="text" id="Detalii2"></td>
 </tr>
 ...
 <tr>
 <td align="center"><input name="DataIntervaln" type="text" id="DataIntervaln"></td>
 <td align="center"><input name="Denumiren" type="text" id="Denumiren"></td>
 <td align="center"><input name="Moderatorin" type="text" id="Moderatorin"></td>
 <td align="center"><input name="Detaliin" type="text" id="Detaliin"></td>
 </tr>
</table>

part of the php code that i want to simplify

$DataInterval1=$_POST['DataInterval1'];
$Denumire1=$_POST['Denumire1'];
$Moderatori1=$_POST['Moderatori1'];
$Detalii1=$_POST['Detalii1']; 
$DataInterval2=$_POST['DataInterval2'];
$Denumire2=$_POST['Denumire2'];
$Moderatori2=$_POST['Moderatori2'];
$Detalii2=$_POST['Detalii2'];
...
$DataIntervaln=$_POST['DataIntervaln'];
$Denumiren=$_POST['Denumiren'];
$Moderatorin=$_POST['Moderatorin'];
$Detaliin=$_POST['Detaliin']; 
// Insert data into mysql
$sql="INSERT INTO tabel (DataInterval, Denumire, Moderatori, Detalii)VALUES
('".$DataInterval1."', '".$Denumire1."', '".$Moderatori1."', '".$Detalii1."'),
('".$DataInterval2."', '".$Denumire2."', '".$Moderatori2."', '".$Detalii2."'),
... 
('".$DataIntervaln."', '".$Denumiren."', '".$Moderatorin."', '".$Detaliin."')";
$result=mysql_query($sql);

Simplify MySQL INSERT query

Is there a way to simplify the code below? I want to simplify it, but I don't know if it is possible.

In the table below, I insert data which will end up in a MySQL table.

HTML

<table border="0">
 <tr>
 <td align="center">Dată / Interval orar</td>
 <td align="center">Denumire</td>
 <td align="center">Moderatori</td>
 <td align="center">Detalii</td>
 </tr>
 <tr>
 <td align="center"><input name="DataInterval1" type="text" id="DataInterval1"></td>
 <td align="center"><input name="Denumire1" type="text" id="Denumire1"></td>
 <td align="center"><input name="Moderatori1" type="text" id="Moderatori1"></td>
 <td align="center"><input name="Detalii1" type="text" id="Detalii1"></td>
 </tr>
 <tr>
 <td align="center"><input name="DataInterval2" type="text" id="DataInterval2"></td>
 <td align="center"><input name="Denumire2" type="text" id="Denumire2"></td>
 <td align="center"><input name="Moderatori2" type="text" id="Moderatori2"></td>
 <td align="center"><input name="Detalii2" type="text" id="Detalii2"></td>
 </tr>
 ...
 <tr>
 <td align="center"><input name="DataIntervaln" type="text" id="DataIntervaln"></td>
 <td align="center"><input name="Denumiren" type="text" id="Denumiren"></td>
 <td align="center"><input name="Moderatorin" type="text" id="Moderatorin"></td>
 <td align="center"><input name="Detaliin" type="text" id="Detaliin"></td>
 </tr>
</table>

Part of the PHP code that I want to simplify:

$DataInterval1=$_POST['DataInterval1'];
$Denumire1=$_POST['Denumire1'];
$Moderatori1=$_POST['Moderatori1'];
$Detalii1=$_POST['Detalii1']; 
$DataInterval2=$_POST['DataInterval2'];
$Denumire2=$_POST['Denumire2'];
$Moderatori2=$_POST['Moderatori2'];
$Detalii2=$_POST['Detalii2'];
...
$DataIntervaln=$_POST['DataIntervaln'];
$Denumiren=$_POST['Denumiren'];
$Moderatorin=$_POST['Moderatorin'];
$Detaliin=$_POST['Detaliin']; 
// Insert data into mysql
$sql="INSERT INTO tabel (DataInterval, Denumire, Moderatori, Detalii)VALUES
('".$DataInterval1."', '".$Denumire1."', '".$Moderatori1."', '".$Detalii1."'),
('".$DataInterval2."', '".$Denumire2."', '".$Moderatori2."', '".$Detalii2."'),
... 
('".$DataIntervaln."', '".$Denumiren."', '".$Moderatorin."', '".$Detaliin."')";
$result=mysql_query($sql);
Source Link

simplify mysql INSERT query

Is there a way to simplify the codes below? I have the codes below and i want to simplify them but i don't know if it is possible.

In the table below i insert data which will end-up in a mysql table.

html

<table border="0">
 <tr>
 <td align="center">Dată / Interval orar</td>
 <td align="center">Denumire</td>
 <td align="center">Moderatori</td>
 <td align="center">Detalii</td>
 </tr>
 <tr>
 <td align="center"><input name="DataInterval1" type="text" id="DataInterval1"></td>
 <td align="center"><input name="Denumire1" type="text" id="Denumire1"></td>
 <td align="center"><input name="Moderatori1" type="text" id="Moderatori1"></td>
 <td align="center"><input name="Detalii1" type="text" id="Detalii1"></td>
 </tr>
 <tr>
 <td align="center"><input name="DataInterval2" type="text" id="DataInterval2"></td>
 <td align="center"><input name="Denumire2" type="text" id="Denumire2"></td>
 <td align="center"><input name="Moderatori2" type="text" id="Moderatori2"></td>
 <td align="center"><input name="Detalii2" type="text" id="Detalii2"></td>
 </tr>
 ...
 <tr>
 <td align="center"><input name="DataIntervaln" type="text" id="DataIntervaln"></td>
 <td align="center"><input name="Denumiren" type="text" id="Denumiren"></td>
 <td align="center"><input name="Moderatorin" type="text" id="Moderatorin"></td>
 <td align="center"><input name="Detaliin" type="text" id="Detaliin"></td>
 </tr>
</table>

part of the php code that i want to simplify

$DataInterval1=$_POST['DataInterval1'];
$Denumire1=$_POST['Denumire1'];
$Moderatori1=$_POST['Moderatori1'];
$Detalii1=$_POST['Detalii1']; 
$DataInterval2=$_POST['DataInterval2'];
$Denumire2=$_POST['Denumire2'];
$Moderatori2=$_POST['Moderatori2'];
$Detalii2=$_POST['Detalii2'];
...
$DataIntervaln=$_POST['DataIntervaln'];
$Denumiren=$_POST['Denumiren'];
$Moderatorin=$_POST['Moderatorin'];
$Detaliin=$_POST['Detaliin']; 
// Insert data into mysql
$sql="INSERT INTO tabel (DataInterval, Denumire, Moderatori, Detalii)VALUES
('".$DataInterval1."', '".$Denumire1."', '".$Moderatori1."', '".$Detalii1."'),
('".$DataInterval2."', '".$Denumire2."', '".$Moderatori2."', '".$Detalii2."'),
... 
('".$DataIntervaln."', '".$Denumiren."', '".$Moderatorin."', '".$Detaliin."')";
$result=mysql_query($sql);
default

AltStyle によって変換されたページ (->オリジナル) /