1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75
|
function getFormData( $date = '' , $link = 'db' ) {
global $$link;
// s'assure de la bonne date
if ( $date == '' ) $date = date( 'Y-m-d', time() );
elseif ( is_numeric( $date )) $date = date( 'Y-m-d', $date );
else $date = date( 'Y-m-d', strtottime( $date ) );
... // a faire connection etc..
$row = false;
$sql = "select id,form,title,name from joo_facileforms_records where submitted = '$date'";
$res = mysql_query( $sql , $$link ) ;
if ( mysql_num_rows( $res ) > 0 ) {
$row = mysql_fetch_array( $res );
mysql_free_result( $res );
}
return $row;
}
function getData( $formRecordId, $link = 'db' )
{ global $$link;
$data = false;
if ( $formId > 0 ) {
$sql = "select name,title,value from joo_facileforms_subrecords where record = $formRecordId";
$res = mysql_query( $sql, $$link );
if ( mysql_num_rows( $res ) > 0 ) {
$data = array();
while( $row = mysql_fetch_array( $res ) ) {
$data[ $row['name'] ] = array( 'title' => $row['title'], 'value' => $row['value'] );
}
}
}
return $data;
}
$db = mysql_connect( 'localhost', 'user', 'pass' ) or die( "prob de connection a la base " );
if ( mysql_select_db( 'mabase', $db ) )
{
$formData = getFormData( '2006-05-08' );
if ( $formData !== false )
{
$elmData = getData( $formData['id'] );
$title = "<table cellpadding=0 cellspacing=1 border=0 bgcolor=black width=100%>";
$title .= "<tr><td><h2>".$formData['title']."</h2></td></tr>";
$title .= "</table>";
echo $title;
if ( $elmData !== false ) {
$fieldNames = array_keys( $elmData );
$header = "<table cellpadding=0 cellspacing=1 border=0 bgcolor=black width=100%>";
// entete
$header .= "<tr>";
$content = "<tr>";
foreach( $fieldNames as $name => $value ) {
$header .= "<td bgcolor=#efefef> ".$value['title']." </td>";
$content .= "<td bgcolor=#efefef> ".$value['value']." </td>";
}
$header .= "</tr>";
$content .= "</tr>";
// data
$content .="<table>";
echo $header,$content;
}
else {
echo "pas de champs";
}
}
else {
echo "formulaire non trouvé";
}
} |
Partager