PHP - Create Prepared Mysql Temp Table??

Hello   I have a mysql table like this: id | user | car
1 | 1 | fiat 500
2 | 2 | vw polo
3 | 2 | vw golf
4 | 3 | renault clio
5 | 2 | fiat panda 6 | 3 | seat ibiza

From this table how can i get a query that the result be like:   user 2 - 3 cars user 3 - 2 cars user 1 - 1 cars   Thanks

Hi ppl,
I am not an php expert, but I want to allow my website users to edit a record in mySQL table.
I need to allow them changing Name and description of a product, thats all. easy edit.

Is there a ready component that will do the hard work for me?
Thank you!

I swear I had read a tutorial on this site, but I must be mistaken as I can't find it.

I did some googling on it.. but not to happy with the tutorials.  Just wondering if someone could point me in a better direction.

I'm wondering if I can take advantage of these.  Like if I put these in a "config" file that is called on every PHP page and I have 2 or 3 SQL queries that I always want to run, a SELECT and UPDATE (maybe a delete).  I could call these at will.. right?  Without having to rewrite the query a million times?

Any help is most appreciated.

I've decided to move over to using Prepared statements for security purposes, however I'm having problems with the following code.

Any help or suggestions would be appreciated

Output:

Code: [Select]

You are Logged In

Fatal error: Call to a member function bindParam() on a non-object in [b]xxxxxxx[/b]/login.php on line 34


Code:
Code: [Select]
<?php
include "functions.php";
$db_connection = db_connect();
$db_connection2 = db_connect();

$login_statement =  $db_connection->prepare("SELECT COUNT(*) AS accounts FROM `accounts` WHERE `email` = ? AND `password` = ?");
$test_stmt =   $db_connection2->prepare("INSERT INTO `test` (`test`) VALUES (:tst)");



login($_POST[email],$_POST[password],$login_statement);
log_login($test_stmt);

function login($email,$password,$login_statement){

$login_statement->bind_param("ss", $email, $password);
$login_statement->bind_result($accounts);
$login_statement->execute() or die ("Could not execute statement");

while ($login_statement->fetch()) { 

if ($accounts==1){
echo "<br/> You are Logged In <br/>";
}

else{
echo "<br/>Credentials Invalid<br/>";
     } 
}
}

function log_login($test_stmt){

$test_stmt->bindParam(':tst', $tst);  //< ********LINE 34*******
$tst="blah";
$test_stmt->execute()  or die ("Could not execute statement");
}
?>

I have a prepared statement class for MYSQL, since in PHP 5 this is now changing to mysqli; I'm looking for some help in changing the code from my existing class to the new mysqli.   I have done some research online about changing from mysql to mysqli but the changes I made seems to only cause issues with connecting to the database.   After many hours of changing the existing file using the research online, I've decided to start again and ask others if they would be ever so kind to help this noob out and point out which parts of the script needs to be changed.    Thank you for reading.   

<?php
class Database {
 
    private $host;
    private $user;
    private $pass;
    private $name;
    private $link;
    private $error;
    private $errno;
    private $query;
 
    function __construct($host, $user, $pass, $name = "", $conn = 1) {
        $this -> host = $host;
        $this -> user = $user;
        $this -> pass = $pass;
        if (!empty($name)) $this -> name = $name;      
        if ($conn == 1) $this -> connect();
    }
 
    function __destruct() {
        @mysql_close($this->link);
    }
 
    public function connect() {
        if ($this -> link = mysql_connect($this -> host, $this -> user, $this -> pass, TRUE)) {
            if (!empty($this -> name)) {
                if (!mysql_select_db($this -> name, $this->link)) $this -> exception("Could not connect to the database!");
            }
        } else {
            $this -> exception("Could not create database connection!");
        }
    }
 
    public function close() {
        @mysql_close($this->link);
    }
 
    public function query($sql) {
        if ($this->query = @mysql_query($sql, $this->link)) {
            return $this->query;
        } else {
            $this->exception("Could not query database!");
            return false;
        }
    }
 
    public function num_rows($qid) {
        if (empty($qid)) {         
            $this->exception("Could not get number of rows because no query id was supplied!");
            return false;
        } else {
            return mysql_num_rows($qid);
        }
    }
 
