Récuperation variable

**gator** · 01/12/2010, 14h24

Bonjour,

J'ai un document template .doc, dans lequel j'ai placé des variables de style %%MONNOM%% que je remplace par des éléments sortis d'une base de données.

En statique, aucun problème.

En dynamique, voici mon problème:

Quand je mets:

'fullname' => 'le nom que je veux',
Cela m'affiche bien les infos notées, no problem

Quand je mets:

'fullname' => 'element_19_2',

cela va m’afficher dans mon document une fois ouvert element_19_2, je ne récupères pas la valeur !

Quand je mets: 'fullname' => $element_19_2 , Cela ne m'affiches rien du tout !

Quelqu'un aurai-il Une piste ?

Merci

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
<?php
/******************************************************************************/
/******************************************************************************/
	session_start();
 
	require('config.php');
	require('includes/check-session.php');
	require('includes/db-core.php');
	require('includes/db-functions.php');
	require('includes/helper-functions.php');
	require('includes/entry-functions.php');
 
	connect_db();
 
	$form_id  = (int) trim($_REQUEST['form_id']);
	$entry_id = (int) trim($_REQUEST['id']);
 
	if(empty($form_id) || empty($entry_id)){
			die('ID required.');
	}
 
 
	//check for delete parameter
	if(!empty($_GET['delete'])){
 
		delete_entries($form_id,array($entry_id));
 
		$_SESSION['AP_SUCCESS']['title'] = 'Entry deleted';
		$_SESSION['AP_SUCCESS']['desc']  = "Entry #{$entry_id} has been deleted.";
 
		$ssl_suffix = get_ssl_suffix();	
		header("Location: http{$ssl_suffix}://".$_SERVER['HTTP_HOST'].get_dirname($_SERVER['PHP_SELF'])."/manage_entries.php?id={$form_id}");
		exit;
	}
 
/******************************************************************************/
/******************************************************************************/
 
$query = "select form_name from `ap_forms` where form_id='$form_id'";
	$result = do_query($query);
	$row = do_fetch_result($result);
	$form_name = $row['form_name'];
 
	$entry_details = get_entry_details($form_id,$entry_id);
 
	//get entry timestamp
	$query = "select * from `ap_form_{$form_id}` where id='$entry_id'";	
    $result = mysql_query($query);
 
 
function populate_RTF($vars, $doc_file) {
 
        $replacements = array ('\\' => "\\\\",
                               '{'  => "\{",
                               '}'  => "\}");
 
        $document = file_get_contents($doc_file);
        if(!$document) {
            return false;
        }
 
        foreach($vars as $key=>$value) {
            $search = "%%".strtoupper($key)."%%";
 
            foreach($replacements as $orig => $replace) {
                $value = str_replace($orig, $replace, $value);
            }
 
            $document = str_replace($search, $value, $document);
        }
 
        return $document;
    }
 
$deadline = mktime(0,0,0,date('m'),date('d')+14, date('Y'));
 
$vars = array(
'id' => $id,
'date_created' => $date_created,
'date_updated' => $date_updated,
'ip_address' => $ip_address,
'preferedchoice1' => $element_12,
'preferedchoice2' => $element_13,
'element_17_1' => $element_17_1,
'element_17_2' => $element_17_2,
'element_17_3' => $element_17_3,
'firstname' => $element_18_1,
'lastname' => $element_18_2,
'address' => $element_19_1,
'element_19_2' => $element_19_2,
'city' => $element_19_3,
'state' => $element_19_4,
'zip' => $element_19_5,
'country' => $element_19_6,
'preferedchoice3' => $element_24 );
 
 
 $vars = array(   'date'     => date("F d, Y"),
                  'fullname' => 'john',
                  'address'  => '1210 Hancock',
                  'cityinfo' => 'Flint, MI 49449',
                  'prefix'   => 'Mr.',
                  'lastname' => 'Coggeshall',
                  'jobtitle' => 'PHP Developer',
                  'wage'     => '$5,000',
                  'location' => 'Somewhere, MI',
                  'responddate' => date('F, d, Y', $deadline));
 
 
 
