Detect www and @ string/CSV2HTML

Hexen

Hi, I’m new on the board and thank you for stop here.

I have a code that use a CSV as a database the PHP script generate a html page from this CSV file but I want that this script detect the presence of a www/@ string and covert all the word on hyperlink/mailto, but I don't have a clue how to Automatically parse URLs around internet addresses + email addresses

Thank you on advance

<head>
<style type="text/css">
table {
  font-family: arial, sans-serif;
  font-size: smaller;
  border-collapse: collapse;
  border: solid black thin;
}
th,td {
  margin: 0;
  padding: 3px;
  border: solid black thin;
}
th {
  font-weight: bold;
  text-align: center;
}
.Odd {
  background-color: #CCCCCC;
}
.Even {
  background-color: #FFFFFF;
}
</style>
</head>

<body>
<?php

$sOutput = '<table>';

$fp = fopen("test2.csv", "r");
$aCSV = fgetcsv($fp, 1000, ";");
$iColumns = count($aCSV);

# column headers from 1st row of CSV:
$sOutput .= '<tr><th>' . implode('</th><th>', $aCSV) . '</th></tr>';

# data rows:
$iRow = 1;
while (($aCSV = fgetcsv($fp, 1000, ";")) !== FALSE)
{
  if (isset($aCSV[$iColumns - 1]))
      {
      $sJPG = $aCSV[$iColumns - 1];
      unset($aCSV[$iColumns - 1]);
      }
  else
       $sJPG = '';
  $sOutput .= '<tr class="' . (($iRow++ % 2 === 0) ? 'Even':'Odd') . '"><td>' . implode('</td><td>', $aCSV) . '</td><td>' . ((strlen($sJPG) > 0) ? '<img src="./' . $sJPG . '">':'') . '</td></tr>';
}
$sOutput .= '</table>';

echo str_replace('><', ">\n<", $sOutput);
?>
</body>
</html>

biggus

I looked at your files and what I've done in the past is to know how many fields are in the csv file and check to see if the field which would have an email address is not empty. If it isn't empty, then check for valid data and build an email link with it. (maybe not the best solution, but it woks)

HTH

Hexen

Hi Biggus

Is a good Idea but how Ican achieve this? Im a newbie on PHP 😕
Can you help me please ?

I don't know if I can create a column only for the email adresses and convert all on this column on mailto links? :bemused:

biggus

if I recall correctly, the 4th field in your CSV is the email address, so $aCSV[3] will contain the email address (if it contains any data). Then, just to make sure, look with strstr() for an @. If it has one, then we'll assume it's an email address, then do the following to print the email link:

if(strstr($aCSV[3],"@")){
    $email= "<a href='mailto:".$aCSV[3]."'>".$aCSV[3]."</a>";
}else{
    $email="";
}

Then just put $email in the TD in your while loop. If you want a more robust solution, you can always find an email validation function here in the forum somewhere (or on php.net) to make sure $aCSV[3] is a valid email address.

Biggus

Hexen

I will try this script, Thank you ! 😃

Hexen

Dosen't work, sorry I was playing with this but dosen't work eider can you give a hand please?

http://ch2.php.net/ereg

<?php

  function detectEmail($email)
  {
    return ereg("^[a-zA-Z]+@[a-zA-Z]+\.[a-zA-Z]+$", $email);


  echo $email("<a href='mailto:"^[a-zA-Z]+@[a-zA-Z]+\.[a-zA-Z]+$"'>""</a>");}

?>