John_S

Thank you! Worked like a charm!

Hey there! I was asking myself the same question quite some time ago and I found for my self that the answer is yes. Even if in the beginning it might appear frustrating and complicated, once you've learned a framework, your coding will become faster and your code will be easier to read and more structured. However, once you decided to switch to a framework, I strongly suggest you to check out several frameworks at once, and not stopping on the most popular one. Because some popular frameworks might appear interesting, but when you learn out about them, they might appear limited. Another idea might be coding your own framework, using MVC pattern and inspiring you from already existent frameworks. It not only allows you to better understand common used patterns but also create a framework that suits your needs. Some frameworks that would suggest for a beginner: CodeIgniter, Kohana (version 2.x.x, rather than version 3.x because HMVC pattern used in 3.x might be a bit too complicated to understand in the beginning), Cake and Fuse. Hope it helps! John_S

Greetings! Recently I've been reading some php articles, and I found one with an interesting script concept but with an impossibly huge MySQL query which doesn't seem to work, unfortunately complicated MySQL queries aren't my cup of tea, so I wasn't able to fix it, that's why I am here hoping that somebody could help me to solve it. SELECT options.id, options.value, COUNT(*) AS votes FROM votes, FROM 'options' WHERE options.id = votes.option_id AND votes.option_id IN(SELECT id FROM options WHERE ques_id='1') GROUP BY votes.option_id Thank you a lot in advance! John_S

For some reason I couldn't find the way how to format the code correctly, but doesn't matter. Thanks anyway.

That is what I am trying to do, and about the error, I don't get any at all, that's the problem. No error at all but the files are not created in the folders.

