PHP - -1 Down Vote Favorite I Am Using The Dragdrop Functionality On A Page Which Also Updates The Database.drag And Drop Is Working Fine But I Am Havin

i dont understand what is wrong plz help me. here is code

$name = "img/".rand(1,9999999).".png";
$myFile = $name;
$fh = fopen($myFile, 'w') or die("can't open file");
$stringData = $html;
fwrite($fh, $stringData);
fclose($fh);
$file=$name;
$fst=file_get_contents($file);
$im=imagecreatefromstring($fst);
imagefilter($im, IMG_FILTER_GRAYSCALE);
imagefilter($im, IMG_FILTER_NEGATE);
//Convert to Grey Scale
for($i=0;$i<123;$i++){
for($j=0;$j<50;$j++){
$px=imagecolorat($im,$i,$j);
if($px<0x303030){
imagesetpixel($im,$i,$j,0);
}else{
imagesetpixel($im,$i,$j,0xffffff);
}
}
}
$database = unserialize(@file_get_contents("db.txt"));
if($database === false) $database = array();
// modify the database if needed
if($_SERVER['REQUEST_METHOD'] == 'POST'){
	if($_POST['submit'] == 'Add')
		$database[$_POST['ident']] = substr($_POST['letter'], 0, 1);
	if($_POST['submit'] == 'Del')
		unset($database[$_POST['ident']]);
	if($fh = @fopen('db111.txt', 'w+')){
		fwrite($fh, serialize($database));
		fclose($fh);
}
}else{
$newimage = true;
}
$width   = 130;
$height  = 40;
$captcha_gridstart   =1;
$captcha_gridspace   =2;
$letters = findletters($im, $width, $height, $captcha_gridstart, $captcha_gridspace);
$count   = count($letters);
$cellw   = ($count > 0) ? intval(100 / $count) : 0;
//dispeckle the image and GET co-ordinates of the characters of captcha image and return them. 
function findletters($image, $width, $height, $gridstart, $gridspace){
	$offsets  = array(); $o = 0;
	$atstartx = true;
	for($x = 0; $x < $width; $x++){
		$blankx = true;
		for($y = 0; $y < $height; $y++){
			if(imagecolorat($image, $x, $y) == 0){
				$blankx = false;
				break;
			}
		}
		if(!$blankx && $atstartx){
			$offsets[$o]['startx'] = $x;
			$atstartx = !$atstartx;
		}else if($blankx && !$atstartx){
			$offsets[$o]['endx']   = $x;
			$atstartx = !$atstartx;
			$o++;
		}
	}
	$count = $o;
	for($o = 0; $o < $count; $o++){
		for($y = 0; $y < $height; $y++){
			$blanky = true;
			for($x = $offsets[$o]['startx']; $x < $offsets[$o]['endx']; $x++){
				if(imagecolorat($image, $x, $y) == 0){
					$blanky = false;
					break;
				}
			}
			if(!$blanky){
				$offsets[$o]['starty'] = $y;
				break;
			}
		}
		for($y = $height-1; $y > $offsets[$o]['starty']; $y--){
			$blanky = true;
			for($x = $offsets[$o]['startx']; $x < $offsets[$o]['endx']; $x++){
				if(imagecolorat($image, $x, $y) == 0){
					$blanky = false;
					break;
				}
			}
			if(!$blanky){
				$offsets[$o]['endy'] = $y;
				break;
			}
		}
	}
	for($o = 0; $o < $count; $o++){
		$offsets[$o]['ident'] = "";
		for($x = $offsets[$o]['startx'] + $gridstart; $x < $offsets[$o]['endx']; $x += $gridspace){
			for($y = $offsets[$o]['starty'] + $gridstart; $y < $offsets[$o]['endy']; $y += $gridspace){
				$offsets[$o]['ident'] .= ((imagecolorat($image, $x, $y) == 0) ? "0" : "1");
				#echo $offsets[$o]['ident'].'<br>';
			}
		}
	}
	return $offsets;
}
$a="";
foreach($letters as $letter){
$asciiletter = $database[$letter['ident']];
if(!empty($asciiletter)) {
$a.=$asciiletter;
}
}

Hi there I'm a little bit of a newbie when it comes to PHP, and I have tried to find my answer on google and on other websites related to php development.    My question is what do I need to be researching / learning to automatically update a page with content.    For example, if I have a database field called breaking news and this text string is flashed at the bottom of the screen on a scrolling bar.   When the field changes value in MYSQL, I would like the page to automatically update the page without a need for a page refresh.   All I need is some advice on what I need to search for in order for me to learn the coding myself.   I'm thinking AJAX, but not too sure.    Thank you for reading.  