$new_rtf = populate_RTF($vars, "mondocument.rtf");
 
    $fr = fopen('output.rtf', 'w') ;
 
    fwrite($fr, $new_rtf);
 
    fclose($fr);
 
	header("Content-type: application/msword");
    header("Content-disposition: inline;filename=Reservation_of_name_of_company.rtf");
    header("Content-length: " . strlen($new_rtf));
    echo $new_rtf;
 
?>

**Celira** · 01/12/2010, 18h16

Question bête : où et quand renseignes-tu les variables $element_xxx ?

**andry.aime** · 01/12/2010, 18h19

Bonsoir,

Je ne comprend pas bien ton soucis mais tu redéclares la variables $vars qui va écraser la première.

A+.

**gator** · 01/12/2010, 19h20

J'ai modifié le code, plus rien !

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
<?php
/******************************************************************************/
/******************************************************************************/
	session_start();
 
	require('config.php');
	require('includes/check-session.php');
	require('includes/db-core.php');
	require('includes/db-functions.php');
	require('includes/helper-functions.php');
	require('includes/entry-functions.php');
 
	connect_db();
 
	$form_id  = (int) trim($_REQUEST['form_id']);
	$entry_id = (int) trim($_REQUEST['id']);
 
	if(empty($form_id) || empty($entry_id)){
			die('ID required.');
	}
 
 
	//check for delete parameter
	if(!empty($_GET['delete'])){
 
		delete_entries($form_id,array($entry_id));
 
		$_SESSION['AP_SUCCESS']['title'] = 'Entry deleted';
		$_SESSION['AP_SUCCESS']['desc']  = "Entry #{$entry_id} has been deleted.";
 
		$ssl_suffix = get_ssl_suffix();	
		header("Location: http{$ssl_suffix}://".$_SERVER['HTTP_HOST'].get_dirname($_SERVER['PHP_SELF'])."/manage_entries.php?id={$form_id}");
		exit;
	}
 
/******************************************************************************/
/******************************************************************************/
 
$query = "select form_name from `ap_forms` where form_id='$form_id'";
	$result = do_query($query);
	$row = do_fetch_result($result);
	$form_name = $row['form_name'];
 
	$entry_details = get_entry_details($form_id,$entry_id);
 
	//get entry timestamp
	$query = "select * from `ap_form_{$form_id}` where id='$entry_id'";	
    $result = mysql_query($query);
 
 
function populate_RTF($vars, $doc_file) {
 
        $replacements = array ('\\' => "\\\\",
                               '{'  => "\{",
                               '}'  => "\}");
 
        $document = file_get_contents($doc_file);
        if(!$document) {
            return false;
        }
 
        foreach($vars as $key=>$value) {
            $search = "%%".strtoupper($key)."%%";
 
            foreach($replacements as $orig => $replace) {
                $value = str_replace($orig, $replace, $value);
            }
 
            $document = str_replace($search, $value, $document);
        }
 
        return $document;
    }
 
 
$vars = array(
$vars['date_created'] = "date_created"; 
$vars['date_updated'] = "date_updated"; 
$vars['ip_address'] = "ip_address"; 
$vars['element_12'] = "element_12"; 
$vars['element_13'] = "element_13"; 
$vars['element_17_1'] = "element_17_1"; 
$vars['element_17_2'] = "element_17_2"; 
$vars['element_17_3'] = "element_17_3"; 
$vars['element_18_1'] = "element_18_1";
$vars['element_18_2'] = "element_18_2";
$vars['element_19_1'] = "element_19_1"; 
$vars['element_19_2'] = "element_19_2"; 
$vars['element_19_3'] = "element_19_3"; 
$vars['element_19_4'] = "element_19_4"; 
$vars['element_19_5'] = "element_19_5"; 
$vars['element_19_6'] = "element_19_6"; 
$vars['element_24'] = "element_24";
); 
 
 
$new_rtf = populate_RTF($vars, "mondocument.rtf");
 
    $fr = fopen('output.rtf', 'w') ;
 
    fwrite($fr, $new_rtf);
 
    fclose($fr);
 
	header("Content-type: application/msword");
    header("Content-disposition: inline;filename=mondocument.rtf");
    header("Content-length: " . strlen($new_rtf));
    echo $new_rtf;
 
?>

**Joker-eph** · 01/12/2010, 21h51

Envoyé par gator

J'ai modifié le code, plus rien !

