<?php require_once('Connections/connect.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_connect, $connect);
$query_person = "SELECT * FROM person WHERE id=8";
$person = mysql_query($query_person, $connect) or die(mysql_error());
$row_person = mysql_fetch_assoc($person);
$totalRows_person = mysql_num_rows($person);
@header("Cache-Control: ");// leave blank to avoid IE errors
@header("Pragma: ");// leave blank to avoid IE errors
@header("Content-Description: File Transfer");
@header("Content-type: application/ms-word");
//header("Content-Disposition: attachment; filename=Report.doc");
@header("Content-Disposition: attachment; Filename=Report_".date('Ymd').".doc");
?>
<html>
<body>
<meta charset="utf-8">
<font size="5" face="TH SarabunPSK">
<div class="row">
<div class="col-md-12" align="center">
<img src="image/<?php echo $row_person['photo']; ?>" width="200" height="200">
</div>
</div>
<?php
mysql_free_result($person);
?>
</body>
</html>
php to word ภาพไม่มาครับ
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_connect, $connect);
$query_person = "SELECT * FROM person WHERE id=8";
$person = mysql_query($query_person, $connect) or die(mysql_error());
$row_person = mysql_fetch_assoc($person);
$totalRows_person = mysql_num_rows($person);
@header("Cache-Control: ");// leave blank to avoid IE errors
@header("Pragma: ");// leave blank to avoid IE errors
@header("Content-Description: File Transfer");
@header("Content-type: application/ms-word");
//header("Content-Disposition: attachment; filename=Report.doc");
@header("Content-Disposition: attachment; Filename=Report_".date('Ymd').".doc");
?>
<html>
<body>
<meta charset="utf-8">
<font size="5" face="TH SarabunPSK">
<div class="row">
<div class="col-md-12" align="center">
<img src="image/<?php echo $row_person['photo']; ?>" width="200" height="200">
</div>
</div>
<?php
mysql_free_result($person);
?>
</body>
</html>