PHP - Graph Only Showing 1 Month

Hi All,

Are there any decent PHP graph solutions out there?

I have an SQL statement that returns 12 numberical values in an array (mssql_fetch_array).

I would like to plot these values on a graph.

Thanks
Matt

hi guys  ..I want to create graphs in php. Data will be taken by mysql ofcourse... I have seen lots of options like fusion chart xml, phpgraphlib and so on...

my question is

What will be the best library or tool. What will be your recommendation to create graphs.

Thanks

I'm working on PHP Math for my assignment, and it requires a graph to show the functions.
But, i have no idea how to build a x-y-z (3D) graph.... All codes that i have search only for 2-dimensional (x-y axis) only..

Is there any help or solutions to make a 3-dimensional graph using PHP or Javascript?

thank you before

Hi everyone,

Newish to PHP and I'm sure this is a simple thing but I was hoping someone could help me out.

I have a php file that draws a graph for me (it takes in the coordinates from a text file). What I want to do is insert a red line at the top of the graph (not from start to finish, but starting at a certain point in the graph and finishing at another point).

This php code achieves the line I would like to insert into the graph:

<?php
$canvas = imagecreatetruecolor(1000, 10);

// Allocate colors
$red = imagecolorallocate($canvas, 255, 0, 0);

ImageFilledRectangle($canvas, 0, 0, 1000, 10, $red);


// Output and free from memory
header('Content-Type: image/jpeg');

imagejpeg($canvas);
imagedestroy($canvas);
?>


I need to insert this into this php script:

<?php
$width = 1000; //width and height of the resulting image
$height = 230;

$drawLastLine = false; //draw 9th line or not
$testMode = false; //render only 10 images



//returns directory with cached images by name of text file
function getCacheDirectory($fname)
{
    $mod = filemtime($fname);
    $dirname = "cache/" . $fname . "." . $mod . "/";
    return $dirname;
}

//checks if specified txt file is cached
function isCached($fname)
{
    $dirname = getCacheDirectory($fname);
    return file_exists($dirname);
}

//calculated y-coordinates of base-lines for all 9 lines, returns an array
function initStart($height, $number = 9)
{
    $d = $number + 1;
    $t = $height / $d;
    $res = array();
    $c = 0;
    for ($i = 0; $i < $number; $i++)
    {
        $c += $t;
        $res[$i] = $c;
    }
    return $res;
}


//draws vertical grey line with specified coordinate
function drawVerticalLine($img, $x)
{
    $grey = imagecolorallocate($img, 80, 80, 80);
    $h = imagesy($img);
    imagesetthickness($img, 3);
    imageline($img, $x, 0, $x, $h, $grey);
    imagesetthickness($img, 0.1);
}

//cuts unfilled part of image in the right, making its width equal to $realW
function cutRight($img, $realW)
{
    $h = imagesy($img);
    $new = imagecreatetruecolor($realW, $h);
    imagecopy($new, $img, 0, 0, 0, 0, $realW, $h);
    return $new;
}

//makes up an array of required colors
function allocateColors($img)
{
    $result = array();
    $result['blue'] = imagecolorallocate($img, 0, 0, 255);
    $result['red'] = imagecolorallocate($img, 255, 0, 0);
    $result['black'] = imagecolorallocate($img, 0, 0, 0);
    $result['white'] = imagecolorallocate($img, 255, 255, 241);
    return $result;
}