This topic has been moved to JavaScript Help.

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

Hi There

I am trying to create a page that edit mysql database from a php page. I can get the edit page to show the orginal information but it wont update the data in the mysql database.

I am sure I have entered everything right. If anyone could help with this I would greatly appreciated

<?php

include("dbconnect.php");

     if(isset($_POST['submit']))

  {


      // Set global variables to easier names
     // and prevent sql injection and apostrophe to break the db.
    
      $ProductName = mysql_escape_string($_POST['ProductName']);
      $ProductText = mysql_escape_string($_POST['ProductText']);
      $ProductImage = mysql_escape_string($_POST['ProductImage']);
      $ProductPrice = mysql_escape_string($_POST['ProductPrice']);


         $result = mysql_query("UPDATE Product SET ProductName='$ProductName', ProductText='$ProductText', ProductImage='$ProductImage', ProductPrice='$ProductPrice' WHERE ID='$ID' ",$dbconnect);

          echo "<b>Thank you! Product UPDATED Successfully!<br>You'll be redirected to View Page after (2) Seconds";

          echo "<meta http-equiv=Refresh content=2;url=view.php>";
         
          echo "$ProductName <br> $ProductText <br> $ProductImage <br> $ProductPrice";

}

elseif(isset($_GET['ID']))

{

 

        $result = mysql_query("SELECT * FROM Product WHERE ID='$_GET[ID]' ",$dbconnect);

        while($myrow = mysql_fetch_assoc($result))

             {

                $ProductName = $myrow["ProductName"];
                $ProductText= $myrow["ProductText"];
                $ProductImage = $myrow["ProductImage"];
                $ProductPrice = $myrow["ProductPrice"];



?>

<br>

<h3>::Edit Product</h3>

   <form method="post" action="<?php echo $PHP_SELF ?>">
   
      <input type="hidden" name="ID" value="<? echo $myrow['ID']?>">            
      Product Name: <input name="ProductName" size="40" maxlength="255" value="<? echo $ProductName; ?>"><br>
      Product Text: <textarea name="ProductText"  rows="7" cols="30"><? echo $ProductText; ?></textarea><br>
      Product Image: <textarea name="ProductImage"  rows="7" cols="30"><? echo $ProductImage; ?></textarea><br>
      Product Price: <textarea name="ProductPrice" rows="7" cols="30"><? echo $ProductPrice; ?></textarea><br>
      <input type="submit" name="submit" value="Update Product">
   
   </form>

<?

              }//end of while loop

 

  }//end else

?>

This script was working fine yesterday i havn't changed anything?? not it don't register the user upon completing the script no error, just when you hit submit it refreshes and does nothing?

<?php
//check for submit
$submit =$_POST['submit'];

//gather POST variable
$fullname =strip_tags($_POST['fullname']);
$email =strip_tags($_POST['email']);
$username =strip_tags($_POST['username']);

$password =strip_tags($_POST['password']);
$password2 =strip_tags($_POST['password2']);


if ($submit) 
{
//check that fields were filled in
if ($fullname&&$email&&$username&&$password&&$password2)
{
//check to see if our two password fields match
if ($password==$password2) 

{
$password = md5($password);

// register the user
 //open database
$connect = mysql_connect("localhost", "root", "");
mysql_select_db("users");


//begine insert
$queryreg = mysql_query("INSERT INTO members VALUES ('','inet_aton('127.0.0.1')','$fullname','$email','$username','$password')");
if ($queryreg) {
echo "Thanks, For Registering! Click <a href=\"index.php\">HERE</a>To Login!";
}

}

//otherwise if passwords don't match
else {
echo "<font color='red'>The passwords you entered do not match</font>";
//end of checking password
}

}

else {
echo "<font color='red'>Please enter all fields!</font>";
}

}

//end check for submit 
?>
<form action='testreg.php' method="post">
<table align="center">
<tr>
     <td>
     Your Full Name:
        </td>
        <td>
        <input type="text" name="fullname" value="<?php echo $fullname; ?>">        
        </td>
    </tr>
     <tr>
     <td>
     Email Address:
        </td>
        <td>
        <input type="text" name="email" value="<?php echo $email; ?>">        
        </td>
     <tr>
     <td>
     Choose Username:
        </td>
        <td>
        <input type="text" name="username" value="<?php echo $username; ?>">        
        </td>
    </tr>
     <tr>
     <td>
     Password:
        </td>
        <td>
        <input type="password" name="password">        
        </td>
    </tr>
     <tr>
     <td>
     Retype Password:
        </td>
        <td>
        <input type="password" name="password2">        
        </td>
    </tr>