    public function fetch_array($qid) {
        if (empty($qid)) {
            $this->exception("Could not fetch array because no query id was supplied!");
            return false;
        } else {
            $data = mysql_fetch_array($qid);
        }
        return $data;
    }
 
    public function fetch_array_assoc($qid) {
        if (empty($qid)) {
            $this->exception("Could not fetch array assoc because no query id was supplied!");
            return false;
        } else {
            $data = mysql_fetch_array($qid, MYSQL_ASSOC);
        }
        return $data;
    }
 
public function fetch_object($qid) {
        if (empty($qid)) {
            $this->exception("Could not fetch object assoc because no query id was supplied!");
            return false;
        } else {
            $data = mysql_fetch_object($qid);
        }
        return $data;
    }
 
    public function fetch_all_array($sql, $assoc = true) {
        $data = array();
        if ($qid = $this->query($sql)) {
            if ($assoc) {
                while ($row = $this->fetch_array_assoc($qid)) {
                    $data[] = $row;
                }
            } else {
                while ($row = $this->fetch_array($qid)) {
                    $data[] = $row;
                }
            }
        } else {
            return false;
        }
        return $data;
    }
 
    public function last_id() {
        if ($id = mysql_insert_id()) {
            return $id;
        } else {
            return false;
        }
    }
 
    private function exception($message) {
        if ($this->link) {
            $this->error = mysql_error($this->link);
            $this->errno = mysql_errno($this->link);
        } else {
            $this->error = mysql_error();
            $this->errno = mysql_errno();
        }
        if (PHP_SAPI !== 'cli') {
        ?>
 
            <div class="alert-bad">
                <div>
                    Database Error
                </div>
                <div>
                    Message: <?php echo $message; ?>
                </div>
                <?php if (strlen($this->error) > 0): ?>
                    <div>
                        <?php echo $this->error; ?>
                    </div>
                <?php endif; ?>
                <div>
                    Script: <?php echo @$_SERVER['REQUEST_URI']; ?>
                </div>
                <?php if (strlen(@$_SERVER['HTTP_REFERER']) > 0): ?>
                    <div>
                        <?php echo @$_SERVER['HTTP_REFERER']; ?>
                    </div>
                <?php endif; ?>
            </div>
        <?php
        } else {
                    echo "MYSQL ERROR: " . ((isset($this->error) && !empty($this->error)) ? $this->error:'') . "\n";
        };
    }
 
}
?>

Hi, Im just having some trouble with this...maybe a fresh pair of eyes can help? 

Im getting a "Warning: mysqli_stmt::bind_param() [mysqli-stmt.bind-param]: Number of elements in type definition string doesn't match number of bind variables" error when I try run this:

Code: [Select]
$date = date("Y-m-d");
        $header = $_POST['header'];
        $summary = $_POST['summary'];
        $content = $_POST['content'];
 
        $query = "INSERT INTO articles (pubdate, title, summary, content) VALUES(?, ?, ?, ?)";
        $stmt = $mysqli->stmt_init();
       
        if ($stmt->prepare($query)){
           
            $stmt->bind_param('i,s,s,s', $date, $header, $summary, $content);
 
            $stmt->execute();
            $stmt->close();
        }
        else {
            echo "ERROR: SQL statement failure!";
            echo "<a href='addnews.php'> -> OK</a>";
        }
        $mysqli->close();

It looks fine to me, just can't see whats wrong lol!

From the beginning, the user accesses my website and uploads an image.

Currently I'm using SimpleImage.php available at http://www.white-hat-web-design.co.uk/articles/php-image-resizing.php to resize uploaded pictures.

I create two copies, a regular size and a thumbnail size. Then I transfer the converted files through FTP to my storage server. The regular size works great, but the thumbnail transfers as a blank file. I don't want to save the files on the non-storage server at all, so I'm trying to work with temporary files.

include('./SimpleImage.php');

// A few variables
$file_name = basename($_FILES['photo1']['name']);
$random_digit=mt_rand(111111111,2147483647);

// New file name
$new_file_name = $userInfo['id'].'_'.$random_digit.$random_digit.'_'.substr($file_name, -5);

// Paths to temporary files
$target_path = $_FILES['photo1']['tmp_name'];
$thumb_path = tmpfile();

