emailing contents of a database

[ukndoit]

I am trying to get the content's of a database and have it emailed to me, upon my filling out a form that will be behind a authenticated directory.

I am getting this result:

Array
Warning: mail() expects parameter 3 to be string, resource given in send.php on line 26

Here is the code:

$result = mysql_query('SELECT * FROM db1');
if (!$result) {
die('Could not query:' . mysql_error());
}
echo mysql_fetch_array ($result);

if (!$email) {
$email = "My Name<[e-mail]>";
}

$nrecipient = "[e-mail]";
$nsubject = 'Email Database';

$nheaders  = "From: $email\r\n";
$nheaders .= "CC: [email][e-mail][/email]\r\n";
$nheaders .= "Importance: high\r\n";
$nheaders .= "X-Priority: 1\r\n";
$nheaders .= "X-MSMail-Priority: High\r\n";
$nheaders .= "Organization: MyDomain.com\r\n";
$chk_sent = mail($nrecipient,$nsubject,$result,$nheaders);
if ($chk_sent) {
	print "<font color=\"black\">sent!\n";
} else {
	print "<font color=\"black\">not sent!\n";
}

The problem appears to be $result which it is saying that it needs to be a "STRING".

How can I do this, where it will send everything in the database in the email, in CSV format?

Thank you!
Rich

[cgraz]

The error is telling you that the problem is with the third parameter in your call to mail()

So the third parameter you call is $result.

it expects it to be a string and it's not. It's the variable for your mysql_query.

If you were to change it to say

$result = "Message text";

it would work. Just make that third parameter a string.

Cgraz

[Weedpacket]

[man]mysql_query[/man] as the manual states, returns a resource - it's just a handle so that PHP can hang on to the data MySQL has collected. There's no point trying to put it in an email because all it would say is something like "Resource #3". Printing the result of [man]mysql_fetch_array[/man] is also pretty pointless, as it's not a string either - it's an array and printing it will just get you "Array".

Instead, what you need to do is to go through the records contained in the resource, fetch each record into an array, format the contents of the array into a string, and put each of those strings in the email. For details and example code, see the above links to the manual.

'course, depending on what you want the database emailed for, a system call to mysql_dump could be used to get the entire database written in SQL, but it would be wise to get that first suggestion working first.

[sidney]

$datab="";
$result = mysql_query('SELECT * FROM test'); 
if (!$result) { 
die('Could not query:' . mysql_error()); 
}
$c=mysql_num_fields($result); 
$n=mysql_list_fields($database,test);
for ($i = 0; $i < $c; $i++) {
   $datab.= mysql_field_name($n, $i) . " - ";
}


$datab.= "\n";

while($row = mysql_fetch_array($result))
{
for($i=0;$i<$c;$i++)
{
$datab.=$row[$i]." - "; 
}
$datab.="\n";
}


if (!$email) { 
$email = "My Name<[e-mail]>"; 
} 

$nrecipient = "[e-mail]"; 
$nsubject = 'Email Database'; 

$nheaders = "From: $email\r\n"; 
$nheaders .= "CC: [email][e-mail][/email]\r\n"; 
$nheaders .= "Importance: high\r\n"; 
$nheaders .= "X-Priority: 1\r\n"; 
$nheaders .= "X-MSMail-Priority: High\r\n"; 
$nheaders .= "Organization: MyDomain.com\r\n"; 
$chk_sent = mail($nrecipient,$nsubject,$datab,$nheaders); 
if ($chk_sent) { 
print "<font color=\"black\">sent!\n"; 
} else { 
print "<font color=\"black\">not sent!\n"; 
} 
  

[ukndoit]

Originally posted by sidney

$datab="";
$result = mysql_query('SELECT * FROM test'); 
if (!$result) { 
die('Could not query:' . mysql_error()); 
}
$c=mysql_num_fields($result); 
$n=mysql_list_fields($database,test);
for ($i = 0; $i < $c; $i++) {
   $datab.= mysql_field_name($n, $i) . " - ";
}


$datab.= "\n";

while($row = mysql_fetch_array($result))
{
for($i=0;$i<$c;$i++)
{
$datab.=$row[$i]." - "; 
}
$datab.="\n";
}


if (!$email) { 
$email = "My Name<[e-mail]>"; 
} 

$nrecipient = "[e-mail]"; 
$nsubject = 'Email Database'; 

$nheaders = "From: $email\r\n"; 
$nheaders .= "CC: [email][e-mail][/email]\r\n"; 
$nheaders .= "Importance: high\r\n"; 
$nheaders .= "X-Priority: 1\r\n"; 
$nheaders .= "X-MSMail-Priority: High\r\n"; 
$nheaders .= "Organization: MyDomain.com\r\n"; 
$chk_sent = mail($nrecipient,$nsubject,$datab,$nheaders); 
if ($chk_sent) { 
print "<font color=\"black\">sent!\n"; 
} else { 
print "<font color=\"black\">not sent!\n"; 
} 
  

[/B]

Thank you!
Where did these fields come from?
$database,test

in this line:
$n=mysql_list_fields($database,test);

Thank you much!!
Rich

[sidney]

that is to grab the field names $database is the data base name
and test is table name