silentweed

its ok ive managed to figure it out..cheers anyway

I have an admin section where admins can rate different users entries using a dropdown list. What i wanted was each time a dropdown menu is changed the new rating was updated in the database. However I dont want the admin to go to a different page, so i guess i will have to use ajax? Could anyone please give me an idea on how to do this or the theory behind doing such a thing..thanks in advance...

its ok i've got it: $sql = "UPDATE odb_upload SET ".$columname."='".$_POST[$i]."' WHERE id = '".$_POST['record'.$i]."'"; cheers

thanks but i need to know the actual syntax for the UPDATE statement..if you have a look at my post ..you will see what i mean that is: $columname = "judge_bean"; $sql = "UPDATE odb_upload SET $columnname ='".$_POST[$i]."' WHERE id = '".$_POST['record'.$i]."'"; the above UPDATE syntax needs to be changed...as it doesnt work

hi everyone - in context this line works fine: $sql = "UPDATE odb_upload SET judge_bean ='".$_POST[$i]."' WHERE id = '".$_POST['record'.$i]."'"; however I want the column name to be dynamic e.g $columname = "judge_bean"; $sql = "UPDATE odb_upload SET $columnname ='".$_POST[$i]."' WHERE id = '".$_POST['record'.$i]."'"; However the above does not work... any ideas? thanks in advance for the help!!

Hi, I have a login.html page with a username and password field. When the submit button is clicked the username and password entered is POSTED to a login.php page on Server A. This php page then checks the username/password against a mySQL database. If the username/password is not valid the script exits() and the user is told that he has entered incorrect login details. However if a user enters valid details I want the login.php script to call another page called message.php. This message.php page will simply return a letter "A" or "B" to members.php page. The member.php page should then display this letter to the user. Is this possible? i.e a php page calling another php page (which returns a value to the calling page) and then the calling page returning the result passed back to it to the user? Thanks in advance...