// Start SimpleImage and load temp file
$simImage = new SimpleImage();
$simImage->load($target_path);

// Get the temp image dimensions
list($width, $height) = getimagesize($target_path);

// Resize the file if it's too tall
if ($height > $var['maxPhotoHeight']) {
   $simImage->resizeToHeight($var['maxPhotoHeight']);
   $simImage->save($target_path);
   }

// Get the newly resized image dimensions
list($width, $height) = getimagesize($target_path);

// Resize the image if it's too wide
   if ($width > $var['maxPhotoWidth']) {
   $simImage->resizeToWidth($var['maxPhotoWidth']);
   $simImage->save($target_path);
   }

// Resize for thumbnail width
   $simImage->resizeToWidth($var['thumbWidth']);
   $simImage->save($thumb_path);

// Get thumbnail dimensions
list($width, $height) = getimagesize($thumb_path);

// Resize the thumbnail if it's too tall
if ($height > $var['thumbHeight']) {
   $simImage->resizeToHeight($var['thumbHeight']);
   $simImage->save($thumb_path);
   }

// Was told this was important, but I've tried with and without it and got the same result
fseek($thumb_path,0);

// Perform File Transfer
ftpTransfer($target_path, "$new_file_name");
ftpTransfer($thumb_path, "thumbs/$new_file_name");



// My Simple FTP Transfer Function:
function ftpTransfer($source, $name) {
global $ftp;

$ftpMeta = "ftp://" . $ftp['user_name'] . ":" . $ftp['user_pass'] . "@" . $ftp['server'] . $ftp['dir'] . $name;
$ftpData = file_get_contents($source);

file_put_contents($ftpMeta, $ftpData);
}

Like I said, the regular sized image works great!! the thumbnail file is only created on the storage server but it has a 0kb file size. I'm sure it has to do with me working with a temporary file. tmpfile() claims to remove the file after it's closed, so maybe by using the Save feature in SimpleImage, it's closing the file and then the server automatically removes the temporary file?

SimpleImage has a feature where I can write the image output [possibly to a file] using $simImage->output() for the data. If that helps with a solution? I don't know.

I know it might be complicated, but any help is appreciated!

I'm trying to figure out how to create a temporary table of a query join, so I can paginate the results. I kind of made half of this up as i was going along - which is dangerous for a beginner like me.
I'm getting this error, and no results on the page:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource on line 179

also, is there a way to combine the two queries (create temp and insert from/into)


Code: [Select]
$sql2 = "CREATE TEMPORARY TABLE temp_search
    (plant_id INT PRIMARY KEY AUTO_INCREMENT,
     scientific_name VARCHAR(75),
     common_name VARCHAR(75),
     leaf_shape VARCHAR(75))";

$sqlx = "SELECT
                        descriptors.leaf_shape
                        ,plantae.scientific_name, plantae.common_name
                    FROM
                        descriptors
                    INNER JOIN
                        plantae ON (descriptors.plant_id = plantae.plant_name)
                    WHERE
                        descriptors.leaf_shape LIKE 'auriculate'
                        AND descriptors.leaf_venation LIKE '%$select3%'
                        AND descriptors.leaf_margin LIKE '%$select4%'

                    INTO temp_search (leaf_shape, scientific_name, common_name)";

$sql = "SELECT * FROM temp_search ORDER BY scientific_name ASC LIMIT $start, $limit";

$result = mysql_query($sql);


while($row = mysql_fetch_array($result))
{
echo  $row['scientific_name'] . $row['common_name'] . $row['leaf_shape'] ;
}

I set up functionality for a client that got moved to their server after I wrote and tested the functionality.  It does not work on their server and I am trying to trouble shoot the problem as I do not have ftp access to the server. I believe that I have narrowed it down to either I do not know how to access the temp files on their server, Windows IIS, OR the security on the server is not allowing me to upload to the temp files. Here is the form used to upload to the server.   <form  enctype="multipart/form-data"  action="#" method="post" >
    <input type="hidden" name="upload_csv" value="TRUE" />
    <p><label  for="userfile">Upload CSV:</label>
    <input type="hidden" name="MAX_FILE_SIZE" value="45000000" />
    <input type="file" id="userfile" name="userfile" title="userfile" value="" /></p>
    <p><input  type="submit" name="upload_csv" value="Upload CSV" /></p>    