//main function which generates all the images
function generateImages($fname)
{
    
    set_time_limit(0); //there's no time limit, because it's long process
    global $width, $height, $start, $testMode, $drawLastLine;
    
    $lines = 9;
    $start = initStart($height, $drawLastLine ? $lines : $lines - 1);

    //colors of line from top bo bottom
    $lineCol = array('blue', 'blue', 'red', 'red', 'blue', 'blue', 'black', 'red', 'red');
    
    $fp = fopen($fname, "r"); //we open our file with data
    $header = fgets($fp);

    $curX = 0;
    $sumX = 0;
    $imgNum = 1;

    $colors = false;
    $const = 1.0; //that's the constant which can be used to multiply by y-coordinates, i.e. making our graphs scalable by y-coordinate

    $prevY = array();
    for ($i = 0; $i < $lines; $i++)
    {
        $prevY[$i] = 0;
    }

    $dir = getCacheDirectory($fname);
    mkdir($dir);
    $img = false;

  //  $maximumImages = 10;

    //if we are testing, we will do just 10 images, else we will work until the file ends
    while ((!$testMode || ($testMode && $imgNum < $maximumImages)) && $line = fgets($fp))
    {
        //if it's time to make up a new image
        if ($sumX % $width == 0)
        {
            //we save old one to file
            if ($img)
            {
                imagegif($img, $dir . $imgNum . ".gif");
                $imgNum++;
            }
            //and create a new one, along with allocating colors and so on
            $img = imagecreatetruecolor($width, $height);
            $colors = allocateColors($img);
            imagefill($img, 0, 0, $colors['white']);
            $curX = 0;
        }
        $data = explode(",", $line);
        $time = array_shift($data);

        $linesCount = $drawLastLine ? $lines : $lines - 1;
        //we loop through our lines
        for ($i = 0; $i < $linesCount; $i++)
        {
            
            $ly = $data[$i] * $const; //it's the new Y coordinate, and we counts from baseline with y = 0
            $realTo = $start[$i] + $ly; //now we count the baseline too

            $realFrom = $start[$i] + $prevY[$i]; //that's the previous step's y-coordinate
            $prevY[$i] = $ly; //we remember current coordinate to draw line on next step

            $x1 = $curX - 1;
            $y1 = $realFrom;
            $x2 = $curX;
            $y2 = $realTo;
            //we draw line finally with needed color
            imageline($img, $x1, $y1, $x2, $y2, $colors[$lineCol[$i]]);
        }

        //if the time looks like 235.000000, we need to draw vertical line
        if (round($time) == $time)
        {
            drawVerticalLine($img, $curX);
        }

        //we increase both curX (which is used for drawing) and overall x (it indicates how much lines we've processed)
        $curX++;
        $sumX++;

    }

    // if we didn't save all lines to .gifs, we need to save leftovers
    if ($curX > 0)
    {
        $img = cutRight($img, $curX);
        imagegif($img, $dir . $imgNum . ".gif");
        $imgNum++;
    }

    //saving numbers of pictures rendered
    file_put_contents($dir . "info.txt", ($imgNum - 1));

}

$fname = $_GET['file'];

//there should be no slashes in filename and it should end with .txt
if (strpos($fname, "/") !== false || strpos($fname, "\\") !== false || strpos($fname, ".txt") === false)
{
    echo "Security error!";
    die;
}

//it should exist
if (!file_exists($fname))
{
    echo "No such file!";
    die;
}

//if there are no images cached for our file, we need to generate them
if (!isCached($fname))
{
    generateImages($fname);
}

$page = 1;
$dirname = getCacheDirectory($fname);
$maxPages = file_get_contents($dirname . "info.txt");
//$maxPages = 10;
$uniqid = uniqid();
$img = $dirname . $page . ".gif?" . uniqid();

include("templates/show2.php.inc");



I'm just lost as to how I achive this line in the longer php script. I've tried creating my own function, and then calling it further down but this just breaks it. Any help is appreciated!!

Anyone can help me with plotting of multiple line graph in php.

I have researched on multiple line graph online and  I would like to plot the graph by taking data from my database but the example below is inserting the graph data manually.
Anyone can teach me how to use a for loop inside an array?

Code: [Select]
<?php
//Include the code
require_once 'phplot.php';

//Define the object
$plot = new PHPlot(800,600);

//Set titles
$plot->SetTitle("A 3-Line Plot\nMade with PHPlot");
$plot->SetXTitle('X Data');
$plot->SetYTitle('Y Data');

//Define some data
$example_data = array(
     array('a',3,4,2),
     array('b',5,3,1),  
     array('c',7,2,6),
     array('d',8,1,4),
     array('e',2,4,6),
     array('f',6,4,5),
     array('g',7,2,3)
);
$plot->SetDataValues($example_data);

//Turn off X axis ticks and labels because they get in the way:
$plot->SetXTickLabelPos('none');
$plot->SetXTickPos('none');

//Draw it
$plot->DrawGraph();
?>

I need a simple line graph for my PHP site showing page views against date (monthly). Have tried to find plugins but can't find an appropriate one. Can someone please help with a script or direct me to a plugin.

Attached is the kind of graph I'd like to have.

Following Sams PHP 24hrs... Rewrote Example and it isn't working... I am not getting any syntax error just an error saying it cannot display the graph because there are errors in the image.  I have went through it line for line looking for mispellings you name it making sure it was exactly as they wrote so I could follow along... but now its is not working and I believe its me.. not the book... can anyone help me out?

