fwrite and sql fields

beezZa

I am working on a resume builder site for a client. I am new to PHP/mySQL. The user enters in the information via forms that will be used to build a resume (all their contact info, professional profile, education history, work experience, etc). From the form the entries are stored in a sql database. What i need to know how to do is write the resume to a rtf file.

Obviously ill need to take the sql fields and fwrite() them to the rtf file. Is there a way to directly input the sql field name (example: first_name) into the fwrite command? Or do i have to declare that sql field as a $variable?

I hope that rambling made some sense to anyone. In a nutshell i need help calling up sql entries and putting them into a file.

Thanks in advance!

laserlight

In a nutshell i need help calling up sql entries and putting them into a file.

I suggest that you read the PHP manual on the PDO extension. There are examples given that can help you. Searching the Web should also bring up more articles and tutorials on how to use the PDO extension.

beezZa

this is what i have so far.

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<?php
$connection = mysql_connect('localhost', 'user', 'pass') or die('unable to connect');

mysql_select_db('dbhosts_downloadmyresume') or die('unable to select database') ;

$query = 'SELECT * FROM test_contact' ;
$result = mysql_query($query) or die('error in query: %query. ' . mysql_error()) ;

if (mysql_num_rows($result) > 0)
{
$file = '/home/dbhosts/public_html/resume/rtf.rtf' ;

$fh = fopen($file, 'w') or die('could not open file!') ;

 while($row = mysql_fetch_object($result))
 {	
    $first_name = $row->contactFname ;
	$last_name = $row->contactLname ; 
	$street = $row->contactStreet ;
	$city = $row->contactCity ;
	$state = $row->contactState ;
	$zip = $row->contactZip ;
	$phone = $row->contactPhone ;
	//This is where i need to enter the rtf mark up (this is where i need help)
	$contactinfo = ''.$first_name.' '.$last_name.' ';

	fwrite($fh, $contactinfo) or die('could not write to file!');

	fclose($fh);

}

}
else
{
echo 'no rows found' ;
}

mysql_free_result($result) ;

mysql_close($connection) ;

</body>
</html>

beezZa

also can anyone recommend an rtf editor? i use word 2007 and it adds all this extra stuff.

dougal85

WordPad can read RTF files