</form>     Here is the test code:   <?php
$csvfile = $_FILES['userfile']['tmp_name'];
$size = $_FILES['userfile']['size'];

if($_POST['upload_csv']){
    //---------------------------------validation code here
    if($problem){
        echo '<div class="error">Did not pass validation</div>';
        include("upload_csv.inc.php");
    }else{
        if (($handle = fopen($csvfile, "r")) !== FALSE) {                 //--------------------------------------------------------------this is where the code that imports the data from the csv and to the database goes
                echo '<div class="message"><p>CSV has been opened!</p></div>';
        }elseif(!$csvfile){
                echo '<div class="error">Problem #1</div>';
        }else{
                echo '<div class="error">Problem #2</div>';
        }
    }
}else{
    include("upload_csv.inc.php");
}
?>     This code generated the error message: Problem #2. One more bit of information: the permissions on the server is set so that nothing can be uploaded by an external script. I do not know much about servers, but it seems to me that because the security is so tight on the server, the security is the reason that this does not work...???   I appreciate help with this. I just am not knowledgeable on how the $_FILES['userfile']['tmp_name'] code actually works?

I am trying to split a simple string from my db
it is in the format #/#
1/5
2/5
3/3
4/2
etc...

I have the following:

Code: [Select]

echo $value.'<BR>';
       
$temp=explode('/',$value['field']);
     
print_r($temp);

echo '<br>';