<?php
//Send content type header to browser so image will be rendered
header ("Content-type: image/png");

class SimpleBar
{
   private $xgutter = 20;//left/right margin
   
   private $ygutter = 20;//top/bottom margin
   
   private $bottomspace = 30;//gap at the bottom
   
   private $internalgap = 10;//gap between bars
   
   private $cells = array();//labels/amounts for bar charts
   
   private $totalwidth;
   
   private $totalheight;
   
   private $font;
   

   function __construct( $width, $height, $font )
   {
      $this->totalwidth = $width;
      $this->totalheight = $height;
      $this->font = $font;
   }
   
   //Used to allow user to populate $cells[] property array
   function addBar( $label, $amount )
   {
      $this->cells[ $label ] = $amount;
   }
   
   private function _getTextSize( $cellwidth )
   {
      $textsize = (int)( $this->bottomspace );//Make $textsize equal to bottomspace
      if ( $cellwidth < 10 )
      {
         $cellwidth = 10;
      }
      //Loop through the cells array and acquire dimension info for the labels using imageTTfbBox()
      foreach ( $this->cells as $key=>$val )
      {
         while ( true )
         {
            $box = imageTTFbBox( $textsize, 0, $this->font, $key  );
            $textwidth = abs ( $box[2] );
            if ( $textwidth < $cellwidth )
            {
               break;
            }
            $textsize--;
         }
      }
      return $textsize;
   }
   
   function draw()
   {
      $image = imagecreate( $this->totalwidth, $this->totalheight );//Create Image Resource
      //Create Color resources
      $red = imagecolorallocate( $image, 255,0,0 );//Red
      $blue = imagecolorallocate( $image, 0,0,255 );//Blue
      $black = imagecolorallocate( $image, 0,0,0 );//Black
      
      $max = max( $this->cells );//Cache the maxium value the $cells[] array has
      
      $total = count( $this->cells );//Cache the number of elements the $cells[] array contains
      
      $graphCanX = ( $this->totalwidth - $this->xgutter*2 );//Set up the canvas space on the X-axis for the graph
      
      $graphCanY = ( $this->totalheight - $this->ygutter*2 -  $this->bottomspace );//Set up the canvas space on the Y-axis for the graph ( Have to allow room for our labels and margins )
      
      $posX = $this->xgutter;//Store the starting point for drawing our bars on the X-axis
      
      $posY = $this->totalheight - $this->ygutter; - $this->bottomspace;//Store the starting point for drawing our bars on the Y-axis ( Have to allow room for our labels and margins )
      
      $cellwidth = (int) ( ( $graphCanX -( $this->internalgap * ( $total - 1 ) ) ) / $total );//Calculate the cellwidth for each bar by taking the width of the graph canvas and subtracting the total distance bewteen the bars divided by the total amount of bars being used
      
      $textsize = $this->_getTextSize( $cellwidth );
      
      foreach( $this->cells as $key=>$val )
      {
         $cellheight = (int) ( ( $val/$max ) * $graphCanY );//Calculate height of each bars
         
         $center = (int) ( $posX + ($cellwidth/2) );//Calculate cener point of bars
         
         $imagefilledrectangle( $image, $posX, ($posY - $cellheight), ($posX+$cellwidth), $posY, $blue);//Draw the bars
         
         $box = imageTTFbBox( $textsize, 0, $this->font, $key );
         
         $tw = $box[2];
         
         imageTTFtext( $image, $textsize, 0, ($center-($tw/2) ),
         ( $this->totalheight-$this->ygutter), $black, $this->font, $key );
         $posX += ( $cellwidth + $this->internalgap);
      }
   
      imagepng( $image );   
   }
   
}

$graph = new SimpleBar( 500, 300, "league_gothic-webfont.ttf" );
$graph->addBar("Really Liked" , 200);
$graph->addBar("Liked" , 100);
$graph->addBar("Kinda Like" , 300);

$graph->draw();



?>

hi, I hope some one can be of help?

I want to make a graph using php and GD with data from MySQL, so far success. Now I want to ammend the script (see end of message) to display text on each bar, e.g red, green, blue.

Also currently I loop through when setting the bar colours, in this case grey, how can I get it so there are 3 different colours? There will only ever be 3 bars.

Thank you for any  help

Gary

Code: [Select]
<?php
$dbhost = 'host';
$dbuser = 'user';
$dbpass = 'password';
$dbname = 'db';
$tblname = 'tbl';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