Hi guys, Im using the class http://codewalkers.com/seecode/65.html to create zip files on the fly. However i am not sure how to implement this. Do i copy the class zipfile code into a file called zipfile.php and the rest of the code after that into another php file for e.g test.php? Any help appreciated..thanks in advance... heres what i've done.. ive created a file called zipfile.php which contains the class i.e: <?php class zipfile { var $datasec = array(); // array to store compressed data var $ctrl_dir = array(); // central directory var $eof_ctrl_dir = "\x50\x4b\x05\x06\x00\x00\x00\x00"; //end of Central directory record var $old_offset = 0; function add_dir($name) // adds "directory" to archive - do this before putting any files in directory! // $name - name of directory... like this: "path/" // ...then you can add files using add_file with names like "path/file.txt" { $name = str_replace("\\", "/", $name); $fr = "\x50\x4b\x03\x04"; $fr .= "\x0a\x00"; // ver needed to extract $fr .= "\x00\x00"; // gen purpose bit flag $fr .= "\x00\x00"; // compression method $fr .= "\x00\x00\x00\x00"; // last mod time and date $fr .= pack("V",0); // crc32 $fr .= pack("V",0); //compressed filesize $fr .= pack("V",0); //uncompressed filesize $fr .= pack("v", strlen($name) ); //length of pathname $fr .= pack("v", 0 ); //extra field length $fr .= $name; // end of "local file header" segment // no "file data" segment for path // "data descriptor" segment (optional but necessary if archive is not served as file) $fr .= pack("V",$crc); //crc32 $fr .= pack("V",$c_len); //compressed filesize $fr .= pack("V",$unc_len); //uncompressed filesize // add this entry to array $this -> datasec[] = $fr; $new_offset = strlen(implode("", $this->datasec)); // ext. file attributes mirrors MS-DOS directory attr byte, detailed // at http://support.microsoft.com/support/kb/articles/Q125/0/19.asp // now add to central record $cdrec = "\x50\x4b\x01\x02"; $cdrec .="\x00\x00"; // version made by $cdrec .="\x0a\x00"; // version needed to extract $cdrec .="\x00\x00"; // gen purpose bit flag $cdrec .="\x00\x00"; // compression method $cdrec .="\x00\x00\x00\x00"; // last mod time & date $cdrec .= pack("V",0); // crc32 $cdrec .= pack("V",0); //compressed filesize $cdrec .= pack("V",0); //uncompressed filesize $cdrec .= pack("v", strlen($name) ); //length of filename $cdrec .= pack("v", 0 ); //extra field length $cdrec .= pack("v", 0 ); //file comment length $cdrec .= pack("v", 0 ); //disk number start $cdrec .= pack("v", 0 ); //internal file attributes $ext = "\x00\x00\x10\x00"; $ext = "\xff\xff\xff\xff"; $cdrec .= pack("V", 16 ); //external file attributes - 'directory' bit set $cdrec .= pack("V", $this -> old_offset ); //relative offset of local header $this -> old_offset = $new_offset; $cdrec .= $name; // optional extra field, file comment goes here // save to array $this -> ctrl_dir[] = $cdrec; } function add_file($data, $name) // adds "file" to archive // $data - file contents // $name - name of file in archive. Add path if your want { $name = str_replace("\\", "/", $name); //$name = str_replace("\\", "\\\\", $name); $fr = "\x50\x4b\x03\x04"; $fr .= "\x14\x00"; // ver needed to extract $fr .= "\x00\x00"; // gen purpose bit flag $fr .= "\x08\x00"; // compression method $fr .= "\x00\x00\x00\x00"; // last mod time and date $unc_len = strlen($data); $crc = crc32($data); $zdata = gzcompress($data); $zdata = substr( substr($zdata, 0, strlen($zdata) - 4), 2); // fix crc bug $c_len = strlen($zdata); $fr .= pack("V",$crc); // crc32 $fr .= pack("V",$c_len); //compressed filesize $fr .= pack("V",$unc_len); //uncompressed filesize $fr .= pack("v", strlen($name) ); //length of filename $fr .= pack("v", 0 ); //extra field length $fr .= $name; // end of "local file header" segment // "file data" segment $fr .= $zdata; // "data descriptor" segment (optional but necessary if archive is not served as file) $fr .= pack("V",$crc); //crc32 $fr .= pack("V",$c_len); //compressed filesize $fr .= pack("V",$unc_len); //uncompressed filesize // add this entry to array $this -> datasec[] = $fr; $new_offset = strlen(implode("", $this->datasec)); // now add to central directory record $cdrec = "\x50\x4b\x01\x02"; $cdrec .="\x00\x00"; // version made by $cdrec .="\x14\x00"; // version needed to extract $cdrec .="\x00\x00"; // gen purpose bit flag $cdrec .="\x08\x00"; // compression method $cdrec .="\x00\x00\x00\x00"; // last mod time & date $cdrec .= pack("V",$crc); // crc32 $cdrec .= pack("V",$c_len); //compressed filesize $cdrec .= pack("V",$unc_len); //uncompressed filesize $cdrec .= pack("v", strlen($name) ); //length of filename $cdrec .= pack("v", 0 ); //extra field length $cdrec .= pack("v", 0 ); //file comment length $cdrec .= pack("v", 0 ); //disk number start $cdrec .= pack("v", 0 ); //internal file attributes $cdrec .= pack("V", 32 ); //external file attributes - 'archive' bit set $cdrec .= pack("V", $this -> old_offset ); //relative offset of local header // echo "old offset is ".$this->old_offset.", new offset is $new_offset<br>"; $this -> old_offset = $new_offset; $cdrec .= $name; // optional extra field, file comment goes here // save to central directory $this -> ctrl_dir[] = $cdrec; } function file() { // dump out file $data = implode("", $this -> datasec); $ctrldir = implode("", $this -> ctrl_dir); return $data. $ctrldir. $this -> eof_ctrl_dir. pack("v", sizeof($this -> ctrl_dir)). // total # of entries "on this disk" pack("v", sizeof($this -> ctrl_dir)). // total # of entries overall pack("V", strlen($ctrldir)). // size of central dir pack("V", strlen($data)). // offset to start of central dir "\x00\x00"; // .zip file comment length } } ?> and in test.php ive got the code: <?php $zipfile = new zipfile(); // add the subdirectory ... important! $zipfile -> add_dir("dir/"); // add the binary data stored in the string 'filedata' $filedata = "(read your file into $filedata)"; $zipfile -> add_file($filedata, "dir/file.txt"); // the next three lines force an immediate download of the zip file: header("Content-type: application/octet-stream"); header("Content-disposition: attachment; filename=test.zip"); echo $zipfile -> file(); // OR instead of doing that, you can write out the file to the loca disk like this: $filename = "output.zip"; $fd = fopen ($filename, "wb"); $out = fwrite ($fd, $zipfile -> file()); fclose ($fd); // then offer it to the user to download: <a href="output.zip">Click here to download the new zip file.</a> ?> However when i run test.php i get the error: Fatal error: Class 'zipfile' not found in c:\htdocs\zipper\test.php on line 4