PHP - Splitting Mysql Results?

Hello - hoping to find some direction with this. I think this is fairly simple for more experienced php coders but I'm having trouble with it. It's a php grep text string search that results in a list of files that contain the string.   Hoping to split the $results value (list of file names) into separate links to open the file. I was able to convert into a link for the first file listed, but it links to that same file for all the entries in the list. I assume that maybe an array of  $results needs to be created first rather than try and work with  $results at the end?

<?php

/**
* E.Yekta
* cafewebmaster.com
*/     

	define("SLASH", stristr($_SERVER[SERVER_SOFTWARE], "win") ? "\\" : "/");          

	$path    = ($_POST[path]) ? $_POST[path] : dirname(__FILE__) ;     
	$q        = $_POST[q];          

	function php_grep($q, $path){                  

		$fp = opendir($path);         
		while($f = readdir($fp)){             
			if( preg_match("#^\.+$#", $f) ) continue; // ignore symbolic links             
			$file_full_path = $path.SLASH.$f;             
			if(is_dir($file_full_path)) {                 
				$ret .= php_grep($q, $file_full_path);             
			} else if( stristr(file_get_contents($file_full_path), $q) ) {                 
				$ret .= "$file_full_path\n";             
			}         
		}         
		return $ret;     
	}     

	if($q){         
		$results = php_grep($q, $path);     
	}               



	echo <<<HRD     
	<pre >     
	<form method=post>         
		<input name=path size=100 value="$path" /> Path         
		<input name=q size=100 value="$q" /> Query         
		<input type=submit>     
	</form>              

		$results          

	</pre >     

HRD;

?> 

Attached Files  php_grep.php   908bytes   0 downloads

Basically I have a date of birth field (date) now how would I go about splitting that date field into 3 variables $year $month and $day?

Any small push forward is much appreciated, I have searched but it seems that I might not be putting it into words correctly.

Actually while writing this I suppose I might of thought of the solution
Code: [Select]
<?php

$year = date('Y', strtotime($row['dob']));
$month = date('m', strtotime($row['dob']));
$day = date('d', strtotime($row['dob']));
?>

Would that be how you would go about it?

Hello,

This is query in MySQL

Quote

mysql> LOAD DATA LOCAL INFILE '/var/www/html/numbers.csv' INTO TABLE details FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (number);
Query OK, 0 rows affected (0.00 sec)
Records: 2200 Deleted: 0 Skipped: 1200 Warnings: 0

Now, I am trying to run the same query in PHP and display the same results.... (i.e. Records, Deleted, Skipped)
Quote

<?php
$db=mysql_connect("localhost", "user", "1234") or die(mysql_error());
$dname="database";
mysql_select_db($dname)or die(mysql_error());
$sqlstatement="LOAD DATA LOCAL INFILE '/var/www/html/numbers.csv' INTO TABLE details FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (number)" ;
mysql_query($sqlstatement) or die(mysql_error());;
echo "it is done!";
?>


Tried mysql_fetch_array, row but could not get it to work... please help guys

What's the best way to format results from a MySQL table?  I've found very vague examples of PHP code utilizing html tables.  Below is my current PHP.  Thanks!

<?php
$con = mysql_connect("localhost","xxxxx","xxxxx") or die('Could not connect: ' . mysql_error());
mysql_select_db("addresses", $con);

$result = mysql_query("SELECT * FROM addresses");

while($row = mysql_fetch_array($result))
  {
  echo $row['first_name'] . " " . $row['last_name'] . " " . $row['extra_info'] . " " . $row['address'] . " " . $row['city'] . " " . $row['state'] . " " . $row['zip'];
  echo "<br />";
  }

mysql_close($con);
?>

I'm working on a website that uses a database to display the employees from different states. Below is the code I'm using and everything works great, but I can't figure out why all the results are getting posted twice. I'm trying to isolate just one state so we can have a different contact page for each state. Thanks for any help! Please let me know if you need more information. (I'm attaching a screenshot of what's happening as well.)


Code: [Select]
<?
include "public/public_common.php";
//Open Database Connection
$db = open_db_connection();
$sql = "SELECT DISTINCT state_full = 'california' from users where active = 'Y' and show_on_contactus = 'Y'";
$results = mysql_query($sql, $db);
if(!mysql_num_rows($results) == FALSE)
{
        while($row = mysql_fetch_array($results, MYSQL_BOTH))
        {
           echo "<ul id=\"directors\">\n";
           $state_sql = "SELECT * from users where active = 'Y' and show_on_contactus = 'Y' and state_full = 'california' order by last_name";
   $state_results = mysql_query($state_sql, $db);
           if(!mysql_num_rows($results) == FALSE)
           {
              while($state_row = mysql_fetch_array($state_results, MYSQL_BOTH))
              {
                 echo "<li>\n";
                 echo "   <div class=\"fl dirimg\">\n";
                 if($state_row[photo] == "")
                 {
                    echo "<img border=\"0\" width=\"61\" height=\"85\" src=\"images/exe_placeholder.jpg\" alt=\"$state_row[first_name] $state_row[last_name]\" />\n";
                 }
                 else
                 {
                    echo "<img border=\"0\" width=\"61\" height=\"85\" src=\"n2team/pictures/$state_row[photo]\" alt=\"$state_row[firstname] $state_row[last_name]\" />\n";
                 }
                 echo "   </div>\n";
                 echo "   <span class=\"fr\">$state_row[first_name] $state_row[last_name]<br />\n";
                 echo "       $state_row[title]<br />\n";
                 echo "       $state_row[city], $state_row[state]<br />\n";
                 //echo "       <a href=\"mailto:$state_row[email]\">$state_row[email]</a></span></li>\n";
              }
           }
           echo "</ul>\n";
        }
}
?>