session_start(); global $scode; $linkID = mysql_connect("localhost", "root", "zangtang"); mysql_select_db("SciPark"); function findexts ($filename) { $filename = strtolower($filename) ; $exts = split("[/\\.]", $filename) ; $n = count($exts)-1; $exts = $exts[$n]; return $exts; } //------------------------------------------------------------------------------------------------------------------------------------ // VERIFY FORM FUNCTION //--------------------------------------------------------------------------------------------------------------------------------------- function VerifyForm(&$values, &$errors) { if(strlen($values['NewsTitle'])== 0) $errors['NewsTitle'] = "News Title Required"; if(strlen($values['NewsDays'])== 0) $errors['NewsDays'] = "News available day count Required"; if(strlen($values['UpFile'])== 0) $errors['UpFile'] = "Select Yes / No Required"; if(strlen($values['UpFile']) == "N") { if(strlen($values['NewsURL'])== 0) $errors['NewsURL'] = "News URL (Link) Required"; } else { //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ FILE ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ $EventFile = $_SESSION['EventFile']; $Code = $_SESSION['Code'] ; $_SESSION['uploads'] = "1"; $uploaddir = "uploads/NewsScroll/"; $query0 = "SELECT `NewsId` FROM NewsScroll Order by NewsId"; $result0 = mysql_db_query("SciPark", $query0) or die ("could not query" . mysql_error()); $tung0=mysql_affected_rows(); if($tung0 != 0) { while ($r = mysql_fetch_array($result0)) { $NewsId = $r["NewsId"]; } $NewsId++; } else { $NewsId = "1"; } $_SESSION["NewsId"] = $NewsId; $ext = findexts($_FILES['Event_PDF']['name']) ; // POST Extension of File echo $ext; if($ext == "") { $_SESSION["FileUp"]= 0; } else { $_SESSION["FileUp"]= 1; } $tname = $Code."N".$NewsId."."; $filename = $tname.$ext; $uploadfile = $uploaddir.$filename; // echo "----->".$uploadfile; $_SESSION["uploadfile"] = $uploadfile; if($ext != "") { if(($_FILES['Event_PDF']['size']) > 20971520) { $errors['EventFL'] = "File Size is more than 20MB"; } //if((!ereg(".pdf", $filename))) { $errors['EventFL'] = "Event Brochure : Only PDF allowed"; } } } //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ print_r($errors); return (count($errors) == 0); } //--------------------------------------------------------------------------------------------------------------------------------------- // DISPLAY FORM FUNCTION //--------------------------------------------------------------------------------------------------------------------------------------- function outputOptionList($list, $selected) { foreach ($list as $item) echo "\n"; } function DisplayForm($values, $errors) { // $chars = "abcdefghijkmnopqrstuvwxyz023456789"; $i=0; $d=date(d); $m=date(F); $n=date(n); $y=date(Y); //print_r($optionListYear); ?>
} //--------------------------------------------------------------------------------------------------------------------------------------- $login = $_SESSION['AdminLogin'] ; $linkID = mysql_connect("localhost", "webuser", "zangtang"); mysql_select_db("SciPark"); $query0 = "SELECT * FROM AdminLogin WHERE `AdminLogin`='$login'"; $result0 = mysql_db_query("SciPark", $query0) or die ("could not query" . mysql_error()); $tung0=mysql_affected_rows(); $i=0; $j=0; if(isset($_SESSION['AdminLogin'])) { if($tung0) { if($_SERVER['REQUEST_METHOD'] == "POST") { //echo $_SESSION["TP"]; $formValues = $_POST; $formErrors = array(); //echo "the errors are :".$formValues."--".$Sname; if(isset($_POST["AddNews"])) { if(!VerifyForm($formValues, $formErrors)) DisplayForm($formValues, $formErrors); else { //$formValues = $_POST; //$formErrors = array(); $NewsTitle = $_POST["NewsTitle"]; $NewsURL = $_POST["NewsURL"]; $UpFile = $_POST["UpFile"]; $NewsDays = $_POST["NewsDays"]; $ND = $NewsDays." days"; $TillDate=Date("Y-m-d", strtotime($ND)); echo $TillDate; $date = date("Y-m-d"); echo $NewsTitle.$NewsDays; if (isset($NewsTitle) && isset($NewsDays)) { $Tag = "0"; $ExtraInfo = ""; $uploadfile = $_SESSION["uploadfile"]; $NewsId = $_SESSION["NewsId"]; //echo $uploadfile; if(move_uploaded_file($_FILES['Event_PDF']['tmp_name'], $uploadfile)) { chmod($uploadfile, 0644); //echo "The file ". basename( $_FILES['uploadedfile']['name'])." has been uploaded"; $_SESSION['EventFile'] = "Up"; $_SESSION['EventFLFile'] = $filename; } else { $errors['EventFL'] = "There was an error uploading the file, please try again!. File size must limit to 20 MB."; } if ( $_SESSION["FileUp"] == 0 ) { $uploadfile = ""; } if($UpFile == "Y") { $NewsLink = $uploadfile; } else { $NewsLink = $NewsURL; } $query = "INSERT INTO NewsScroll VALUES ('$NewsId','$NewsTitle','$NewsLink','$TillDate','A','$date')"; //echo $query ; $result = mysql_db_query("SciPark", $query) or die ("could not connect to database".mysql_error()); $tung1=mysql_affected_rows(); if($tung1 != 0) { $_SESSION["NewsAddedNo"] = $NewsId; header( 'Location: NewsAdded.php' ) ; } else { ?>
Problem with adding New Link into the Database...
} } else echo "Error found!!! Please fill the form correctly"; } //else close } else { $formValues = $_POST; $formErrors = array(); DisplayForm($formValues, $formErrors); }//echo $_POST["a_addr1"]; }//} ////////$_SESSIOM['H_HCBL'] = $H_HCBL; } else { DisplayForm(null, null); //echo "here1"; // } } } else { header( 'Location: Access_Denied.html' ) ; } ?>