PHP - Facebook Graph Api & Php Sdk, Deleting Events!

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!!

I'm trying to get a bar graph from total number of hit on a month to month basis.

Everything works out find, except the bar graph is only showing 1 month, not everything that's being pulled out of the db.

Can anybody look and see what I'm doing wrong?

Code: [Select]
$userid = '44';
$t_month = date("Y-m-d h:i:s");
$y_month = date("Y-m-d h:i:s", strtotime("-1 Year"));

//Grabs Unique Visitors to App Page
$query = "SELECT CONCAT_WS(' ', YEAR(date), MONTHNAME(date)) AS RptDate, COUNT(DISTINCT referrer) 'referrer'
FROM app_analytics
WHERE appid = $userid
AND date BETWEEN '" .$y_month."'  AND  '" .$t_month."'
GROUP BY CONCAT_WS(' ', YEAR(date), MONTHNAME(date))
ORDER BY YEAR(date), MONTH(date)";

    $result = mysql_query($query) or die(mysql_error());       
        //$totals = array();
        while($row = mysql_fetch_array( $result )){
           
            $months = date("M", strtotime($row['RptDate']));
            $ip = $row['referrer']; 
             
           $values = array("$months" => $ip);
     
    $img_width=450;
$img_height=300;
$margins=20;

 
# ---- Find the size of graph by substracting the size of borders
$graph_width=$img_width - $margins * 2;
$graph_height=$img_height - $margins * 2;
$img=imagecreate($img_width,$img_height);

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

 
# -------  Define Colors ----------------
$bar_color=imagecolorallocate($img,0,64,128);
$background_color=imagecolorallocate($img,240,240,255);
$border_color=imagecolorallocate($img,200,200,200);
$line_color=imagecolorallocate($img,220,220,220);
 
# ------ Create the border around the graph ------

imagefilledrectangle($img,1,1,$img_width-2,$img_height-2,$border_color);
imagefilledrectangle($img,$margins,$margins,$img_width-1-$margins,$img_height-1-$margins,$background_color);

 
# ------- Max value is required to adjust the scale -------
$max_value=max($values);
$ratio= $graph_height/$max_value;

 
# -------- Create scale and draw horizontal lines  --------
$horizontal_lines=20;
$horizontal_gap=$graph_height/$horizontal_lines;

for($i=1;$i<=$horizontal_lines;$i++){
$y=$img_height - $margins - $horizontal_gap * $i ;
imageline($img,$margins,$y,$img_width-$margins,$y,$line_color);
$v=intval($horizontal_gap * $i /$ratio);
imagestring($img,0,5,$y-5,$v,$bar_color);

}
 
 
# ----------- Draw the bars here ------
for($i=0;$i< $total_bars; $i++){
# ------ Extract key and value pair from the current pointer position
list($key,$value)=each($values);
$x1= $margins + $gap + $i * ($gap+$bar_width) ;
$x2= $x1 + $bar_width;
$y1=$margins +$graph_height- intval($value * $ratio) ;
$y2=$img_height-$margins;
imagestring($img,0,$x1+3,$y1-10,$value,$bar_color);
imagestring($img,0,$x1+3,$img_height-15,$key,$bar_color);
imagefilledrectangle($img,$x1,$y1,$x2,$y2,$bar_color);
}
 
header("Content-type:image/png");
imagepng($img);
 } 

Thanks in advance

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);

?>

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();
?>

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

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,

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();
?>

Could anyone tell me why this is not deleting the userip and post id from the database at all.

Thanks


Code: [Select]
<?php
include('dbcon.php');

if($_REQUEST['postId'])
{
$userip = $_SERVER['REMOTE_ADDR'];

mysql_query("update collapsed_likes set likes=likes-1 where post_id= ".$_REQUEST['postId']);

mysql_query("delete from collapsed_ip where userip=".$userip." AND post_id = ".$_REQUEST['postId']);

$total_likes = mysql_query("SELECT * FROM collapsed_likes where post_id = ".$_REQUEST['postId']." ");
$likes = mysql_fetch_array($total_likes);
$likes = $likes['likes'];
}
echo $likes;
?>

Hi, When i launch my code i get the following php error:
Warning: unlink(../files/"yCUuH0223e3d6d046acb58678fbb54042e0fe.pdf") [function.unlink]: Invalid argument in C:\xampp\htdocs\intra\VVS\admin\fakture-edit.php on line 74

But in the dir: C:\xampp\htdocs\intra\VVS\files\

The file exists..

here's my php code:

Code: [Select]
$id = mysql_real_escape_string($_GET['id']);
$fil = mysql_real_escape_string($_GET['fil']);


$result2 = mysql_query("SELECT * FROM fakture WHERE id=('$id')  LIMIT 1");
$row2 = mysql_fetch_array($result2);

if ($_GET["op"] == "process")
{

if (!unlink('../files/"'.$fil.'"'))

Hi, this is the first time I've asked for some help from a forum. I guess this code has sort of got me stumped.

So, I have a system where a user can enter a number. The number goes into a mysql database. A random number is also generated and it is added into another column.

So, I want users to be able to delete the number using the random number. I've shown it to them, and I need help working my delete script.
Code: [Select]
<?php
$con = mysql_connect("localhost","","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("a8784hos_adopts", $con);
$adopt = $_POST['adoptid'];
$uniquecode = $_POST['uniquecode'];
$result = mysql_query("SELECT uniquecode, id FROM id WHERE id='$adopt'");
mysql_fetch_array($result);
if (($adopt == $row['id']) || ($uniquecode == $row['uniquecode'])){
mysql_query("DELETE FROM id WHERE id='$adopt'");
echo 'Done! <br/><br/><a href="tester.php">Go back....</a>';
}
else {
echo 'Bad unique code. <br/><br/><a href="tester.php">Go back....</a>';
}
?>

So, the random number is uniquecode in the database, and the number is id. However, when I try this code, it always tell me I have a bad unique code. What am I doing wrong?

Thanks.

Does anyone have a code that will automatically delete stuff out of the database after 30 days of being in there...?

I'm just trying to get suggestions on what people think would be the best way to go with this. With the bottom part of this card where it s tarts working with the foreach loop its taking what was a UL and for each of each LI's and updating a table with its new data however this way isn't going to work as this is editing a user. Because there could be 5 in the database but the new edit user has only 4 lis so I'm sure you could all see the issue here. What I'm thinking would be best is to have it DELETE the existing characterIDs that have WHERE handler_ID = $handlerID and then just do a new INSERT statement. Anyone else think this would be the best way to go about this?


Code: [Select]
if (mysqli_num_rows($Qresult) == 0) {
        $query = "UPDATE `handlers`
            SET `userName` = '".$userName."', `password`='".$password."', `firstName`='".$firstName."', `lastName`='".$lastName."', `statusID`='".$statusID."', `isAdmin`='".$admin."', `defaultCharID`='".$defaultCharID."', `email`='".$email."' WHERE `ID` = '".$handlerID."'"; 
        mysqli_query($dbc, $query);
        foreach ($characterIDs as $cID) {
               $query2 = "UPDATE `handler_characters`
               SET `handler_id` = '".$handlerID."', `characterID` = '".$cID."'";
               mysqli_query($dbc, $query2);
        }
        $result = "good";
    }