How to insert this data to mysql database

I added into table. but i need to ad this data to database

<?php
$url = "http://xxx.com/xxx.php";

$FileContent = file_get_contents($url);

$SplitContent = explode("\n", $FileContent);

 
foreach($SplitContent as $CurrValue)
{      
  echo "<tr>";
  
  $SplitData = explode("\t", $CurrValue);
  foreach($SplitData as $DataValue){
  echo "<td>".$DataValue."</td>";
  }
  
  echo "</tr>";
}

?>

PHP:

 

do u want to add this PHP data into database ?

 

yes. i want that data into to the database.

 

www.tizag.com/mysqlTutorial/mysqlinsert.php

It will be helpfull

Regards

Alex

 

use htmlspecialchars() function to add into database

<?php 

$txt = '
<?php
$url = "http://xxx.com/xxx.php";

$FileContent = file_get_contents($url);

$SplitContent = explode("\n", $FileContent);

 
foreach($SplitContent as $CurrValue)
{      
  echo "<tr>";
 
  $SplitData = explode("\t", $CurrValue);
  foreach($SplitData as $DataValue){
  echo "<td>".$DataValue."</td>";
  }
 
  echo "</tr>";
}

?>
';


$strin = htmlspecialchars($txt);

?>

PHP:

 

Yes brother. i knw that.
but this problem is arrays into the database

 

INSERT INTO table_name (column_name) VALUES ($string);

 

how many fields you have

http://snippets.dzone.com/posts/show/4350

good example

Regards

Alex

 

have 12 fields.

 

<?php
$url = "http://xxx.com/xxx.php";

$FileContent = file_get_contents($url);

$SplitContent = explode("\n", $FileContent);

 
foreach($SplitContent as $CurrValue)
{      
  echo "<tr>";
 
  $SplitData = explode("\t", $CurrValue);
  foreach($SplitData as $DataValue){
  echo "<td>".$DataValue."</td>";
  mysql_query("INSERT INTO table ('columnname') VALUES ('$DataValue')");
  }
 
  echo "</tr>";
}

?>

PHP: