PHP - Need Help Arranging Text Blob Into Different Sections.

Hi guys,

I have a php script to arrange my data my title, location and date. However, when the data is arranged by date it is arranged with the earliest date first, I want it to arrange it as the latest date first, how do I do this?

Regards

Code: [Select]
//

//orderBy
if(isset($_GET['orderBy'])){
switch ($_GET['orderBy']){
case "date":
$orderBy = " ORDER BY `Date Added` ASC";
break;
case "title":
$orderBy = " ORDER BY `Title` ASC";
break;
case "location":
$orderBy = " ORDER BY `Location` ASC";
break;
default:
break;
}
}

I have a code that outputs a table but right now each result is under the next ex:

1
2
3
1
2
3
I would like them to be horizontal ex:
123
123

the part of the code the controls the table is:
Code: [Select]
echo "<table border=0 cellspacing=0 cellpadding=0>";
foreach($xml->result->rowset->row AS $name)
{
echo "<tr>";
echo "<td><img src=/Character/".$name['characterID']."_200.jpg></td></tr>";
echo "<tr><td>".ucwords($name['name'])."</td></tr>";
echo "<tr><td>".ucwords($name['corporationName'])."</td>";
echo "</tr>";
}
echo "</table>";

Been using a function I found here a while back for listing categories and sub categories and it works perfect.
Code: [Select]
function listSubcats ($parent, $level=0){
global $abc;
$sql = "SELECT id, title FROM Cat WHERE parent = $parent";
$res = mysqli_query($abc, $sql);
while (list($id, $title) = $res->fetch_row()) {
$indent = str_repeat('-', $level);
echo "<OPTION value='$id'>$indent $title</OPTION>\n";
listSubcats ($id, $level+1);                       
// list its subcats
}
}
But this is the first time I need change the way the results are displayed.
And that leads me to realizing I am a bit confused on how list really works.

The mysql table has the typical ID, CatName, parent

I need to have each Cat with all subcats related to it listed in its own div.
But whatever I try I cannot get the placements of the opening and closing divs in the right spots.

So can anyone tell if its even possible to do it with this function.

I did work it out using multiple queries but then read on alot of forums that queries inside while statements is not good.

Just looking for he best (Correct) way of geting the results laid out properly.
 like this
Code: [Select]

<div class="one-third column">
 Cat1
</div>
<div class="one-third column">
 Cat 2
</div>
<div class="one-third column">
 Cat 3
 - Subcat 1
 - Subcat 2
 -- Sub Subcat 1
</div>
<div class="one-third column">
Cat 4
</div>

Hope that makes sense... Thanks for any guidance.

Hi there,

How could I get the value of every 4 bytes of a BLOB? Additionally, how can I add an item to the end of a BLOB and store it back in the database?

Cheers,
George

Hi, I wonder whether someone may be able to help me please.

Through articles I've read on the Interent I've put together the code shown below which allows a user to upload, view and delete image files from a mySQL database.

Code: [Select]
if (!mysql_connect($db_host, $db_user, $db_pwd))
    die("Can't connect to database");

if (!mysql_select_db($database))
    die("Can't select database");

// This function makes usage of
// $_GET, $_POST, etc... variables
// completly safe in SQL queries
function sql_safe($s)
{
    if (get_magic_quotes_gpc())
        $s = stripslashes($s);
 
    return mysql_real_escape_string($s);
}
 