</table>
<p>
<center><input type="submit" name="submit" value="Register"></center>

</form>

I have been using this script for years. I realise it is a little old and probably not well written, however it has been functional. I suspect the problem is that maybe they have turned the register_globals off at the server and the script is no longer working. I don't know if that is the problem. The error I get when I attempt to upload an image is this:
Error:
MySQL error reported!
Query: INSERT INTO photos values(NULL,'corrobex', 1, 10, , 'makinti', '', '', 'makinti.jpg', 571, 381, 42520, '0', 0, 0, 0, '1', , '0', 'no', '', '', '', '', '')

Result: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'makinti', '', '', 'makinti.jpg', 571, 381, 42520, '0', 0, 0, 0, '1', , '0', 'n' at line 1

Database handle: Resource id #3

Now here is the script:
Code: [Select]
<?php
include("pp-inc.php");
include("login-inc.php");
include("image-inc.php");

if ( is_array($HTTP_POST_FILES) ) {
    while(list($key,$value) = each($HTTP_POST_FILES)) {
        ${$key} = $value;
    }
}

function handleupload( $location = "data" ) {
    global $HTTP_POST_FILES, $userid, $Globals, $category;
    
    $tmpname = $HTTP_POST_FILES['theimage']['tmp_name'];
    $realname = $HTTP_POST_FILES['theimage']['name'];
    $tmpcloseup = $HTTP_POST_FILES['closeup']['tmp_name'];

    if (is_uploaded_file($tmpname) ) {
        $realname = fixfilenames( $realname );
        $closeup = preg_replace("/(\.[A-Za-z]+)$/", "-closeup\\1", $realname);
 
        if ( $location != "data" ) {
            $dst_file = $location;
        }
        else {
            $dst_file = $Globals{'datafull'}."$category/$userid$realname";
            $closeup_file = $Globals{'datafull'}."$category/$userid$closeup"; 
       }

        copy($tmpname, $dst_file);
        copy($tmpcloseup, $closeup_file);
    } else {
        dieWell("Uploaded file not found: $realname<br>Typical reason is that the file exceeded allowed limits.");
        exit;
    }

    return;
}

authenticate();

$nolimit = 0;
if ( $Globals{'adminnolimit'} == "yes" && $adminedit == 1 ) {
    $nolimit = 1;
}

$adminexclude = 0;
if ( $Globals{'adminexclude'} == "yes" && $adminedit == 1 ) {
    $adminexclude = 1;
}

if ( $adminedit == 0 ) {
    if ( $Globals{'allowup'} == "no" ) {
        dieWell( "User uploads not allowed" );
    }
}

$querystring = findenv("QUERY_STRING");
if ( ($useruploads == 0 && $gologin==1) || $querystring == "gologin" ) {
    $furl=$Globals{'maindir'};
    $furl= str_replace( $Globals{'domain'}, "", $furl );
    $furl="$furl/uploadphoto.php";

    login( $furl );
    exit;
}

if ( $gologin != 0 ) {
    if ( $useruploads == 0 ) {
        dieWell("Sorry, you don't have permission to upload photos.");
        exit;
    }    
}

topmenu();