Si tu activais l'affichage des erreurs dans ton php.ini tu te rendrais compte que tu as une erreur de syntaxe : les éléments d'un tableau sont séparés par des virgules et non des points virgules.

Sinon pour moi ton code ne va rien remplacer du tout, ou plus remplacer chaque clé de var par la valeur associée, mais là c'est la même...

**gator** · 02/12/2010, 23h53

Bonjour, et merci . J'ai ré-ecris le code suivant, je genere bien le rtf, mais j'ai un probléme, je n epeux pas par exemple afficher la derniere valeur de mon array et apprement les underscores dans les noms de variable me pose probleme !!

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
<?php
/******************************************************************************/
	session_start();
 error_reporting(E_ALL);
	require('config.php');
	require('includes/check-session.php');
	require('includes/db-core.php');
	require('includes/db-functions.php');
	require('includes/helper-functions.php');
	require('includes/entry-functions.php');
 
	connect_db();
 
	$form_id  = (int) trim($_REQUEST['form_id']);
	$entry_id = (int) trim($_REQUEST['id']);
 
	if(empty($form_id) || empty($entry_id)){
			die('ID required.');
	}
 
 
	//check for delete parameter
	if(!empty($_GET['delete'])){
 
		delete_entries($form_id,array($entry_id));
 
		$_SESSION['AP_SUCCESS']['title'] = 'Entry deleted';
		$_SESSION['AP_SUCCESS']['desc']  = "Entry #{$entry_id} has been deleted.";
 
		$ssl_suffix = get_ssl_suffix();	
		header("Location: http{$ssl_suffix}://".$_SERVER['HTTP_HOST'].get_dirname($_SERVER['PHP_SELF'])."/manage_entries.php?id={$form_id}");
		exit;
	}
 
 
    function populate_RTF($vars, $doc_file) {
 
        $replacements = array ('\\' => "\\\\",
                               '{'  => "\{",
                               '}'  => "\}");
 
        $document = file_get_contents($doc_file);
        if(!$document) {
            return false;
        }
 
        foreach($vars as $key=>$value) {
            $search = "%%".strtoupper($key)."%%";
 
            foreach($replacements as $orig => $replace) {
                $value = str_replace($orig, $replace, $value);
            }
 
            $document = str_replace($search, $value, $document);
        }
 
        return $document;
    }
 
 	$query = "select * from `ap_form_{$form_id}` where id='$entry_id'";
	$result = mysql_query($query);
 
 
while($row = mysql_fetch_row($result)){
$id = $row[0];
$date_created = $row[1];
$date_updated = $row[2];
$ip_address  = $row[3];
$element_12 = $row[4];
$element_13 = $row[5];
$element_17_1 = $row[6];
$element_17_2 = $row[7];
$element_17_3 = $row[8];
$element_18_1 = $row[9];
$element_18_2 = $row[10];
$element_19_1 = $row[11];
$element_19_2 = $row[12];
$element_19_3 = $row[13];
$element_19_4 = $row[14];
$element_19_5  = $row[15];
$element_19_6 = $row[16];
$element_24 = $row[17];
$element_18_1 = $row[18];
$element_18_2 = $row[19];
$element_19_1 = $row[20];
$element_24 = $row[21];
}
 
 
$deadline = mktime(0,0,0,date('m'),date('d')+14, date('Y'));
 
$vars = array('DATE' => date("F d, Y"),
                  'FULLNAME' => $date_created,
                  'FULLADDRESS'  => $ip_address,
                  'PREFEREDCHOICE1' => $element_12,
				  'PREFEREDCHOICE2' => $element_13,
				  'PREFEREDCHOICE3' => $element_12,
				  'RESPONDDATE' => date("F d, Y"),
                  'MCNAME' => 'blabla',
                  'MCADDRESS'     => '45 Rue des tests',
                  'MCCITY' => '45 Rue des tests',
                  'MCZIP' => '75000',);
 
    $new_rtf = populate_RTF($vars, "mondocument.rtf");
    $fr = fopen('output.rtf', 'w') ;
    fwrite($fr, $new_rtf);
    fclose($fr);
	header("Content-type: application/msword");
    header("Content-disposition: inline;filename=mondocument.rtf");
    header("Content-length: " . strlen($new_rtf));
    echo $new_rtf;
 
 
?>

Une idée par hasard ?