mysql_select_db($dbname);

// Make a MySQL Connection
$query = sql goes here!
$result = mysql_query($query) or die(mysql_error());
$values = array();
// Print out result
while($row = mysql_fetch_array($result)){   
array_push($values,$row['COUNT(Answer)']);}





// This array of values is just here for the example.
 


    //$values = array("5","6","7");
 
// Get the total number of columns we are going to plot
 
    $columns  = count($values);
 
// Get the height and width of the final image
 
    $width = 150;
    $height = 200;
 
// Set the amount of space between each column
 
    $padding = 15;
 
// Get the width of 1 column
 
    $column_width = $width / $columns ;
 
// Generate the image variables
 
    $im        = imagecreate($width,$height);
    $gray      = imagecolorallocate ($im,0xcc,0xcc,0xcc);
    $gray_lite = imagecolorallocate ($im,0xee,0xee,0xee);
    $gray_dark = imagecolorallocate ($im,0x7f,0x7f,0x7f);
    $white     = imagecolorallocate ($im,0xff,0xff,0xff);

 
// Fill in the background of the image
 
    imagefilledrectangle($im,0,0,$width,$height,$white);
 
    $maxv = 0;
 
// Calculate the maximum value we are going to plot
 
    for($i=0;$i<$columns;$i++)$maxv = max($values[$i],$maxv);
 
// Now plot each column
 
    for($i=0;$i<$columns;$i++)
    {
        $column_height = ($height / 100) * (( $values[$i] / $maxv) *100);
 
        $x1 = $i*$column_width;
        $y1 = $height-$column_height;
        $x2 = (($i+1)*$column_width)-$padding;
        $y2 = $height;
 
        imagefilledrectangle($im,$x1,$y1,$x2,$y2,$gray);
// imagefilledrectangle($im,$x1,$y1,$x2,$y2,$colour[$i]);
 
// This part is just for 3D effect
 
        imageline($im,$x1,$y1,$x1,$y2,$gray_lite);
        imageline($im,$x1,$y2,$x2,$y2,$gray_lite);
        imageline($im,$x2,$y1,$x2,$y2,$gray_dark);
 
    }
 
// Send the PNG header information. Replace for JPEG or GIF or whatever
 
    header ("Content-type: image/png");
    imagepng($im);

?>

For the life of me, I cannot find a way to delete, cancel or remove facebook events I created & updated using the FB PHP SDK & the Graph API.

I've tried every single permutation found on facebook's documentation & stack overflow...

Here are some of the clues I have found on my quest..

https://developers.facebook.com/docs/reference/api/#deleting https://developers.facebook.com/docs/reference/api/event/ https://developers.facebook.com/docs/reference/rest/events.cancel/
http://stackoverflow.com/questions/2931387/facebook-sdk-and-graph-api-comment-deleting-error
http://stackoverflow.com/questions/2858748/facebook-api-delete-status
http://stackoverflow.com/questions/3832405/facebook-graph-api-delete-like

Here is what I have tried so far.
function delete_fb_event($event_data, $data)
{
    //load the user for offline access and userid
    $user = $this->load_user($data['aid']);

    if(!empty($user[0]['fb_offline_access']))
    {
        //instantiate Facebook API
        require 'facebook.php';
        $facebook = new Facebook(array(
          'appId'  => 'BLAHBLAHBLAH',
          'secret' => 'BLAHBLAHBLAHBLAHBLAHBLAH',
          'cookie' => true,
        ));

        $fb_event = array(
            "access_token" => $user[0]['fb_offline_access'],
        );

        $result = $facebook->api('/'.$event_data['fb_event_id'], 'DELETE', $fb_event); //Uncaught GraphMethodException: Unsupported delete request
        //$result = $facebook->api('/'.$user[0]['fb_id']."_".$event_data['fb_event_id'], 'POST', array('access_token' => $user[0]['fb_offline_access'], 'method' => 'delete')); Uncaught OAuthException: (#803) Some of the aliases you requested do not exist
        //$result = $facebook->api('/'.$event_data['fb_event_id']."_".$user[0]['fb_id'], 'POST', array('access_token' => $user[0]['fb_offline_access'], 'method' => 'delete')); Uncaught OAuthException: (#803) Some of the aliases you requested do not exist  
        //$result = $facebook->api('/'.$event_data['fb_event_id'], 'POST', array('access_token' => $user[0]['fb_offline_access'], 'method' => 'delete')); Uncaught GraphMethodException: Unsupported post request
        //$result = $facebook->api('/'.$user[0]['fb_id']."_".$event_data['fb_event_id'], 'POST', array( 'access_token' => $user[0]['fb_offline_access'], 'method' => 'delete' )); Uncaught OAuthException: (#803) Some of the aliases you requested do not exist
        return $result;         
    }
    else
    {
        echo "error3"; //no FB offline access
    }       
}   