// If user pressed submit in one of the forms
if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
    if (!isset($_POST["action"]))
    {
        // cleaning title field
        $title = trim(sql_safe($_POST['title']));
 
        if ($title == '') // if title is not set
            $title = '(No title provided';// use (empty title) string
 
        if (isset($_FILES['photo']))
        {
            @list(, , $imtype, ) = getimagesize($_FILES['photo']['tmp_name']);
            // Get image type.
            // We use @ to omit errors

            if ($imtype == 3) // cheking image type
                $ext="png";   // to use it later in HTTP headers
            elseif ($imtype == 2)
                $ext="jpeg";
            elseif ($imtype == 1)
                $ext="gif";
            else
                $msg = 'Error: unknown file format';
 
            if (!isset($msg)) // If there was no error
            {
                $data = file_get_contents($_FILES['photo']['tmp_name']);
                $data = mysql_real_escape_string($data);
                // Preparing data to be used in MySQL query
 
                mysql_query("INSERT INTO {$table}
                                SET ext='$ext', title='$title',
                                    data='$data'");
 
                $msg = 'Success: Image Uploaded';
            }
        }
        elseif (isset($_GET['title']))      // isset(..title) needed
            $msg = 'Error: file not loaded';// to make sure we've using
                                            // upload form, not form
                                            // for deletion

elseif($_FILES["fileupload"]["size"]/1024000 >= 10) // 10mb
{     
$msg = "<br />Your uploaded file size:<strong>[ ". $_FILES["fileupload"]["size"]/1024000  . " MB]</strong> is more than allowed 10MB Size.<br />";       
}

        if (isset($_POST['del'])) // If used selected some photo to delete
        {                         // in 'uploaded images form';
            $imageid = intval($_POST['del']);
            mysql_query("DELETE FROM {$table} WHERE imageid=$imageid");
            $msg = 'Photo deleted';
        }
 
        if (isset($_POST['view'])) // If used selected some photo to delete 
        { // in 'uploaded images form'; 
            $imageid = intval($_POST['view']); 
            mysql_query("SELECT ext, data FROM {$table} WHERE imageid=$imageid"); 
 
            if(mysql_num_rows($result) == 1) 
            { 
                $image = $row['myimage']; 
                header("Content-type: image/gif"); // or whatever 
                print $image; 
                exit; 
            } 
        } 
    }
    else
    {
        $imageid = intval($_POST['del']);
 
        if ($_POST["action"] == "view")
        {
            $result = mysql_query("SELECT ext, UNIX_TIMESTAMP(imagetime), data
                                     FROM {$table}
                                    WHERE imageid=$imageid LIMIT 1");
 
            if (mysql_num_rows($result) == 0)
                die('no image');
 
            list($ext, $imagetime, $data) = mysql_fetch_row($result);
 
            $send_304 = false;
            if (php_sapi_name() == 'apache') {
                // if our web server is apache
                // we get check HTTP
                // If-Modified-Since header
                // and do not send image
                // if there is a cached version
 
                $ar = apache_request_headers();
                if (isset($ar['If-Modified-Since']) && // If-Modified-Since should exists
                    ($ar['If-Modified-Since'] != '') && // not empty
                    (strtotime($ar['If-Modified-Since']) >= $imagetime)) // and grater than
                    $send_304 = true;                                     // imagetime
            }
 
            if ($send_304)
            {
                // Sending 304 response to browser
                // "Browser, your cached version of image is OK
                // we're not sending anything new to you"
                header('Last-Modified: '.gmdate('D, d M Y', $ts).' GMT', true, 304);
 
                exit(); // bye-bye
            }
 
            // outputing HTTP headers
            header('Content-Length: '.strlen($data));
            header("Content-type: image/{$ext}");
 
            // outputing image
            echo $data;
            exit();
        }
        else if ($_POST["action"] == "delete")
        {
            $imageid = intval($_POST['del']);
            mysql_query("DELETE FROM {$table} WHERE imageid=$imageid");
            $msg = 'Photo deleted';
        }
    }
}
?>

The problem I'm having is around the error message shown if the File Size is over the prescribed limit.

The part of the script that deals with this starts with the line: Code: [Select]
elseif($_FILES["fileupload"]["size"]/1024000 >= 10) // 10mb
Even though the file upload may fail because of the size of the file I receive the 'Error: unknown file format' message, and I'm not sure why.

I'm certainly no expert when it comes to PHP, so perhaps my lack of knowledge is letting me down.

But I just wondered if someone could perhaps take a look at this please and let me know where I'm going wrong.

Many thanks

Chris

Hi I have create a script that adds a image as blob successfully,
however now I want to create a thumbnail, I have the following code; can someone help...

# open and code into blob
$fp = fopen($safename, 'r');
$content = fread($fp, filesize($safename));
$thumb = $content;
$content = addslashes($content);
fclose($fp);

# resize accordingly...
$thumb = new resize($content, $width, $height, 300);

# the class that does the resizing (WHERE I THINK ITS GONE WRONG)
class resize {
 public $new_image_blob = "";
 function __construct($blob, $width, $height, $amount) {
   
  # the maximum width and height as set by the user
  $thumb_height_max   = $amount;
  $thumb_width_max = $amount;
   
  # maintain aspect ratio landscape or portrait
  if($width < $height) {
   $new_width = ($thumb_height_max / $height) * $width;
   $new_height = $thumb_height_max;
   $needtoresize   = ($height < $thumb_height_max);
  } else {
   $new_width = $thumb_width_max;
   $new_height = ($thumb_width_max / $width) * $height;
   $needtoresize = ($width < $thumb_width_max);
  }   
   
  # now that we have the new width and heightwe need to resize the blob
  $im = imagecreatefromstring($blob);
  $thumb = imagecreatetruecolor($new_width, $new_height);
  imagecopyresampled($thumb, $im, 0, 0, 0, 0, $new_width, $new_height, ImageSX($im), ImageSY($im));
  $this->new_image_blob = addslashes($thumb);
 }
}

# then the query below adds the code (the original blob goes in correctly (ablob) but bblob (the resized blob doesn't))
$iS = "INSERT INTO $tableb (pal, afield, bfield, cfield, dfield, efield, ffield, gfield, ablob, bblob, cblob, dblob) VALUES
('6', '$fk', '$filename', '$size', '$fileExtension', '$width', '$height', '$orientation', '$content', '$thumb->new_image_blob', '$four', '$two')";

Hi,

I have a MySQL database with BLOB data (MS Word files, Excel, PowerPoint, PDF etc.). I have a show_file function that assembles the blobs to send the file to the browser. It's been working great for a decade. Now, I am looking to filter the data against XSS vulnerabilities, much like I do with strings using htmlentities(). How do you go about doing that with BLOB data? I'm assuming htmlentities() will strip out characters from the BLOB data that will render the file unusable, correct? Here is my function:

function show_file( $fileID ) {
$nodeList = array();
$fileInfo = get_record( 'FileList', 'fileID', $fileID ) or trigger_error( 'Not a valid file ID: ' . $fileID );
// Pull list of inodes
$nodes    = get_recordset( 'FileData', 'fileID', $fileID, 'blobID' );
if ( !$nodes ) { trigger_error( 'Failure to retrieve file inodes: ' . mysql_error() ); }  
while ( $node = mysql_fetch_array( $nodes ) ) { $nodeList[] = $node['blobID']; }
// Send down the header to the client
if ( strpos( $_SERVER['HTTP_USER_AGENT'], 'MSIE' ) ) { header( 'Cache-Control: public' ); }
header( 'Content-Type: ' . $fileInfo['fileType'] );
header( 'Content-Length: ' . $fileInfo['fileSize'] );
header( 'Content-Disposition: attachment; filename=' . $fileInfo['fileName'] );
// Loop thru and stream the nodes 1 by 1
for ( $z = 0; $z < count( $nodeList ); $z++ ) {
$query = 'SELECT fileData FROM FileData WHERE blobID = ' . $nodeList[$z];
if ( $result = mysql_query( $query ) ) {
echo mysql_result( $result, 0 );
} else {
trigger_error( 'Failure to retrieve file node data: ' . mysql_error() );
}
}
}


So, I am looking to do something like echo mysql_result( htmlentities($result), 0 );

Thanks for any help you may provide,
George.

I have an array, and to make it easy let's say they have 2 values: ET and SPEED
Here is an example chart of the array printed out:

KEY        ET          SPEED
8           5.2          60
3           5.3          60
1           5.4          70
7           5.4          60
9           5.4          90
6           5.5          60
5           5.6          60
2           5.6          65
4           5.7          60

I need to take this array and each group that has a matching ET, put them in order based on SPEED. The corrected chart should be like this:

KEY        ET          SPEED
8           5.2          60
3           5.3          60
9           5.4          90
1           5.4          70
7           5.4          60
6           5.5          60
2           5.6          65
5           5.6          60
4           5.7          60

Just not sure of how to only arrange the section that need to be. Keys stay the same, just the order changes.

so i have this string that i want to search on the database

My database has 3 parts city, state, country

and i have a string that is say "new york city, ny, united states"

and i want to be able to be able to look into the database but search those three sections so for example

"New York City" i would like to search under city
"NY" i want it to search under state
and "United States" i want to search under country

so basically how can i split the string  into those three sections??

hope someone can help me with this

Hello,
I am storing files that my users upload to the website as a blob in mysql database. Here is the code that does uploading:
$fileName = $_FILES['userfile']['name'];
$tmpName  = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];
$fp      = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = mysql_real_escape_string($content);
fclose($fp);
if(!get_magic_quotes_gpc())
{
   $fileName = addslashes($fileName);
}
$query = mysql_query("INSERT INTO documents (idapplicant, fileType, fileSize, fileData, fileName)
         VALUES ('$idapplicant','$fileType','$fileSize', '$content','$fileName')",$db);

Here is the code for download:
echo "File found:".@mysql_result($result, 0, "fileID"); //always correct
$data = @mysql_result($result, 0, "fileData");
$name = @mysql_result($result, 0, "fileName");
$size = @mysql_result($result, 0, "fileSize");
$type = @mysql_result($result, 0, "fileType");

header("Content-length: $size");
header("Content-type: $type");
header("Content-Disposition: attachment; filename=$name");
echo $data;

I can upload/download files no problem. However, I noticed problem with GIF files. All GIF files are just dark screen after downloading. All other files (PDF, JPEG) looked just fine. I compared files (before upload and after download) in HEX editor and found that the first byte on all files is set to A0 (it is added in front of all the data) and the last byte is deleted!
I have tried:
$content = addslashes($content);

instead of:
$content = mysql_real_escape_string($content);
with the same results
I also tried removing this line of code and in that case no file would be uploaded at all!
Any idea?
Thank you

Hi guys,

I have a feeling the answer to this will be something incredibly simple I will be amazed I have failed to overlook but lets see.

I have a database currently storing images as BLOB, it appears to be holding them fine, my upload page works fine to put images there etc
The issue is coming when trying to display the images on an alternate page.

I am using the code below, and it seems to recognize the field, however it is not displaying an image, it is displaying code.
I have a feeling I need to add something to my headers to allow the page to show the images, but am not 100% sure.
If someone could let me know what I am missing it would be great.
Thanks in advance.

Code: [Select]
<?
include "config.php";
$query = mysql_query("Select * FROM app_images WHERE image_month='test' ") or die(mysql_error());
while ($row = mysql_fetch_array($query)) {
echo " " .$row['image']. " <br /><br />";}
?>

Hi,

I am having a wierd problem and I dont know what is causing it - PHP/MySql.?

Server  - Apache on Fedora
Php - 5.3.2
MySql - 5.1.47

In the same server config I have implemented storing files into blob fields any type of file by using mysql as well as mysqli.
The one implemented by mysql is working just fine.

But the one using mysqli is not working for anything other than text files.
For image files the following error is coming -
Error interpreting JPEG image file (Not a JPEG file: starts with 0x0a 0xff)
For word/pdf etc the files are getting corrupted in such a way that the concerned application is not recognising it as a valid document.




/*MySQL
using mysql_connect
Storing*/
$name=trim($_POST['fname']);
$desc=trim($_POST['description']);
$file=$_FILES['formfile']['name'];
$filetype=$_FILES['formfile']['type'];
$filename=$_FILES['formfile']['tmp_name'];
$fileerror=$_FILES['formfile']['error'];
$filesize=$_FILES['formfile']['size'];

$fp = fopen($filename, 'r');
$content = fread($fp, filesize($filename));
fclose($fp);
if (!get_magic_quotes_gpc())
{
$content = addslashes($content);
$name=addslashes($name);
}

$query="insert into forms_master (name, description, data, filename, filesize, filetype, entrydate) values (";
$query.="'$name', '$desc', '$content', '$file', '$filesize', '$filetype', now())";

/*Retreiving*/
$id=$_GET[sha1('id')];
$form=mysql_fetch_array(mysql_query("select filename, filesize, filetype, data from forms_master where sha1(id)='$id'", $link));
header("Content-length: ".$form['filesize']);
header("Content-type: ".$form['filetype']);
header("Content-Disposition: attachment; filename=".$form['filename']);
print $form['data'];


Works absolutely fine


/*MySQL using mysqli_connect
Storing
*/
$file=$_FILES['fname'];
$name=$file['name'];
$tmp_name=$file['tmp_name'];
$size=$file['size'];
$type=$file['type'];
$fp = fopen($tmp_name, 'r');
$content = fread($fp, filesize($tmp_name));
fclose($fp);
$content = mysqli_real_escape_string($link, $content);
$name=mysqli_real_escape_string($link, $name);
 
$query="insert into document_master (name, size, filetype, data) values ('$name', '$size', '$type', '$content')";

//Retreiving
$id=$_GET[sha1('id')];
$file=mysqli_fetch_array(mysqli_query($link, "select name, size, filetype, data from document_master where sha1(id)='$id'"));
header("Content-type: ".$file['filetype']);
header("Content-length: ".strlen($file['size']));
header("Content-Disposition: attachment; filename=".$file['name']);
print $file['data'];



Note.
I uploaded an image file through phpMyAdmin.
Then tried to retreive it via the mysqli code above. The same error came.

Any help will be greatly appreciated.

Hi everyone, i am just trying to learn php for a bit of fun really and started making a sort of 'facebook' website. I am having trouble however trying to display different users images, for example when trying to find a correct 'friend' only the image of the last result is being shown for all people with the same name... here is my code below, if anyone can help me out that would be great

file 1

$count=1; 

while ($numids>=$count){
  echo "<form method=\"post\" action=\"friendadded.php\">";
  $frienduserid=$_SESSION["passedid[$ii]"];
  $friendfirstname=$_SESSION["passedfirstname[$ff]"];
  $friendlastname=$_SESSION["passedlastname[$ll]"];
  $_SESSION['friendsuserpicid'] = $frienduserid;
  echo "<table width=\"700\" height=\"50\" border=\"1\" align=\"center\">";
  echo "<tr>";
  echo "<th></th>";
  echo "<th>First Name</th>";
  echo "<th>Last Name</th>";
  echo "</tr>";
  echo "<tr>";
  echo "<td><center>";
  echo "<img border=\'0\' src=\"frienduserpic.php\" width=\"80\" height=\"80\" align=\"middle\"/>";
  echo "</center></td>";
  echo "<td><center>";
  echo $friendfirstname;
  echo "</center></td>";
  echo "<td><center>";
  echo $friendlastname;
  echo "</center></td>";
  echo "</tr>";
  echo "</table>";
  echo "<center><input type=\"submit\" value=\"Add this friend\" name=\"Add Friend\"></center><br/>";  

  $ii=$ii+1;
  $ff=$ff+1;
  $ll=$ll+1;
  $count=$count+1; 
  
  echo "</form>";
}




file 2

session_start();
$passeduserid=$_SESSION['friendsuserpicid'];
$timespost=$_SESSION['postednum'];
$host= 
$username=
$password=
$db_name= 
$tbl_name=
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$query = mysql_query("SELECT * FROM $tbl_name WHERE picid='".$passeduserid."'");
$row = mysql_fetch_array($query);
$content = $row['image'];
header("Content-type: image/jpeg");
echo $content;


Thanks in advance

I have created a image using imagepng() and then right-click'd and saved it. I then added it to the database by using phpMyAdmin to upload it directly into a field called 'avatar' which is a BLOB. The code the view the image back is the following:

header("Content-type: image/png");
echo mysql_result(mysql_query("SELECT `avatar` FROM `rscd_players` WHERE `username` = 'Kryptix'"), 0);

Now when I try and add the imagepng() directly to the database it doesn't work. I've tried multiple things. Here's the code:

ob_start(); imagepng($char_image); $pngimagedata = ob_get_contents(); ob_end_clean();

mysql_query("UPDATE `rscd_players` SET `avatar` = " . $pngimagedata . " WHERE `username` = 'Kryptix'");

Here's the full code: http://pastebin.com/jqsKc9Qd

This is the query that phpMyAdmin produces: http://pastebin.com/nuypNuwJ

This is the query that the above code produces: http://pastebin.com/NPWmi5eb

phpMyAdmin is 2.2kB, my code is 4.4kB

Any idea? I've been trying all night...

Hi All,

Having issues uploading files larger than 1mb. This is what I have currently as default when I ran phpinfo() (working locally on my machine)...

upload_max_filesize: 432M
post_max_size: 432M
memory_limit: 8M
max_input_time: 60
max_execution_time: 30

I'm looking for the file to be converted into a blob, it works perfectly fine for files less than 1mb, but doesn't even run the mysql query above that.

Any Ideas anyone?

include("../../connect.php");
   
# these settings should help
set_time_limit(0);
   
# going in as a blob from now on
$stamp = mktime();
$safename = $_FILES['Filedata']['tmp_name'];
$filename = $_FILES['Filedata']['name'];
$size = $_FILES['Filedata']['size'];
$type = $_FILES['Filedata']['type'];
$fk = $_REQUEST['fk'];      
$sqlname = $stamp . "-" . $_FILES['Filedata']['name'];
   
# open and code in
$fp = fopen($safename, 'r');
$content = fread($fp, filesize($safename));
$content = addslashes($content);
fclose($fp);
   
$insertS = "INSERT INTO $tableb (pal, afield, bfield, cfield, dfield, efield, ffield, ablob) VALUES
('6', '$fk', '$filename', '$size', '$type', '$width', '$height', '$content')";
   
$insertQ = mysql_query($insertS);
   
print "1";