[RESOLVED] Vertical text (column heads) for Mozilla, Firefox and Mac browsers...dirt simple

Joseph_Sliker

After weeks of working out a way to do this in jpgraph, I started to wonder if I could figure out how to do this directly by just using GD in php.

I call this file "_func_gd_create_vcol.php" and include it where needed.

<?php
//$col_key="I am a vertical column head. "; //uncomment to test file
$filename2="$col_key.jpg";
if(file_exists($filename2)) {} else {
//new image creation section
$chtrs=strlen($col_key);
$width=(9*$chtrs);
$im=imagecreate($width, 16); // width, height
$navy=imagecolorallocate($im, 0,0,128 ); //use this same color for the <th>background so it will blend in
$white=imagecolorallocate($im, 255, 255, 255 );
imagestring($im,5,1,0,"$col_key",$white); //You can replace the "5" with a reference to a specific font...but I'm not clear on how to do that yet.
imagejpeg($im, 'temp.jpg');
//Now rotate the correctly formed and cropped image.
$source=imagecreatefromjpeg('temp.jpg'); //load
$degrees=90;
//IMAGEROTATE NOT IMPLEMENTED ON MY SERVER
if(!function_exists("imagerotate")) {include('_func_imagerotate.php');}
$rotate = imagerotate($source, $degrees, 0); //rotate
imagejpeg($rotate, $filename2); //save the image for future use.
} //end the test for the existance of the file
//echo "<img src=\"$filename2\">"; //uncomment to test script. View the image that was created
?>

...it works!

PS. JpGraph still rocks!

Joseph_Sliker

the function imagerotate is not enabled on the server I am using for some reason.

If you find yourself in the same situation here is the include script that I refer to in the previous posting.

_func_imagerotate.php

<?
// substitue code from achilles on php.net THANK YOU!
//if(!function_exists("imagerotate")) {
function imagerotate($source, $degrees) {
$src_x = imagesx($source);
$src_y = imagesy($source);
if ($degrees == 180) {
$dest_x = $src_x;
$dest_y = $src_y; }
elseif ($src_x <= $src_y) {
$dest_x = $src_y;
$dest_y = $src_x; }
elseif ($src_x >= $src_y) {
$dest_x = $src_y;
$dest_y = $src_x; }
$rotate=imagecreatetruecolor($dest_x,$dest_y);
imagealphablending($rotate, false);
switch ($degrees) {
case 270:
for ($y = 0; $y < ($src_y); $y++) {
for ($x = 0; $x < ($src_x); $x++) {
$color = imagecolorat($source, $x, $y);
imagesetpixel($rotate, $dest_x - $y - 1, $x, $color); }}
break;
case 90:
for ($y = 0; $y < ($src_y); $y++) {
for ($x = 0; $x < ($src_x); $x++) {
$color = imagecolorat($source, $x, $y);
imagesetpixel($rotate, $y, $dest_y - $x - 1, $color); }}
break;
case 180:
for ($y = 0; $y < ($src_y); $y++) {
for ($x = 0; $x < ($src_x); $x++) {
$color = imagecolorat($source, $x, $y);
imagesetpixel($rotate, $dest_x - $x - 1, $dest_y - $y - 1, $color); }}
break;
default: $rotate = $source; }
return $rotate; }
//}
///end code from achilles on php.net THANK YOU!
?>

(You could probably pare this down to the minimum code required to rotate the image 90 degrees and just add it to the first script.)

Joseph_Sliker

_testtable_gd.php

<head>
<title>___ Public Schools Problem Solving Initiative</title>
<STYLE TYPE="text/css"> 
<?
//Among other things I set the <th> background color as navy
php include("../_style1.css");
 ?>
</STYLE>
</head>
<body  style="font-family: Arial; font-size: 10pt">
<?
// Cosmetic stuff: define colors for the alternating rows 
$color1 = "#99CCFF"; 
$color2 = "#FFFFFF"; 
$row = 1; 

//example query...replace it with anything you need
$sql = "SELECT * FROM STUDENTS WHERE SCHOOLID='195' AND ROOM='P032'"; 
// Perform query 
$result = mysqli_query($link, $sql) or die("Query failed : " . mysql_error());  

echo "<table border=\"0\" cellspacing=\"0\"  cellpadding=\"2\" style=\"border-collapse: collapse\" bordercolor=\"#111111\">"; 
//the MYSQL_ASSOC gets field names instead of numbers
while ($line = mysqli_fetch_array($result, MYSQL_ASSOC)) { 
if ($row == 1) { 
echo "<tr bgcolor=\"$row_color\">"; 
foreach ($line as $col_key => $col_value) {
$filename2="$col_key.jpg"; //I'm using jpeg in the script, but I already wrote pages requesting .jpg files...
if(file_exists($filename2)) {
echo "<th valign=bottom><img src=\"$filename2\"></th>"; 
} else {
//only fire the vertical column creation script if the image file was not already created in the past...
include('_func_gd_create_vcol.php'); // this will create and save a vertical image ($col_key.jpg) showing the column name
echo "<th valign=bottom><img src=\"$filename2\"></th>"; 
}
}
echo "</tr>"; 
} 
//start a new row
$row_color = ($row % 2) ? $color1 : $color2;
echo "<tr bgcolor=\"$row_color\">"; 
foreach ($line as $col_value) { 
//Alternate the colors between the two colors we defined above.
echo "<td style=\"border-left-style: solid; border-left-width: 1\">$col_value</td>"; 
} 
echo "</tr>"; 
$row++; 
}
//get the record count right
$row=$row-1;
echo "</table>";
//Free resultset
mysqli_free_result($result);
// Closing connection 
mysqli_close($link);
?>
</body> 
</html>

Joseph_Sliker

...this version does not have to mess around with imagerotate and allows you to refer to any true type font you want to use (if you have access to it or can add it to the directory).

_func_gd_create_vcol.php

<?php
//$col_key="I am a vertical column head. jpg"; //just a test value
$filename2="$col_key.jpg";
//if(file_exists($filename2)) {} else {
$font = 'Arial.ttf';
$fsize=12;
//(fontsize,angle,font,text)
$tb=imagettfbbox($fsize, 90, $font, $col_key); //gets an array of numbers...some can be used to define image size
$width=(abs($tb[4])*1.3);
$height=(abs($tb[5])); //create a space for lowercase letters that go below base
$im = imagecreatetruecolor($width, $height);
$white=imagecolorallocate($im, 255, 255, 255);
$navy =imagecolorallocate($im, 0,0,128 );
imagefilledrectangle($im, 0, 0, $width, $height, $navy);
imagettftext($im, $fsize, 90, abs($tb[4]), $height, $white, $font, $col_key);
imagejpeg($im, $filename2); //save the image for future use.
//} //end the test for the existance of the file
//echo "<img src=\"$filename2\">"; //test: view the image that was created
?>

...that's it!

Joseph_Sliker

Hey folks. Over a year later I'm still kinda proud of figuring this out. Are any of you actually using this code? Have you improved upon it? Drop me a line or leave a response. Thanks.