I have the following code:

Code: [Select]
private function buildJSResponse(){
$data = "";
$i = 0;
$arr = array();
while($this->db->row()){
$arr[] = (int)$this->db->field("average");
}
$this->max = max($arr);
$this->min = min($arr);
$this->mid = round(($this->max + $this->min) / 2);
foreach($arr as $val){
$nTime = ($val / $this->max) * 100;
$data .= "data[$i] = ".$nTime.";";
$i++;
}
return $data;
}
It takes an array, finds the max/min and number halfway between the min/max.
The next part I am not sure what to do.

I am making a line graph using the canvas, so I am building a javascript array, which will contain the point on the chart. The problem I am having, is location.
Lets say $max = 110, and $min = 95.
the y position on the graph should be 0 for $max, and 100 for $min, then all the other points need to fall into their place as well.

$nTime is supposed to do that, but it doesn't any suggestions?

The attachment is the result I am getting from my above code.
As you can see the lowest number is 49, so the value with 49 should touch the bottom, which it doesn't.

Hello people, currently i ran into some problem.

Currently, i have a database called responses which have the fields of ID, Student_id, question_id, Answer.

I had stored my results into the database which appeared to be           1       1                  1             Agree
                                                                                                                 2       1                  2            Disagree
                                                                                                                 3        3                 4             Unsatisfied.

So any recommendation on how should i do about in generating the result into a graph whereby the graph will show how many students choose "AGree" on that particular question THANKS

Hello,

I am using a tutorial script for generating a basic bar graph. I have attempted to convert this script into an object-oriented script. However, upon attempting to define the graph, it is not successfully generated. Here is my code:

Code: [Select]
<?

class Graph
{
var $values;
var $image;
var $image_width = 450;
var $image_height = 300;
var $margin = 20;
var $bar_size = 20;
var $horizontal_lines = 20;

var $bar_colour;
var $border_colour;
var $background_colour;
var $line_colour;

function CreateGraph()
{
$this->image = imagecreate($this->image_width, $this->image_height);
}

function SetSize($width, $height)
{
$this->image_width = $width;
        $this->image_height = $height;
        }
       
        function SetMargin($size)
        {
        $this->margin = $size;
        }
       
        function SetBarSize($size)
        {
        $this->bar_size = $size;
        }
       
        function SetHorLines($size)
        {
        $this->horizontal_lines = $size;
        }
       
        function HexConvert($rgb)
        {
    return array(
        base_convert(substr($rgb, 0, 2), 16, 10),
        base_convert(substr($rgb, 2, 2), 16, 10),
        base_convert(substr($rgb, 4, 2), 16, 10),
    );
}
       
        function SetColours($bars, $background, $border, $line)
        {
        // This is hex based, similar to CSS, it is converted by HexConvert
        $bars = $this->HexConvert($bars);
        $background= $this->HexConvert($background);
        $border= $this->HexConvert($border);
        $line = $this->HexConvert($line);
       
        $this->bar_colour = imagecolorallocate($this->image, $bars[0], $bars[1], $bars[2]);
        $this->background_colour = imagecolorallocate($this->image, $background[0], $background[1], $background[2]);
        $this->border_colour = imagecolorallocate($this->image, $border[0], $border[1], $border[2]);
        $this->line_colour =imagecolorallocate($this->image, $line [0], $line [1], $line [2]);
        }
       