Hello everybody,I have recently created an image upload script which not only uploads and resizes the image but also creates a small thumbnail. After that the script saves both thumb and the resized image in two different folders and adds the information into the database. However when I try to test it, I receive an error. Can somebody please help me and tell me what's wrong? I've checked everything but it seems I am either blind or simply can't see the error. Here is my code: <?phpif ((isset($_POST["image_upload"])) && ($_POST["submitted_form"] == "image_upload_form")) { // file needs to be jpg,gif,png and 4 MB max if (($_FILES["image"]["type"] == "image/jpeg" || $_FILES["image"]["type"] == "image/pjpeg" || $_FILES["image"]["type"] == "image/gif" || $_FILES["image"]["type"] == "image/png") || $_FILES["image"]["type"] == "image/bmp" && ($_FILES["image"]["size"] < 4000000)) { // some settings $max_upload_width = 550; $max_upload_height = 550; // if uploaded image was JPG/JPEG if($_FILES["image_upload"]["type"] == "image/jpeg" || $_FILES["image"]["type"] == "image/pjpeg") { $image_source = imagecreatefromjpeg($_FILES["image_upload"]["tmp_name"]); $extension = '.jpeg'; } // if uploaded image was GIF if($_FILES["image_upload"]["type"] == "image/gif") { $image_source = imagecreatefromgif($_FILES["image_upload"]["tmp_name"]); $extension = '.gif'; } // if uploaded image was PNG if($_FILES["image_upload"]["type"] == "image/png") { $image_source = imagecreatefrompng($_FILES["image_upload"]["tmp_name"]); $extension = '.png'; } //If uploaded file was BMP. if($_FILES["image_upload"]["type"] == "image/png") { $image_source = imagecreatefromwbmp($_FILES["image_upload"]["tmp_name"]); $extension = '.bmp'; } $thumnail_name = $_FILES["image_upload"]["name"]; ///////////////////////////////// // Transform the main image. ///////////////////////////////// $_FILES["image_upload"]["name"] = uniqid().$extension; $remote_file = "images/uploads/".$_FILES["image_upload"]["name"]; imagepng($image_source, $remote_file, 100); chmod($remote_file, 0755); // Get width and height of original image list($image_width, $image_height) = getimagesize($remote_file); if($image_width>$max_upload_width || $image_height >$max_upload_height) { $proportions = $image_width/$image_height; if($image_width>$image_height){$new_width = $max_upload_width; $new_height = round($max_upload_width/$proportions); } else{ $new_height = $max_upload_height; $new_width = round($max_upload_height*$proportions); } $new_image = imagecreatetruecolor($new_width , $new_height); $image_source = imagecreatefrompng($remote_file); } imagecopyresampled($new_image, $image_source, 0, 0, 0, 0, $new_width, $new_height, $image_width, $image_height); imagejpeg($new_image,$remote_file,100); imagedestroy($new_image); imagedestroy($image_source); ///////////////////////////////// // Transform the thumbnail image. ///////////////////////////////// $max_thumb_width = 90; $max_thumb_height = 90; //The procedure. $thumnail_name = uniqid()."_thumb".$extension; $remote_thumbnail = "images/uploads/thumbs/".$thumnail_name; imagepng($thumbnail_source, $remote_thumbnail, 100); chmod($remote_thumbnail,0755); // Get width and height of original image list($image_width, $image_height) = getimagesize($remote_thumbnail); if($image_width>$max_thumb_width || $image_height >$max_thumb_height) { $proportions = $image_width/$image_height; if($image_width>$image_height){ $new_width = $max_thumb_width; $new_height = round($max_thumb_width/$proportions); } else{ $new_height = $max_thumb_height; $new_width = round($max_thumb_height*$proportions); } $new_image = imagecreatetruecolor($new_width , $new_height); $image_source = imagecreatefrompng($remote_thumbnail); } imagecopyresampled($new_image, $image_source, 0, 0, 0, 0, $new_width, $new_height, $image_width, $image_height); imagejpeg($new_image,$remote_thumbnail,100); imagedestroy($new_image); imagedestroy($image_source); $db->query("INSERT INTO uploads_images (id,name,url,thumb_url,added_by,date) VALUES (NULL,'".$_FILES["image_upload"]["name"]."','".$remote_file."','".$remote_thumbnail."','".$mybb->user['username']."', '".$date."')"); echo '<blockquote class="green">Image uploaded successfully!</blockquote>'; } else { echo '<blockquote class="red">An error was encountered during the image transfer. Please make sure the file is jpg, gif, png or bmp and that is smaller than 4MB! !</blockquote>'; }}?> <h1 style="margin-bottom: 0px">Submit an image</h1> <div class="article"><div class="article_content"><p>Browse for the file you want to upload and click "Upload".</p> <form action="uploads.php" method="post" enctype="multipart/form-data" name="image_upload" id="image_upload" style="margin-bottom:0px;"> <label>Your file, maximum 4MB. it can be jpg, gif, png:</label><br /> <input name="image_upload" type="file" id="image" size="40" /> <input type="submit" name="submit" value="Upload image" /> <input name="submitted_form" type="hidden" id="submitted_form" value="image_upload_form" /></form> <?php if(isset($remote_thumbnail)) { echo '<p><center><a href="'.$remote_thumbnail.'" rel="lightbox"><img src="'.$remote_thumbnail.'" alt="Picture of the week" /></a></center><br /></p>';}?> </div></div>

Thanks a lot!