if ( !isset($theimage) ) {
    $catdefault = "";

    if ( !empty($cat) ) {
        $query = "SELECT id,catname,thumbs FROM categories WHERE id=$cat LIMIT 1";
        $resultb = ppmysql_query($query,$link);
        while ( list( $subid, $subcatname, $subthumbs ) = mysql_fetch_row($resultb) ) {
            if ( $ugcat{$subid} != 1 ) {
                $catdefault = "<option selected value=\"$subid\">$subcatname</option>";
            }
        }
        ppmysql_free_result( $resultb );
    }

    $header = str_replace( "titlereplace", "Upload Photo", $header );    

    $output = "$header<center><p>
        <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" height=\"40\" width=\"".$Globals{'tablewidth'}."\"><Tr>
        <Td valign=\"middle\" width=\"50%\">$menu2</td>
        <td width=\"50%\" align=\"right\" valign=\"middle\">$menu</td></tr></table>
        <table cellpadding=\"0\" cellspacing=\"0\"
        border=\"0\" bgcolor=\"".$Globals{'bordercolor'}."\"  width=\"".$Globals{'tablewidth'}."\" align=\"center\"><tr><td>
        <table cellpadding=\"4\" cellspacing=\"1\" border=\"0\"  width=\"100%\">
        <tr align=\"center\">
        <td colspan=\"1\" align=\"left\" bgcolor=\"".$Globals{'headcolor'}."\"><font face=\"".$Globals{'headfont'}."\"
        color=\"".$Globals{'headfontcolor'}."\" size=\"".$Globals{'fontmedium'}."\"><B>".$Globals{'galleryname'}." Image
        Upload</font></td>
        <td colspan=\"1\" align=\"right\" bgcolor=\"".$Globals{'headcolor'}."\"><font
        face=\"".$Globals{'mainfonts'}."\" color=\"".$Globals{'headfontcolor'}."\" size=\"".$Globals{'fontmedium'}."\">
        <a href=\"javascript:PopUpHelp('uploadphoto.php')\">help</a></font>
        </td>            
        </tr>
        <form method=\"post\" action=\"".$Globals{'maindir'}."/uploadphoto.php\" enctype=\"multipart/form-data\">
        <tr><Td bgcolor=\"".$Globals{'maincolor'}."\"><font size=\"".$Globals{'fontmedium'}."\" face=\"".$Globals{'mainfonts'}."\" color=\"".$Globals{'maintext'}."\">Username</font></td><td
        bgcolor=\"".$Globals{'maincolor'}."\">
        <font size=\"".$Globals{'fontmedium'}."\" face=\"".$Globals{'mainfonts'}."\" color=\"".$Globals{'maintext'}."\">$username</td></tr>
        <tr><Td bgcolor=\"".$Globals{'maincolor'}."\" width=\"50%\"><font size=\"".$Globals{'fontmedium'}."\" color=\"".$Globals{'maintext'}."\" face=\"".$Globals{'mainfonts'}."\">Choose a
        category</font></td><Td bgcolor=\"".$Globals{'maincolor'}."\"><select
        name=\"category\">$catdefault";

    if (empty($subid)) $subid="";
    $selected = $subid;
    catmoveopt(0);
    $output .= $catoptions;

    $imgdir = $Globals{'zipuploaddir'}."/$userid";
    $skiphtml = "</table><table cellpadding=\"4\" cellspacing=\"0\" border=\"0\"  width=\"100%\">
        <tr><Td bgcolor=\"".$Globals{'headcolor'}."\" align=\"center\">
        <font size=\"".$Globals{'fontmedium'}."\" color=\"".$Globals{'headfontcolor'}."\" face=\"".$Globals{'mainfonts'}."\">
        <b>ADMIN OPTIONS FOR BULK OR ZIP UPLOADS</b></font>
        </td>
        <td align=\"right\" bgcolor=\"".$Globals{'headcolor'}."\"><font
        face=\"".$Globals{'mainfonts'}."\" color=\"".$Globals{'headfontcolor'}."\" size=\"".$Globals{'fontmedium'}."\">
        <a href=\"javascript:PopUpHelp('adminskip.php')\">help</a></font>
        </td>            
        </tr></table>
        <table cellpadding=\"4\" cellspacing=\"1\" border=\"0\"  width=\"100%\">
        <tr><Td bgcolor=\"".$Globals{'maincolor'}."\"><font size=\"".$Globals{'fontmedium'}."\" color=\"".$Globals{'maintext'}."\" face=\"".$Globals{'mainfonts'}."\">Skip upload and process the files in your upload directory<br><font size=\"".$Globals{'fontsmall'}."\">Files should already be in: <b>$imgdir</b></td>
        <td bgcolor=\"".$Globals{'maincolor'}."\" align=\"center\"><input type=\"checkbox\" name=\"skipupload\" value=\"skipupload\"></td></tr>
        <tr><Td bgcolor=\"".$Globals{'maincolor'}."\"><font size=\"".$Globals{'fontmedium'}."\" color=\"".$Globals{'maintext'}."\" face=\"".$Globals{'mainfonts'}."\">Show thumbnails during processing?</td>
        <td bgcolor=\"".$Globals{'maincolor'}."\" align=\"center\"><font size=\"".$Globals{'fontmedium'}."\" color=\"".$Globals{'maintext'}."\" face=\"".$Globals{'mainfonts'}."\"><select name=\"dthumbs\"><option selected>yes</option><option>no</option></select></font></td></tr>
        <tr><Td bgcolor=\"".$Globals{'maincolor'}."\"><font size=\"".$Globals{'fontmedium'}."\" color=\"".$Globals{'maintext'}."\" face=\"".$Globals{'mainfonts'}."\">Number of thumbnails to process next?</td>
        <td bgcolor=\"".$Globals{'maincolor'}."\" align=\"center\"><font size=\"".$Globals{'fontmedium'}."\" color=\"".$Globals{'maintext'}."\" face=\"".$Globals{'mainfonts'}."\"><select name=\"numprocess\"><option selected>10</option><option>25</option><option>50</option><option>100</option></select></td></tr>";
            
    $output .= "</select></td></tr>
        <tr><Td bgcolor=\"".$Globals{'maincolor'}."\"><font size=\"".$Globals{'fontmedium'}."\" face=\"".$Globals{'mainfonts'}."\" color=\"".$Globals{'maintext'}."\">Photo to upload:</font><br><b><font size=\"".$Globals{'fontsmall'}."\" face=\"".$Globals{'mainfonts'}."\"
        color=\"red\">$maxfilesize</font></b></td><td bgcolor=\"".$Globals{'maincolor'}."\"><input type=\"file\" name=\"theimage\"></td></tr>
        <tr><Td bgcolor=\"".$Globals{'maincolor'}."\"><font size=\"".$Globals{'fontmedium'}."\" face=\"".$Globals{'mainfonts'}."\" color=\"".$Globals{'maintext'}."\">Matching closeup to upload:</font><br><b><font size=\"".$Globals{'fontsmall'}."\" face=\"".$Globals{'mainfonts'}."\"
        color=\"red\">$maxfilesize</font></b></td><td bgcolor=\"".$Globals{'maincolor'}."\"><input type=\"file\" name=\"closeup\"></td></tr>
        <tr><Td bgcolor=\"".$Globals{'maincolor'}."\"><font size=\"".$Globals{'fontmedium'}."\" color=\"".$Globals{'maintext'}."\" face=\"".$Globals{'mainfonts'}."\">Enter a title for the photo</td><td bgcolor=\"".$Globals{'maincolor'}."\"><input
        type=\"text\" name=\"title\"></td></tr>
        <tr><Td bgcolor=\"".$Globals{'maincolor'}."\"><font size=\"".$Globals{'fontmedium'}."\" color=\"".$Globals{'maintext'}."\" face=\"".$Globals{'mainfonts'}."\">To help users find your photo, please enter a few (up to 10) descriptive
        keywords (separated by spaces):</td><td bgcolor=\"".$Globals{'maincolor'}."\"><input type=\"text\" name=\"keywords\"></td></tr>
        <tr><Td bgcolor=\"".$Globals{'maincolor'}."\"><font size=\"".$Globals{'fontmedium'}."\" color=\"".$Globals{'maintext'}."\" face=\"".$Globals{'mainfonts'}."\">Photo Description</td><td bgcolor=\"".$Globals{'maincolor'}."\"><textarea
        name=\"desc\" cols=\"30\" rows=\"5\"></textarea></td></tr>
        $skiphtml
        <Center>
        <Tr><Td colspan=\"2\" bgcolor=\"".$Globals{'maincolor'}."\"><font size=\"".$Globals{'fontmedium'}."\" face=\"".$Globals{'mainfonts'}."\"><center>
        <input type=\"hidden\" name=\"password\" value=\"$password\">
        <input type=\"hidden\" name=\"userid\" value=\"$userid\">
        <input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"2000000\">
        <input type=\"submit\" value=\"Upload/Submit\">
        <p><b>When you hit SUBMIT, the file you selected will be uploaded.</b><br></font><font size=\"".$Globals{'fontsmall'}."\" face=\"".$Globals{'mainfonts'}."\">
        (Depending on the size of the file and your connection, this may take some time. <b>Please be patient.</b>)</p></font></td></tr></table></td></tr></table><p>".$Globals{'cright'}."$footer";

    print $output;
}
else {
    if (empty($skipupload)) $skipupload="";
    
    if ( $category == "" ) {
        dieWell( "You must choose a category before uploading.");
        exit;
    }

    if ( $skipupload == "skipupload" ) {
        $deftitle = urlencode($title);
        $defdesc = urlencode($desc);
        $furl = $Globals{'zipuploadurl'}."/$userid";

        forward( $Globals{'maindir'}."/bulkupload.php?ppaction=addphotos&do=preview&photopath=$userid&deftitle=$deftitle&defdesc=$defdesc&defcat=$category&keywords=$keywords&numprocess=$numprocess&dthumbs=$dthumbs&furl=$furl", "Preparing to process image list!" );
        exit;
    }

    $realname = $HTTP_POST_FILES['theimage']['name'];
    
    if ( $realname == "" ) {
        dieWell( "You need to enter the name of a file to upload! $thevideo / $theimage" );
        exit;
    }

    $realname = fixfilenames( $realname );
    $theext   = get_ext( $realname );
    
    $filepath = $Globals{'datafull'}."$category/$userid$realname";
    $outfilename = "$userid$realname";

    $query = "SELECT userid,bigimage FROM photos where userid=$userid";
    $resulta = ppmysql_query($query,$link);

    while( list( $uid, $bgimage ) = mysql_fetch_row($resulta) ) {
        if ($uid == $userid && $uid != 0) {
            if ( $bgimage == $realname ) {
                dieWell("Sorry, you already uploaded an image called $realname.  Try a different name.");
                exit;
            }
        }
    }
    ppmysql_free_result($resulta);

    $title = fixmessage( $title );
    $keywords = fixmessage( $keywords );
    $desc = fixmessage( $desc );

    if ( $category == "notcat" ) {
        $emessage = "The category you chose is a top level category.<p>Please go back and choose one of its subcategories to upload your image.";
        dieWell($emessage);
    }

    //####// Write the file to a directory #####
    //#// Do you wish to allow all file types?  yes/no (no capital letters)
    $allowall = "no";

    //#// If the above = "no"; then which is the only extention to allow?
    //#// Remember to have the LAST 4 characters i.e. .ext
    if ($realname != "") {
        $isfilegood = "yes";
        if ( $allowall != "yes" ) {
            if ( !is_image($outfilename) ) {
                $isfilegood = "no";
            }
        }

        if ($isfilegood == "yes") {
            handleupload();
        }

        //
        // ZIP Uploads for Users
        //
        if ( $Globals{'allowzip'} ) {
            if (strtolower(substr($outfilename,strlen($outfilename) - 4,4)) == ".zip" ) {
                $filepath = $Globals{'zipuploaddir'}."/$userid";
                $filedir = "$filepath/$outfilename";

                if ( !file_exists( $filepath ) ) {
                    mkdir( $filepath, 0755 );
                    chmod( $filepath, 0777 );
                }

                chdir( $filepath );

                handleupload( $filedir );

                $sys_cmd = $Globals{'zip_command'}." -qq $filedir";
                system( $sys_cmd );
                unlink( $filedir );

                $deftitle = urlencode($title);
                $defdesc = urlencode($desc);
                $furl = $Globals{'zipuploadurl'}."/$userid";
                if ( empty($numprocess) ) $numprocess = 10;
                if ( empty($dthumbs) ) $dthumbs = "yes";

                forward( $Globals{'maindir'}."/bulkupload.php?ppaction=addphotos&do=preview&photopath=$userid&deftitle=$deftitle&defdesc=$defdesc&defcat=$category&keywords=$keywords&numprocess=$numprocess&dthumbs=$dthumbs&furl=$furl", "Preparing to process image list!" );
                exit;
            }
        }
    }

    if ( file_exists($filepath) ) {
        $insize = filesize( $filepath );
    }
    else {
        dieWell("File upload error. Cannot find uploaded file.<br>Path: [$filepath]");
        exit;
    }

    if ( $isfilegood != "yes" ) {
        dieWell( "Image must be a .jpg, .gif, .tif or .png file." );
        exit;
    }

    $thumbsize = create_thumb( $realname, $filepath, $category );
    process_image( $realname, $filepath, $category );

    $query = "SELECT id FROM photos WHERE userid=$userid AND bigimage='$realname'";
    $resulta = ppmysql_query($query,$link);
    list( $forwardid ) = mysql_fetch_row($resulta);
    ppmysql_free_result($resulta);

    if ( empty($forwardid) ) {
        dieWell( "There was a problem processing your image: $realname.<p>Please notify the System Administrator." );
        exit;
    }
    
    forward( $Globals{'maindir'}."/showphoto.php?photo=$forwardid", "Your image was uploaded successfully!" );
}