        function DrawBorders()
        {
        imagefilledrectangle($this->image,1,1,$this->image_width-2,$this->image_height-2,$this->border_colour);
imagefilledrectangle($this->image,$this->margin,$this->margin,$this->image_width-1-$this->margin,$this->image_height-1-$this->margin,$this->background_colour);
}

function DrawHorLines($horizontal_gap, $ratio)
{
for($i=1;$i<=$this->horizontal_lines;$i++)
{
$y = $this->image_height - $this->margin - $horizontal_gap * $i ;
imageline($this->image, $this->margin, $y, $this->image_width - $this->margin, $y, $this->line_colour);
$v = intval($horizontal_gap * $i / $ratio);
imagestring($this->image, 0, 5, $y-5, $v, $this->bar_colour);
}
}

function DrawBars($graph_height, $gap, $ratio)
{
for($i=0;$i< $total_bars; $i++)
{
list($key,$value)=each($this->values);
$x1= $this->margin + $gap + $i * ($gap+$this->bar_size) ;
$x2= $x1 + $this->bar_size;
$y1 = $this->margin +$graph_height- intval($value * $ratio) ;
$y2 = $this->image_height-$this->margin;
imagestring($this->image,0,$x1+3,$y1-10,$value,$this->bar_colour);
imagestring($this->image,0,$x1+3,$this->image_height-15,$key,$this->bar_colour);
imagefilledrectangle($this->image,$x1,$y1,$x2,$y2,$this->bar_colour);
}
}
       
        function DrawGraph()
        {
        $graph_width=$this->image_width - $this->margin * 2;
$graph_height=$this->image_height - $this->margin * 2;

$total_bars  = count($values);
$gap = ($graph_width- $total_bars * $this->bar_width ) / ($total_bars +1);

$this->DrawBorders();

$max_value=max($values);
$ratio = $graph_height / $max_value;

$horizontal_gap = $graph_height / $horizontal_lines;

$this->DrawHorLines($horizontal_gap, $ratio);

$this->DrawBars($graph_height, $gap, $ratio);
}

function OutputGraph()
{
header("Content-type:image/png");
imagepng($this->image);
}
}

?>
I expect this to be my misunderstanding of how object orientated codes work. I'm also open to any suggestions for improvement.

Edit: Here is the script where I use the class.
Code: [Select]
<?
include "bargraph.class.php";

$graph = new Graph;
$graph->SetSize(450, 300);
$graph->CreateGraph();
$graph->SetMargin(20);
$graph->SetBarSize(20);
$graph->SetHorLines(20);
$graph->SetColours("FFFFFF", "C0C0C0", "000000", "000000");
$graph->DrawGraph();
$graph->OutputGraph();
?>

Retrieve Pages, Ads, Leads from multiple facebook accounts with Graph API - Help needed

I am pretty new to PHP and am trying to create a simple (so I assumed) page to takes data from one html page(works fine) and updates a MYSQL Database.  I am getting no error message, but the connect string down to the end of the body section is showing up as plain text in my browser window.  I do not know how to correct this.  I have tried using two different types of connect strings and have verified my names from the HTML page are the same as listed within the php page.  Suggestions on what I need to look for to correct would be great.  I have looked online, but so far all I am getting is how to connect, or how to create a comment, so I thought I would try here. 
Thank you for any assistance I may get!!  - Amy -
 
Code: [Select]
<body><font color="006600">
 <div style="background-color:#f9f9dd;">
  <fieldset>
<h1>Asset Entry Results</h1>
<?php
  // create short variable names
  $tag=$_POST['tag'];
  $serial=$_POST['serial'];
  $category=$_POST['category'];
  $status=$_POST['status'];
  $branch=$_POST['branch'];
  $comments=$_POST['comments'];

  if (!$tag || !$serial || !$category || !$status || !$branch) {
     echo "You have not entered all the required details.<br />"
          ."Please go back and try again.";
     exit;
  }

  if (!get_magic_quotes_gpc()) {
    $tag = addslashes($tag);
    $serial = addslashes($serial);
    $category = addslashes($category);
    $status = addslashes($status);
    $branch = addslashes($branch);
    $comments = addslashes($comments);
  }

  //@ $db = new mysqli('localhost', 'id', 'pw', 'inventory');
  $db = DBI->connect("dbi:mysql:inventory:localhost","id","pw") or die("couldnt connect to database");

  $query = "insert into assets values
            ('".$serial."', '".$tag."', '".$branch."', '".$status."', '".$category."', '".$comments."')";
  $result = $db->query($query);

  if ($result) {
      echo  $db->affected_rows." asset inserted into Inventory.";
  } else {
     echo "An error has occurred.  The item was not added.";
  }

  $db->close();
?>
  </fieldset>
 </div>
</body>

Hello. I want to generate the initial of the day of all the days of a chosen month. Meaning, if I choose this month it will give me:

TFSSMTWTFSSMTWTFSSMTWTFSSMTWTF

Is that clear? Can anybody help me? thanks!