Hello everybody,I am trying to write a function which would work similarly to a cron job, each time a visitor will come to my site, the cron function will be called and will check if there is a cronjob to execute. I want to store all the cronjobs within a flat file so there won't be too many connections to the database. However when I test my function it refuses to work, it doesn't output any errors at all, but there is no result displayed neither the flat file database is changed. Could somebody please tell me what's wrong? Here's my code: function cron($name) { $file = file('./crons/crons.db.php'); foreach ($file as $line) { if(ereg("$name", $line)) { $cronjob = explode("|", $line); if (time() >= $cronjob[2]) { include("./crons/$name.cron.php"); } } } // End of Foreach $source = fopen('./crons/crons.db.php', w); foreach ($file as $line) { if(!ereg("$name", $line)) { fwrite($source, $line); } else { $lastrun = time(); $toberun = time() + (24 * 60 * 60); fwrite($source, "|$name|$lastrun|$toberun|$status| "); } } } // End of Fucntion In my files, I call the function like this: cron("db_backup"); [db_backup = databse backup.] Thanks a lot in advance!Yours John_S

Thanks a lot! Yes indded by default the display_error was set to off, and I didn't notice until now. Thanks a lot for your code, it worked exactly as I needed

Hello there, Thanks a lot for your help but sadly when I try that code, I don't have any display at all, the page is blank. Is that normal?

Hello there, Thanks a lot for your answer! Well I actually manage to isolate the table I need, the problem I have is to get the pieces of information that I need from the table rows. I don't get how to do it

Hello there everybody! As the title says I am searching a way to get content from a table on an external webpage. I tried what I could but without any results. I proceeded this way:First I get content from the page with: <?php $source = file_get_contents('URL'); ?> Then I isolate the table I need the info from: <?phppreg_match_all('#<TABLE BORDER=0 CELLPADDING=4 CELLSPACING=1 WIDTH=100%>(.*?)</TABLE>#s', $source, $entries); But when I arrive there, I don't know how to extract table rows and the info I need. The structure of a table row looks like <TR BGCOLOR=" DEPENDS ON THE ROW "><TD WIDTH=10%>Info I need 1</TD><TD WIDTH=55%><A HREF=" AN URL">Info I need 2</A></TD><TD WIDTH=15%>Info I need 3</TD><TD WIDTH=20%>Info I need 4</TD></TR> Does anybody know how I can get that info? Thanks a lot in advance!Yours John_S

Hello there, When I run your code, I receive this : Line 1: <?php die("Access Restricted. You are not allowed to access this file"); ?> Id|Username|Password|Permissions|Last Logged In|Email|Registered| Seems weird to me actually. And when myself I execute my script I got a blank browser window => no output at all. Might it be because the content is "technically" on the same line? (In my editor I see it on two lines but it might be on one if there isn't a proper ) EDIT: Thanks a lot! Your part of code made me realize that two pices <?php... and id|username... were "technically" on the same line since I had "\n"s everywhere but not "\r"s. So even thought I saw the code in my editor being on two different lines, it wasn't like that in the file itself.

Hello everybody, I have a little problem with a small part of code: $users = file("users.db.php"); foreach ($users as $line) { if(!eregi("<\?php",$line)) { $user = explode('|', $line); echo $user[0]."\n".$user[1]."\n".$user[2]."\n".$user[3]."\n".$user[4]; } } I am trying to get out all lines from a file except all lines that start with <?php, the problem is... it doesn't work, it doesn't print anything at all. In that file (users.db.php) I have the following code: <?php die("Access Restricted. You are not allowed to access this file"); ?> Id|Username|Password|Permissions|Last Logged In|Email|Registered| Could somebody tell me please where is my mistake? Thanks a lot in advance!

Thanks! A lot True, but it is allowed (well as far as I know ), a friend of mine uses a specific folder with a txt file for each entry, but personally I think that would be a bit too messy

Hello there! Because I am not allowed, it's a part of a school project, and one of the conditions is: No MySQL or any other database software, only flat files. @rhodesa Thanks a lot for your help. But then how can I search for IDs for example? invert each array and check with in_array()?

Hello there everybody, I am currently writing a small news script which I would like to save all articles into a flat file separating : title, id, date, author,category, content by | sign in the flat file, and then extract these entries to display them. I tried all I could but I don't get how to write that :S Could somebody help please? Thanks a lot in advance!

Hey there, Hmm I would also suggest using htmlspecialchars(), personally I always use a function: <?php function db_protect($string) { return htmlspecialchars(mysql_real_escape_string($string)); } ?> But you have to think about where will the data be sent from, what format will it come in and what will it be used for.

Hey there, I think it doesn't work since it has MySQL specific functions like: sum(duration) or substring(dstchannel,3,6). Also, why are you using the variable $connect twice? Plus there is a better way to do: <?php print "$dstchannel"; print "<br>"; print "$duration"; print "<br>"; ?> Using one and only display function, print "$dstchannel<br>$duration"; but I would suggest you to use "echos" instead of print, in my opinion echos' faster and plus they take multiple expressions. I changed your code a bit, hope it helps. <?php $connect = mysql_pconnect("localhost","user","pass") or Die("connect failed"); mysql_select_db("dbase") or Die("select failed"); $query = "SELECT dstchannel,sum(duration) from cdr where calldate like '2009-03-03%' group by substring(dstchannel,3,6)"; $res = mysql_query($query,$connect) or die("failed"); while($qry = mysql_fetch_array($res)) { $dstchannel=$qry["dstchannel"]; echo "$dstchannel<br>$duration"; }; ?>

Hello, Yes because I use an integrated software that doesn't support sessions :S Anyway, I have solved the issue, all I had to do is to move my code from one file to another and change it just a bit. Thanks for the help anyway!

You are setting the cookie for 1 second from now....try doing it for a bit more than that. Yes I know but if I set it for a longer time each time that the page is refreshed the cookie will stay the same and that's what I am trying to avoid.

Hello everybody, I have a small problem with cookies, I would like to generate a value into a cookie each time a page is refreshed. Right now I use if (isset($_COOKIE['verification'])) { $v_w = $_COOKIE['verification']; setcookie('verification', "", time()-3600); } else { $salt = rand(1, 100); $v_w = crypt($salt, $salt); setcookie('verification', $v_w, time()+1); } But it gives me an empty cookie (= no cookie at all) each 1/2 page refresh. Does anybody know how could I fix this? Thanks a lot in advance! John

Thanks, interesting code! Can I use it?

Hello everybody, Recently I decided to add an image upload script to my website and since myself I am not experienced at all with the GD functions yet, I decided to get an already coded script. However it didn't really suit my needs, and I decided to modify it, I ended up being stuck. I tried all I could but I couldn't manage to code these features: Save all images (gif, png, jpg) as jpg images in the upload gallery and give them all a 6 number/letter name (unique ID). I tried to use uniqid("pt").".jpg" and move_uploaded_file($_FILES['image']['tmp_name'], "./uploads/$newname"); but it didn't work. So I was wondering if there somebody that might want to help me to customize it. Here is the script: <?php ini_set("memory_limit", "200000000"); // for large images so that we do not get "Allowed memory exhausted"?> <?php // upload the file if ((isset($_POST["submitted_form"])) && ($_POST["submitted_form"] == "image_upload_form")) { // file needs to be jpg,gif,bmp,x-png and 4 MB max if (($_FILES["image_upload_box"]["type"] == "image/jpeg" || $_FILES["image_upload_box"]["type"] == "image/pjpeg" || $_FILES["image_upload_box"]["type"] == "image/gif" || $_FILES["image_upload_box"]["type"] == "image/x-png") && ($_FILES["image_upload_box"]["size"] < 4000000)) { // some settings $max_upload_width = 2592; $max_upload_height = 1944; // if user chosed properly then scale down the image according to user preferances if(isset($_REQUEST['max_width_box']) and $_REQUEST['max_width_box']!='' and $_REQUEST['max_width_box']<=$max_upload_width){ $max_upload_width = $_REQUEST['max_width_box']; } if(isset($_REQUEST['max_height_box']) and $_REQUEST['max_height_box']!='' and $_REQUEST['max_height_box']<=$max_upload_height){ $max_upload_height = $_REQUEST['max_height_box']; } // if uploaded image was JPG/JPEG if($_FILES["image_upload_box"]["type"] == "image/jpeg" || $_FILES["image_upload_box"]["type"] == "image/pjpeg"){ $image_source = imagecreatefromjpeg($_FILES["image_upload_box"]["tmp_name"]); } // if uploaded image was GIF if($_FILES["image_upload_box"]["type"] == "image/gif"){ $image_source = imagecreatefromgif($_FILES["image_upload_box"]["tmp_name"]); } // BMP doesn't seem to be supported so remove it form above image type test (reject bmps) // if uploaded image was BMP if($_FILES["image_upload_box"]["type"] == "image/bmp"){ $image_source = imagecreatefromwbmp($_FILES["image_upload_box"]["tmp_name"]); } // if uploaded image was PNG if($_FILES["image_upload_box"]["type"] == "image/x-png"){ $image_source = imagecreatefrompng($_FILES["image_upload_box"]["tmp_name"]); } $remote_file = "uploads/".$_FILES["image_upload_box"]["name"]; imagejpeg($image_source,$remote_file,100); chmod($remote_file,0644); // get width and height of original image list($image_width, $image_height) = getimagesize($remote_file); if($image_width>$max_upload_width || $image_height >$max_upload_height){ $proportions = $image_width/$image_height; if($image_width>$image_height){ $new_width = $max_upload_width; $new_height = round($max_upload_width/$proportions); } else{ $new_height = $max_upload_height; $new_width = round($max_upload_height*$proportions); } $new_image = imagecreatetruecolor($new_width , $new_height); $image_source = imagecreatefromjpeg($remote_file); imagecopyresampled($new_image, $image_source, 0, 0, 0, 0, $new_width, $new_height, $image_width, $image_height); imagejpeg($new_image,$remote_file,100); imagedestroy($new_image); } imagedestroy($image_source); header("Location: submit.php?upload_message=image uploaded&upload_message_type=success&show_image=".$_FILES["image_upload_box"]["name"]); exit; } else{ header("Location: submit.php?upload_message=make sure the file is jpg, gif or png and that is smaller than 4MB&upload_message_type=error"); exit; } } ?> <!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>Image Upload with resize</title> <style type="text/css"> <!-- body,td,th { font-family: Arial, Helvetica, sans-serif; color: #333333; font-size: 12px; } .upload_message_success { padding:4px; background-color:#009900; border:1px solid #006600; color:#FFFFFF; margin-top:10px; margin-bottom:10px; } .upload_message_error { padding:4px; background-color:#CE0000; border:1px solid #990000; color:#FFFFFF; margin-top:10px; margin-bottom:10px; } --> </style></head> <body> <h1 style="margin-bottom: 0px">Submit an image</h1> <?php if(isset($_REQUEST['upload_message'])){?> <div class="upload_message_<?php echo $_REQUEST['upload_message_type'];?>"> <?php echo htmlentities($_REQUEST['upload_message']);?> </div> <?php }?> <form action="submit.php" method="post" enctype="multipart/form-data" name="image_upload_form" id="image_upload_form" style="margin-bottom:0px;"> <label>Image file, maximum 4MB. it can be jpg, gif, png:</label><br /> <input name="image_upload_box" type="file" id="image_upload_box" size="40" /> <input type="submit" name="submit" value="Upload image" /> <br /> <br /> <label>Scale down image? (2592 x 1944 px max):</label> <br /> <input name="max_width_box" type="text" id="max_width_box" value="1024" size="4"> x <input name="max_height_box" type="text" id="max_height_box" value="768" size="4"> px. <br /> <br /> <p style="padding:5px; border:1px solid #EBEBEB; background-color:#FAFAFA;"> <strong>Notes:</strong><br /> The image will not be resized to this exact size; it will be scalled down so that neider width or height is larger than specified.<br /> When uploading this script make sure you have a directory called "image_files" next to it and make that directory writable, permissions 777.<br /> After you uploaded images and made tests on our server please <a href="delete_all_images.php">delete all uploaded images </a> <br /> </p> <input name="submitted_form" type="hidden" id="submitted_form" value="image_upload_form" /> </form> <?php if(isset($_REQUEST['show_image']) and $_REQUEST['show_image']!=''){?> <p> <img src="uploads/<?php echo $_REQUEST['show_image'];?>" /> </p> <?php }?> </body> </html> Thanks a lot in advance! John