?>

Do Globals need to be on for this to work? Or is there another problem?

thanks

Paul

MOD EDIT: [code] . . . [/code] tags added.

 The result pages is supposed to have  pagination like google  help me please

 

I have a server script with which i have allowed the user to mark any item as favorite, but i also want another script through which the user can unfavorite the same item if they want and that item should be deleted from their favorite list. I have kept the same table for both favorite and unfavorite code, therefore i have used update query to update the details. For this purpose i have a code, but its not working, as i am new in the programming field would appreciate if someone could provide the correct codes

 
<?php
require_once('config.php');

$favorite = $_REQUEST['favorite'];

    $unfavorite = $_REQUEST['unfavorite'];

    $id=$_REQUEST['id'];

    

$unfavoritedeal=mysql_query("SELECT * FROM favoritedeals where id='".$id."'"); //favoritedeals is the name of the table



if($row=mysql_fetch_array($unfavoritedeal))

     {

     $favorite=$row['favorite'];

     $unfavorite=$row['unfavorite'];

}



$myfavorite=(isset($_REQUEST['favorite'])?$_REQUEST['favorite']:$favorite);

         $myunfavorite=(isset($_REQUEST['unfavorite'])?$_REQUEST['unfavorite']:$unfavorite);

        

$update = mysql_query("update favoritedeals set favorite = '".$myfavorite."', unfavorite = 1 where id = '".$id."'");    