when I execute the above (it's in a for loop) I get the following output

1/5
Array ( => 1 )
2/5
Array ( => 2 )
3/3
Array ( => 3 )
4/2
Array ( => 4 )
 

I am expecting
1/5
Array ( => 1 [1] => 5)
for the first entry and so on down the line showing both values after the explode. 

Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Untitled Document</title>
</head>
<body>
<?php
$hostname='xxx';
$username='xxx';
$password='xxx';
$dbname='xxx;
$usertable=xxx;


$myconn=mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');

if ((($_FILES["file"]["type"] =="image/gif")
|| ($_FILES["file"]["type"] =="image/jpeg")
|| ($_FILES["file"]["type"] == "image/png"))
&& ($_FILES["file"]["size"]< 200000))
{
if ($_FILES["file"]["error"] >0)
{
echo "Return Code: " . $_FILES["file"]["error"] . "<br/>";
}
else
{
if (file_exists("uploads/" . $_FILES["file"]["name"]))
{
echo "File already exists. Choose another name.";
}
else
{
move_uploaded_file($_FILES["file"]["tmp_name"],"uploads/" . $_FILES["file"]["name"]);
}
}
}
else
{
echo "Invalid file";
}
$path="uploads/" . $_FILES["file"]["name"];
$desc=$_POST["desc"];
if (!myconn)
{
die ('Could not connect: ' . $mysql_error());
 } 
 $db_selected=mysql_select_db('xxx',$myconn);
 if (!$db_selected) {
    die ('Can\'t use xxxx : ' . mysql_error());
} 
  mysql_query("INSERT INTO partners (desc,photopath,state) VALUES ('$desc','$path','$state')");
  mysql_close($myconn);
?>
</body>
</html>

Hello,

We've been working on a page that allows users to create their own avatar to be displayed on their page.

We can get the script working but the only way to show the image is to  save it to a temp folder, we want to just save the string in the database and let the php show this wehen required here are the file


http://test.digitaldemocracy.org.uk/test_avatar.php


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="author" content="John Munro, Democratise Ltd" />
<meta name="copyright" content="Democratise Ltd 2010" />
<meta name="description" content="Digital Democracy -" />
<meta name="keywords" content=" add here" />
<meta name="robots" content="index, follow" />
<meta name="revisit-after" content="1 week" />
<meta http-equiv="Page-Exit" content="blendTrans(Duration=0.5)" />
<link rel="SHORTCUT ICON" href="http://www.digitaldemocracy.co.uk/favicon.ico" />
<title>Digital Democracy -</title>
<link href="css/site.css" rel="stylesheet" type="text/css" />
<link href="css/basic.css" rel="stylesheet" type="text/css" />


<link rel="stylesheet" href="avatars/avatar.css" type="text/css" />
<script type="text/javascript" src="avatars/avatar.js"></script>



<style type="text/css">
/*<![CDATA[*/
<!--
body {
   background-image: url(images/background_paper.jpg);
   background-repeat: repeat;
}
-->
/*]]>*/
</style>

<script type="text/javascript">
//<![CDATA[

  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-15681567-1']);
  _gaq.push(['_trackPageview']);

  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();

//]]>
</script>
</head>




<body>

<div id="wrapper">
<div id="inner_wrapper">

<div class="header">

<div class="header_logo">
<img src="images/header_logo.png" width="190" height="55" alt="Digital Democracy" />
</div>

<div class="header_link">
Make a<br/>proposal
</div>
<div class="header_link_spacer">
<img src="images/header_link_spacer.png" width="5" height="55" alt="Digital Democracy - Link Spacer image" />
</div>

<div class="header_link">
View<br/>proposal
</div>
<div class="header_link_spacer">
<img src="images/header_link_spacer.png" width="5" height="55" alt="Digital Democracy - Link Spacer image" />
</div>

<div class="header_link">
Vote on top<br/>proposal
</div>
<div class="header_link_spacer">
<img src="images/header_link_spacer.png" width="5" height="55" alt="Digital Democracy - Link Spacer image" />
</div>

<div class="header_link">
View<br/>results
</div>
<div class="header_link_spacer">
<img src="images/header_link_spacer.png" width="5" height="55" alt="Digital Democracy - Link Spacer image" />
</div>

<div class="header_link_single_line">
Profile
</div>
<div class="header_link_spacer">
<img src="images/header_link_spacer.png" width="5" height="55" alt="Digital Democracy - Link Spacer image" />
</div>

<div class="header_link_single_line">
More
</div>

<div id="header_search_bar">
<form action="Search" method="post">
  <input name="Search" type="text" value="Search" size="15" />
  <input name="Submit" type="button" value="Go" />
</form>
</div>

<div class="header_login">
<span class="header_login_text">Login / Register</span>
</div>

</div>






<div id="info">


<div id="chosen_avatar">
 
 <!--<p> avatar to be shown here when completed only - image shown below is thee to reference the saved code</p>-->
 
 

<p><img src="<?php if (!empty($image)) { echo $filename; } else { echo 'http://test.digitaldemocracy.org.uk/avatar_creator.php?avatar[background]=bg_08&avatar[body]=body_01&avatar[head]=head_01&avatar[eyes]=blank&avatar[mouth]=blank&avatar[moustache]=blank&avatar[glasses]=blank&avatar[male_hair]=blank&avatar[female_hair]=blank';} ?>" title="Your chosen avatar (assembled as a PNG image)" alt="Your chosen avatar (PNG image)" /></p>
  <p>Your chosen avatar</p>
</div>

<form action="http://test.digitaldemocracy.org.uk/avatar_creator.php" method="get">

<div id="avatar_section">

<div id="avatar_stack">
<p>
<img src="avatars/bg_01.png" alt="" /><input name="avatar[background]" type="radio" value="bg_01" checked="checked" />
<img src="avatars/bg_02.png" alt="" /><input name="avatar[background]" type="radio" value="bg_02" />
<img src="avatars/bg_03.png" alt="" /><input name="avatar[background]" type="radio" value="bg_03" />
<img src="avatars/bg_04.png" alt="" /><input name="avatar[background]" type="radio" value="bg_04" />
<img src="avatars/bg_05.png" alt="" /><input name="avatar[background]" type="radio" value="bg_05" />
<img src="avatars/bg_06.png" alt="" /><input name="avatar[background]" type="radio" value="bg_06" />
<img src="avatars/bg_07.png" alt="" /><input name="avatar[background]" type="radio" value="bg_07" />
<img src="avatars/bg_08.png" alt="" /><input name="avatar[background]" type="radio" value="bg_08" />
<img src="avatars/bg_09.png" alt="" /><input name="avatar[background]" type="radio" value="bg_09" />
</p>

<p>
<img src="avatars/body_01.png" alt="" /><input name="avatar[body]" type="radio" value="body_01" checked="checked" />
<img src="avatars/body_02.png" alt="" /><input name="avatar[body]" type="radio" value="body_02" />
<img src="avatars/body_03.png" alt="" /><input name="avatar[body]" type="radio" value="body_03" />
<img src="avatars/body_04.png" alt="" /><input name="avatar[body]" type="radio" value="body_04" />
<img src="avatars/body_05.png" alt="" /><input name="avatar[body]" type="radio" value="body_05" />
<img src="avatars/body_06.png" alt="" /><input name="avatar[body]" type="radio" value="body_06" />
<img src="avatars/body_07.png" alt="" /><input name="avatar[body]" type="radio" value="body_07" />
<img src="avatars/body_08.png" alt="" /><input name="avatar[body]" type="radio" value="body_08" />
</p>


<p>
<img src="avatars/head_01.png" alt="" /><input name="avatar[head]" type="radio" value="head_01" checked="checked" />
<img src="avatars/head_02.png" alt="" /><input name="avatar[head]" type="radio" value="head_02" />
<img src="avatars/head_03.png" alt="" /><input name="avatar[head]" type="radio" value="head_03" />
<img src="avatars/head_04.png" alt="" /><input name="avatar[head]" type="radio" value="head_04" />
<img src="avatars/head_05.png" alt="" /><input name="avatar[head]" type="radio" value="head_05" />
<img src="avatars/head_06.png" alt="" /><input name="avatar[head]" type="radio" value="head_06" />
<img src="avatars/head_07.png" alt="" /><input name="avatar[head]" type="radio" value="head_07" />
<img src="avatars/head_08.png" alt="" /><input name="avatar[head]" type="radio" value="head_08" />
</p>


<p>
<img src="avatars/blank.png" alt="" /><input name="avatar[eyes]" type="radio" value="blank" checked="checked" />
<img src="avatars/eyes_1.png" alt="" /><input name="avatar[eyes]" type="radio" value="eyes_1" />
<img src="avatars/eyes_2.png" alt="" /><input name="avatar[eyes]" type="radio" value="eyes_2" />
<img src="avatars/eyes_3.png" alt="" /><input name="avatar[eyes]" type="radio" value="eyes_3" />
<img src="avatars/eyes_4.png" alt="" /><input name="avatar[eyes]" type="radio" value="eyes_4" />
<img src="avatars/eyes_5.png" alt="" /><input name="avatar[eyes]" type="radio" value="eyes_5" />
<img src="avatars/eyes_6.png" alt="" /><input name="avatar[eyes]" type="radio" value="eyes_6" />
</p>

<p>
<img src="avatars/blank.png" alt="" /><input name="avatar[mouth]" type="radio" value="blank" checked="checked" />
<img src="avatars/mouth_1.png" alt="" /><input name="avatar[mouth]" type="radio" value="mouth_1" />
<img src="avatars/mouth_2.png" alt="" /><input name="avatar[mouth]" type="radio" value="mouth_2" />
<img src="avatars/mouth_3.png" alt="" /><input name="avatar[mouth]" type="radio" value="mouth_3" />
<img src="avatars/mouth_4.png" alt="" /><input name="avatar[mouth]" type="radio" value="mouth_4" />
<img src="avatars/mouth_5.png" alt="" /><input name="avatar[mouth]" type="radio" value="mouth_5" />
<img src="avatars/mouth_6.png" alt="" /><input name="avatar[mouth]" type="radio" value="mouth_6" />
</p>

<p>
<img src="avatars/blank.png" alt="" /><input name="avatar[moustache]" type="radio" value="blank" checked="checked" />
<img src="avatars/moustache_01.png" alt="" /><input name="avatar[moustache]" type="radio" value="moustache_01" />
<img src="avatars/moustache_02.png" alt="" /><input name="avatar[moustache]" type="radio" value="moustache_02" />
<img src="avatars/moustache_03.png" alt="" /><input name="avatar[moustache]" type="radio" value="moustache_03" />
<img src="avatars/moustache_04.png" alt="" /><input name="avatar[moustache]" type="radio" value="moustache_04" />
</p>



<p>
<img src="avatars/blank.png" alt="" /><input name="avatar[glasses]" type="radio" value="blank" checked="checked" />
<img src="avatars/glasses_01.png" alt="" /><input name="avatar[glasses]" type="radio" value="glasses_01" />
<img src="avatars/glasses_02.png" alt="" /><input name="avatar[glasses]" type="radio" value="glasses_02" />
<img src="avatars/glasses_03.png" alt="" /><input name="avatar[glasses]" type="radio" value="glasses_03" />
<img src="avatars/glasses_04.png" alt="" /><input name="avatar[glasses]" type="radio" value="glasses_04" />
<img src="avatars/glasses_05.png" alt="" /><input name="avatar[glasses]" type="radio" value="glasses_05" />
<img src="avatars/glasses_06.png" alt="" /><input name="avatar[glasses]" type="radio" value="glasses_06" />
<img src="avatars/glasses_07.png" alt="" /><input name="avatar[glasses]" type="radio" value="glasses_07" />
</p>

<p>
<img src="avatars/blank.png" alt="" /><input name="avatar[hair 1]" type="radio" value="blank" checked="checked" />
<img src="avatars/m_hair_01.png" alt="" /><input name="avatar[hair 1]" type="radio" value="m_hair_01" />
<img src="avatars/m_hair_02.png" alt="" /><input name="avatar[hair 1]" type="radio" value="m_hair_02" />
<img src="avatars/m_hair_03.png" alt="" /><input name="avatar[hair 1]" type="radio" value="m_hair_03" />
<img src="avatars/m_hair_04.png" alt="" /><input name="avatar[hair 1]" type="radio" value="m_hair_04" />
<img src="avatars/m_hair_05.png" alt="" /><input name="avatar[hair 1]" type="radio" value="m_hair_05" />
<img src="avatars/m_hair_06.png" alt="" /><input name="avatar[hair 1]" type="radio" value="m_hair_06" />
<img src="avatars/m_hair_07.png" alt="" /><input name="avatar[hair 1]" type="radio" value="m_hair_07" />
<img src="avatars/m_hair_08.png" alt="" /><input name="avatar[hair 1]" type="radio" value="m_hair_08" />
</p>

<p>
<img src="avatars/blank.png" alt="" /><input name="avatar[hair 2]" type="radio" value="blank" checked="checked" />
<img src="avatars/f_hair_01.png" alt="" /><input name="avatar[hair 2]" type="radio" value="f_hair_01" />
<img src="avatars/f_hair_02.png" alt="" /><input name="avatar[hair 2]" type="radio" value="f_hair_02" />
<img src="avatars/f_hair_03.png" alt="" /><input name="avatar[hair 2]" type="radio" value="f_hair_03" />
<img src="avatars/f_hair_04.png" alt="" /><input name="avatar[hair 2]" type="radio" value="f_hair_04" />
<img src="avatars/f_hair_05.png" alt="" /><input name="avatar[hair 2]" type="radio" value="f_hair_05" />
<img src="avatars/f_hair_06.png" alt="" /><input name="avatar[hair 2]" type="radio" value="f_hair_06" />
<img src="avatars/f_hair_07.png" alt="" /><input name="avatar[hair 2]" type="radio" value="f_hair_07" />
<img src="avatars/f_hair_08.png" alt="" /><input name="avatar[hair 2]" type="radio" value="f_hair_08" />
</p>


</div>

</div>

<p>&nbsp;</p>

<p id="submit" >
<input type="submit" value="Click here to save your personalised Avatar" />
</p>

</form>
 
 
 

<div id="hidden_spacer">
<p>&nbsp;</p>
</div>



</div>




</div>
</div>





<div class="footer">

<div class="footer_content">
<div id="footer_democratise">
  &copy; Democratise Ltd
</div>

<div class="footer_link_single_line">
About us
</div>
<div class="footer_link_spacer">
<img src="images/header_link_spacer.png" width="5" height="55" alt="Digital Democracy - Link Spacer image" />
</div>

<div class="footer_link_single_line">
Contact
</div>
<div class="footer_link_spacer">
<img src="images/header_link_spacer.png" width="5" height="55" alt="Digital Democracy - Link Spacer image" />
</div>

<div class="footer_link_single_line">
Blog
</div>
<div class="footer_link_spacer">
<img src="images/header_link_spacer.png" width="5" height="55" alt="Digital Democracy - Link Spacer image" />
</div>

<div class="footer_link_single_line">
Help
</div>
<div class="footer_link_spacer">
<img src="images/header_link_spacer.png" width="5" height="55" alt="Digital Democracy - Link Spacer image" />
</div>

<div class="footer_link_single_line">
Facebook
</div>
<div class="footer_link_spacer">
<img src="images/header_link_spacer.png" width="5" height="55" alt="Digital Democracy - Link Spacer image" />
</div>

<div class="footer_link_single_line">
Twitter
</div>
<div class="footer_link_spacer">
<img src="images/header_link_spacer.png" width="5" height="55" alt="Digital Democracy - Link Spacer image" />
</div>

<div class="footer_link_single_line">
Privacy
</div>

</div>
</div>


</body>
</html>
   
   
And the file that runs the php and creates the images is

<?php



# form inputs in the correct stacking order from bottom to top

$form_fields = array('background', 'body', 'head', 'eyes', 'mouth', 'moustache', 'glasses', 'hair 1', 'hair 2');



ob_start();

if(!isset($_GET['avatar'])) die;

validate_inputs($form_fields);

$filename = create_avatar($form_fields);
//ob_end_clean();

//echo "hello";

//$image = output_image(ob_get_clean());
$image_output = ob_get_contents();
//ob_end_clean();

//echo $image;
//$image = ob_get_contents();

//$image="data:image/png;base64, base64_encode($image)";
$image = 'test.digitaldemocracy.org.uk' . $_SERVER['REQUEST_URI'];
//$image = $_SERVER['REQUEST_URI'];
//echo $image;




function validate_inputs($inputs)

{

    foreach($inputs as $item)

    {

        if((preg_match('@(\.|/)@', $_GET['avatar'][$item]))

        or (!is_file('avatars/'.$_GET['avatar'][$item].'.png')))

        {

            die();

        }

    }

}



function create_avatar($inputs)

{

    while($inputs)

    {

        $layer = @imagecreatefrompng('avatars/'.

                 ($file = $_GET['avatar'][array_shift($inputs)]).

                 '.png')

                 or die('I could not open the avatars/'.$file);

        $layerWidth = imageSX($layer);

        $layerHeight = imageSY($layer);

        if(!isset($slate))

        {

            $slate = @imagecreatetruecolor($layerWidth, $layerHeight);

        }

        @imagecopy($slate, $layer, 0, 0, 0, 0, $layerWidth, $layerHeight);

        @imagedestroy($layer);

    }


    imagetruecolortopalette ($slate, false, 256);
   
   //header('Content-Type: image/png');
   $filename = 'temp'. rand(1,50) . '.png';

    imagepng($slate, $filename);
   //imagepng($slate);


    imagedestroy($slate);
   
   return $filename;

}



function output_image($image)

{

    $hash = md5($image);

    if(isset($_SERVER['HTTP_IF_NONE_MATCH'])){

        if($hash == trim($_SERVER['HTTP_IF_NONE_MATCH'], '"')){

            header("HTTP/1.x 304 Not Modified");

            header('Etag: "'.$hash.'"');

            die();

        }

    }

    //header('Etag: "'.$hash.'"');

   //header('Content-Type: image/png');
   
   //imagepng($image);
    //echo $image;
   //return $image;

}

//header ("Location:test_avatar.php?image=$image");

include 'test_avatar.php';


?>


If anybody can help us it would be very appreciated

Thanks

John Munro
Democratise.org

This topic has been moved to PHP Installation & Configuration.

http://www.phpfreaks.com/forums/index.php?topic=343981.0

Okay, so I'm kind of a PHP noob.   But out of context, for this site that I'm designing, it's easiest if I make a directory in the temporary folder PHP uses. In my case, /tmp/ because I am on Linux.   I want to use rand() to generate a random name for the page. But I then realized something, rand() could produce duplicates. How do I prevent PHP from trying to make the same directory at the same time? I know there are functions that will check if a file exists but I'm assuming it'll fail if that directory is currently being created, right?   How do I assure thread safety?   I willing to change my idea and not use rand(). Is there a way to get a unique key for each anonymous user on my site?

Hello guys,