if(unfavorite="1" where id='".$id."')

{

"delete from favoritedeals WHERE id= '".$id."'";

}    





$posts[0]['message'] = 'favorite list updated';

    $selectt = mysql_query("select * from favoritedeals where id = '".$id."'");

    $results = mysql_fetch_assoc($selectt);

    $posts[0]['detail'] = $results;

    header('Content-type: application/json');

    echo json_encode($posts);

?>

I have written a small script for my own personal use that checks the servers of my favorite sites to see if they are operational.  I'm having trouble getting it to work, I have most of it (I think) and I'm very new to PHP. The script also allows for a form to add any sites to the file, which I think I explode into an array correctly, at a later time.  Here's my code, Please Help!

<html>
<head>
<title>project.php</title>
</head>
<body>
<?php
$filename = "websites.txt";
$file = file_get_contents($filename); // reads entire file into a string
$DomainNames = explode("\n", $file); // split the string at new line characters, returns an array
$length = count($DomainNames) - 1; // count is the correct way to get the length of an array
$i=0;
while($i<=$length){
   $fp = @fsockopen ($DomainNames[$i], 80, $errno, $errstr, 10);
   if (!$fp)
      echo "$DomainNames[$i] : <font color='red'>Failed!</font>";
   else {
      echo "$DomainNames[$i] : <font color='green'>Online!</font>";
      echo "<br>";
      $i++;
   }
}
if (isset($_POST['submit'])) {
   $DomainNames[] = $_POST['url']; // append url to array
   $file = implode("\n", $DomainNames); // convert array to string, delimiting by new lines
   file_put_contents($filename, $file); // save contents to file
}
?>


<form action="project.php" method="post">
   <fieldset>
      <label for="url">Url: </label>
      <input type="text" name="url" id="url" />
      <input type="submit" name="submit" id="submit" value="Add URL" />
   </fieldset>
</form>
</body>
</html>

Hi everyone,
I have a like button on repeating regions that is used for keeping a record of votes on comments.
People click it an it adds 1 to the votes column total.

It works just fine.

Problem is i only want to a allow a user one vote per comment only. can vote on other comments as well, but again, only one vote per day per comment.

i wouldn't know where to start.
Would i use a cookie or record an ip?

switch ($_REQUEST['action']) {
case 'likeit';

foreach($_REQUEST as $key=>$value){
$$key = $value;
}
$votes = $_GET['votes'];
$total = ($votes + 1);

$sql = mysql_query("UPDATE quotes SET votes = '$total' WHERE quoteid = '$quoteid'");

break;

}

I get to errors below and cannot figure out what im doign wrong i've tryed diffrent ways and have even rewritten this couple times
(#1error) not sure how to re query and echo out the array??
(#2error) gives me error on line 14 if i echo anything past (echo $row['name']."|user1:". $row['user1']. "|user2:". $row['user2']. ->this



Code: [Select]
<?php

$conn = mysql_connect("localhost", "root", "");

if (!$conn) {
    echo "Unable to connect to DB: " . mysql_error();
}
  
if (!mysql_select_db("register_db")) {
    echo "Unable to select mydbname: " . mysql_error();
    exit;
}

$result = mysql_query("SELECT * FROM register_vote WHERE name = '{$_POST['user']}'");


if (!$result) {
    echo "Could not successfully run query ($sql) from DB: " . mysql_error();
    exit;
}
    =========================(#1error)==========================================
//THIS IS THE CODE I'M HAVING ISSUES WITH
if (mysql_num_rows($result) == 0) {
mysql_query("INSERT INTO register_vote (name) VALUES ('$_POST[user]')");
//need it to the query new results after insert
//then
       //  echo $row['name']."|user1:". $row['user1']. "|user2:". $row['user2']. "|user3:". $row['user3'];



}================================================= (#2error)===================================
   while ($row = mysql_fetch_array($result)) {
       echo $row['name']."|user1:". $row['user1']. "|user2:". $row['user2']. "|user3:". $row['user3'];
}                                  //when I put anything past $row['user2']. it gives me error on line 14
mysql_free_result($result);
?>

Hi im trying to Make a Timer count down in this code

 function getTime($host, $user, $pass, $db, $hours, $ip, $serverId) {
  $c = @mysql_connect($host, $user, $pass);
      if(mysql_select_db($db, $c)) {
              $dateQ = mysql_query('SELECT MAX(date) AS lastVoteDate FROM `'. $db .'`.`votes` WHERE ip="'. $ip .'"') or die(mysql_error());
              $getDate = mysql_fetch_assoc($dateQ);
              $diffrence = time() - strtotime($getDate['lastVoteDate']);
              $hours = number_format(($diffrence / 60 / 60));
              $minutes = number_format(($hours / 60));
              if(!$hours < 1){
                return ("". $hours ."");
                } else {
                return ("0");
                }
      } else {
          return array(1, "Error connecting to DB.");
      }   
 }

Hello,

I have built a blog in php but. On each article in the blog people are able to comment.

I would now like to build a system where people can vote on the comment up/down with Ajax.

In my comments database I have a table that looks like this:

id / article_id / user_id / dateposted / comment    / voteup / votedown

I would like it to look like this:


Any ideas how I can do this? Tutorials online?

Thanks a million

Hi, I run a top site which has incentives. Originally when a voter came and voted, the script in the background would run file() but I noticed that it sometimes lagged and caused the voter to wait a few secs before the page loads.

I was then told by a developer to use file_get_contents(), but I was getting the same results. It occasionally lagged, even on my own websites that are voting on it.

I decided to log the incentives now, and get a cron to check and process any incentives instead of the user lagging, but now it's starting to kill my server as you can see below

Quote

xxxxx.com   1.05   0.49   0.1
Top Process   %CPU 77.2   php -q process_incentives.php
Top Process   %CPU 24.0   php -q process_incentives.php
Top Process   %CPU 8.0   php -q timers/5mins.php
xxxxx.com   0.99   0.13   0.0
Top Process   %CPU 9.0   php -q timers/30mins.php
Top Process   %CPU 7.0   php -q timers/5mins.php


Code in process_incentives.php

//REWARD VOTERS
$get = mysql_query("SELECT id,url FROM incentives ORDER BY id DESC limit 50;");
while ($game = mysql_fetch_array($get)){

  file_get_contents("$game[url]");
  mysql_query("DELETE from incentives WHERE id='$game[id]'");

}

I'm currently trying to break apart some PHP coding that a former coder created, but left no documentation to. Can anyone help e find the function in this mess that creates the vote button and passes the currently loaded data to the next page? Here's the original code:

Code: [Select]
<?php

include("./templates/mysql_connect.php");

 //FOR LETTER: A

$query = "SELECT * FROM seniors WHERE last_name LIKE 'A%' ORDER BY last_name ASC";
$result = @mysql_query ($query);

echo '<table><tr>
  <td>
  <p><span class="style19"><u>-A-</u></span><br />';

while ($row = mysql_fetch_array ($result)){

echo "<a href=\"$row[pic_url]\" rel=\"lightbox[seniors]\" 
title=\" &lt;form action =&quot;/sencha-tallyvote.php?sen_id=$row[sen_id]&quot; method=&quot;post&quot;&gt;

$row[first_name] $row[last_name] - $row[school] <br />

 &nbsp; &nbsp; &lt;input name=&quot;submit&quot; align=&quot;right&quot; type=&quot;submit&quot; value=&quot;Vote&quot; &gt;  
 
 &lt;/form&gt; \">$row[last_name], $row[first_name]</a><br/>";

}
echo '</p>';
?>

The original code used a lightbox feature with an added voting button tagged on near the bottom. We've Xed the lightbox feature and are trying to deconstruct it into tangible PHP pages. We have everything done except for the coding for the vote  button.

Here's our coding for the currently deconstructed page, and where the coding for the button needs to go:

Code: [Select]
<?php
require_once('templates/mysql_connect.php');
?>

<?php 
$query = "SELECT * FROM seniors WHERE sen_id=$_GET[sen_id]";
$result = mysql_query ($query);
$row = mysql_fetch_array ($result);
?>

<div class="contents">
<h1><?php echo $row['first_name'], " ", $row['last_name']; ?></h1>
<h4><?php echo $row['school']; ?></h4>
</div>

<?php echo
'<a href="sencha.php" class="bigmenu"><img src="images/backarrow.png" alt="Back to Senior Challenge Home" class="arrowleft indexicon" /><u>Back</u></a><br />'; ?>

<?php echo "<img src=\"http://www.rutholsonphoto.com" .$row['pic_url']. "\" width=\"100%\" />" ?> <br />
<br />
<a href="/">{{VOTEBUTTON}}</a>

Any experienced help will be greatly appreciated.