|
PHP - 94 Files Php Form Using Ssl Certificate
Hello guys another difficult form case (for me)
I have this super long form that pulls different files depending on what you select. The form works perfectly fine right now. the problem is that now the client need to run the form with a SSL certificate due to gov regulations. we are hosting all the files in the same folder for the secure and unsecure site and the certificate works fine. however when I run the form with the https:// address google chrome tells me that parts of the form are unsecured. I was reading something about the images have to be on a relative path using img scr="../images/path/file.ext" instead of just img scr="images/path/file.ext". I made that change and it didnt solve the problem. I changed all the links to " ../ " and didn't solve the problem. I have added rules to the .htaccess file RewriteCond %{SERVER_PORT} !^443$ RewriteRule ^contact https://www.example.net/new-service.php [R=301,L] RewriteEngine On RewriteCond %{SERVER_PORT} 80 RewriteCond %{REQUEST_URI} somefolder RewriteRule ^(.*)$ https://www.example.net/inc/$1 [R,L] And even changed all the links in the form to absolute paths and nothing works. does anyone know how to force the form to work on SSL or troubleshoot SSL certificate errors to point me in the right direction thanks guys i appreciate your help and advice Similar TutorialsI have this form that is far to long. I need to set it up in 3 pages. One page about the person getting the Gift Certificate, one for the person purchasing the certificate and another for credit card information. I have read about hidden variable but am a noobie. Any thoughts would be greatly appreciated. Hi, I have a specific php form in my website: example: www.website.com/form/ I want it to open in https://www.website.com/form/ it is working fine The problem is how can I force it to always open the form folder (index.php) in https Because if somebody removes the S in https:// the site will open normally. Thank you, I saw the posting for creating a script for a certificate but am struggling to get it to work, i have tried everything I can think of but getting errors.
As you can see from this test link there is php errors that cannot be resolved.
http://gmdesign.org.uk/xxx
I have also added the javascript to a button to print the certificate it but its not working either.
I would be grateful for any help you can give.
you can download/see my full scripts by viewing the attached files Let's say that I have domain called www.mydomain.com with SSL certificate. Through .htaccess I have set up the domain to force SSL at all times, so users will see https://www.mydomain.com/... I had this site and SSL for while and there are serveral external links linking to my site, but they are all (or most) in "SSL format" https://www.mydomain.com/... If I should cancel my SSL certificate (and remove force SSL in .htaccess) that will happen when those "SSL formatted" links get clicked on? I assume users will get "not trusted connection" message? Any way arround that? As far as I undersestand the "SSL" handshake takes place before .htaccess gets loaded, so I will not be able to force SSL off on the links.
Thoughts?
Edited by pioneerx01, 26 December 2014 - 03:01 AM. Hello everyone! I'm new to PHP (and to this forum, too). My final goal is to make a script that recognises which websites have an Extended Validation certificate type and which ones do not. Except I don't know how to do it. For starters, I should download the X.509 certificate and analyse it (I use both the OpenSSL and cURL PHP extensions), but how? DAYS of googling have brought me absolutely nothing. Any tips are appreciated. I can provide more detail if need be. I'd provide source code if I had any but I really don't know where to start... Thanks! Should I always use HTTPS when users are inputting credit card numbers & billing info? Do you know any sites that don't use HTTPS? I just want to know if it's a total no-no for web applications. Discuss. I've been looking for a function or a couple of functions which will allow me to get the Certificate Expiration date for a given website. I've tried openSSL, but their functions only seem to work on the current server, which is useless to me because my server doesn't allow SSL or certificates. I just want the certificate of an external website, e.g. www.gna.org has a certificate (signed by themselves, but a certificate nonetheless). I've also tried cURL, since that allows you to access a remote server, but that will just check their certificate - it doesn't offer any functionality for e.g. checking when it will expire. This seems like a simple enough question, but I haven't found anything about it anywhere, so I'm asking here. Thanks a bunch in advance, -IsmAvatar I recently installed a SSL certificate for one of my domains, on a hosting account that includes several other domains. To redirect visitors to the SSL version of the website (because the SSL certificate only works for the www. version of the site) I use the following code in my .htaccess file:
#First rewrite any request to the wrong domain to use the correct one (here www.) We are working on a new student application system. Due to privacy laws, everything will be done behind https. However, this is one of many systems looked after by the system administrators. I would like to safeguard against the situation several years down the road when the certificate expires. There are several administration pages that will be checked frequently by the graduate admin assistant. While this person has no technical background, a warning several months before the certificate expires would allow her to remind the technical staff to renew the certificate. I know I can use curl to connect to my own server, but that seems like a long way to do it (and an extra https connection). Is there any way to get the certificate information for the current https connection from the server or from the php runtime? Hi folks, a few days back, we enabled SSL on our office server and the intranet migrated to https. Everything is ok on the intranet. On the public internet, we noticed today that the page on our website, which connects to our office server to fetch and display data was throwing an error, which I presumed was a Security Certificate issue... An area that's like the Dark Side of the Moon for me.. the webpage - https://liveconnections.in/hotjobs.php This is the error from the logs PHP Warning: file_get_contents(): SSL operation failed with code 1. OpenSSL Error messages: error:14090086:SSL routines:ssl3_get_server_certificate:certificate verify failed PHP Warning: file_get_contents(): Failed to enable crypto PHP Warning: file_get_contents(): SSL operation failed with code 1. OpenSSL Error messages: error:14090086:SSL routines:ssl3_get_server_certificate:certificate verify failed
Anycase, the internet was willing to help and so I updated the code to a curl function. The Data is not displaying still... Here's the code... where am i going wrong ?
<?php
//error_reporting(E_ERROR | E_PARSE | E_ALL);
$page="jobs-listing";
?>
<header class="section background-livec text-center">
<h3 class="text-white margin-bottom-0 text-size-40 text-thin text-line-height-1">Current & Hot Jobs</h3>
</header>
<?php
$industry = $_GET['industry'];
$location = $_GET['location'];
$expMin = $_GET['expMin'];
$expMax = $_GET['expMax'];
$sortBy = $_GET['sortBy'];
$cpg = $_GET['page'];
if(empty($cpg) || $cpg==1)
$npl = 1;
else {
//$npl = (($cpg+1)*10) - 9;
$npl = $_GET['startingRowNo'];
}
$industry = str_replace(' ', '%20', $industry);
$location = str_replace(' ', '%20', $location);
$url = "https://xx.xxx.xxx.xxx/WebService/rest/";
function file_get_contents_curl($url) {
$ch = curl_init();
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); //Set curl to return the data instead of printing it to the browser.
curl_setopt($ch, CURLOPT_URL, $url);
$data = curl_exec($ch);
curl_close($ch);
return $data;
}
if(!empty($sortBy)) {
$json = file_get_contents_curl($url.'getHeadersBySearch?industry='.$industry.'&location='.$location.'&expMin='.$expMin.'&expMax='.$expMax.'&sortBy='.$sortBy.'&startingRowNo='.$npl.'&noOfRows=1000000');
$data = json_decode($json);
} else if(!empty($industry) || !empty($location) || !empty($expMin) || !empty($expMax)) {
$json = file_get_contents_curl($url.'getHeadersBySearch?industry='.$industry.'&location='.$location.'&expMin='.$expMin.'&expMax='.$expMax.'&sortBy=&startingRowNo='.$npl.'&noOfRows=1000000');
$data = json_decode($json);
} else {
//$json = file_get_contents_curl($url.'getOnlineWebPosting');
$json = file_get_contents_curl($url.'getHeadersBySearch?industry='.$industry.'&location='.$location.'&expMin='.$expMin.'&expMax='.$expMax.'&sortBy=&startingRowNo='.$npl.'&noOfRows=1000000');
$data = json_decode($json);
//if (!$data) echo "Data Not Found" ;
}
if($sortBy=='DESC' || $sortBy=='') {
$aclass = 'down_arrow';
} else {
$aclass = 'up_arrow';
}
$json2 = file_get_contents_curl($url.'getSearchData');
$data2 = json_decode($json2);
$industry = str_replace('%20', ' ', $industry);
$location = str_replace('%20', ' ', $location);
if($industry=='F amp A - BPO') {
$industry = 'F & A - BPO';
}
if($industry=='OIL amp GAS') {
$industry = 'OIL & GAS';
}
?>
<div class="section background-white">
<div class="background-white">
<p class="text-padding-bot text-letter-spacing1">A cross-section of Jobs currently available. We recommend you to contact our Executives for further info. <br />
More details available when the Job is '<strong>View'</strong>ed. </p>
</div>
<?php
//$data='';
//if($data!=''){ ?>
<?php //if ($checkyear>2017) { ?>
<div class="subJobs">
<ul>
<li> Industry <br />
<select name="industry" id="industry" class="sel">
<option value="">Select Industry Name</option>
<?php for($i=0; $i<count($data2[0]); $i++) { ?>
<?php if(isset($industry) && $industry==$data2[0][$i]) { ?>
<option selected value="<?php echo $data2[0][$i];?>"><?php echo $data2[0][$i];?></option>
<?php } else { ?>
<option value="<?php echo $data2[0][$i];?>"><?php echo $data2[0][$i];?></option>
<?php }
} ?>
</select>
</li>
<li>Location<br />
<select name="city" id="city" class="sel">
<option value="">Select City Name</option
><?php $m=0; for($j=0; $j<count($data2[1]); $j++) { ?>
<?php $locat = explode(",",$location); ?>
<?php if($locat[$m]!="" && $locat[$m]==$data2[1][$j]) { ?>
<option selected value="<?php echo $data2[1][$j];?>"><?php echo $data2[1][$j];?></option>
<?php ++$m; } else { ?>
<option value="<?php echo $data2[1][$j];?>"><?php echo $data2[1][$j];?></option>
<?php }
} ?>
</select>
</li>
<li>Experience <br />
<select name="minyear" class="sel2" id="minyear">
<option value="">Min</option>
<?php for($ii=0; $ii<46; $ii++) { ?>
<?php if($expMin!="" && $expMin==$ii) { ?>
<option selected value="<?php echo $ii; ?>"><?php echo $ii; ?></option>
<?php } else { ?>
<option value="<?php echo $ii; ?>"><?php echo $ii; ?></option>
<?php }
} ?>
</select>
<select name="maxyear" class="sel2" id="maxyear" onchange="return select_max();">
<option value="">Max</option>
<?php for($ii=0; $ii<51; $ii++) { ?>
<?php if($expMax!="" && $expMax==$ii) { ?>
<option selected value="<?php echo $ii; ?>"><?php echo $ii; ?></option>
<?php } else { ?>
<option value="<?php echo $ii; ?>"><?php echo $ii; ?></option>
<?php }
} ?>
</select>
<!-- select name="" class="sel2" id="sort">
<option value="">Select</option>
<option value="ASC">ASC</option>
<option value="DESC">DESC</option>
</select -->
</li>
<li class="ser"><button type="button" onclick="search_by_category()" class="btn btn-default" style="margin-top:25px;"><i class="fa fa-search"></i> Search</button></li>
</ul>
</div>
<!-- Selected Jobs Headline Info -->
<div class="line">
<p class="text-dark text-center text-size-16">
<?php if($industry) echo 'Showing ' . '<b>' . $industry .'</b>' . ' Jobs' ; ?>
<?php if($location) echo ' at ' . '<b>' . $location .'</b>' ; ?>
<?php if($expMin) echo ' with Min ' . '<b>' . $expMin .'</b>' ; ?>
<?php if($expMax) echo ' to Max '. '<b>' . $expMax.'</b>' ; ?>
<?php if($expMin | $expMax) echo ' Years Experience' ;?>
</p>
</div>
<!-- Jobs Table -->
<table id="example" class="display" cellspacing="0" width="100%">
<thead>
<tr>
<th class="jobs_noshow text-center" width="5%">S.No</th>
<th class="text-center" width="15%">Posted On</th>
<th class="text-center" width="30%">Job Title</th>
<th class="jobs_noshow text-center" width="15%">Level</th>
<th class="jobs_noshow text-center" width="15%">Location</th>
<th class="jobs_noshow text-center" width="15%">Job Code</th>
<th class="text-center" width="5%">Action</th>
</tr>
</thead>
<tbody>
<?php $ri=1; foreach($data as $kk=>$d) { ?>
<?php
$date_posted = $d->postedDate; // get the Posted Date
$date_posted_year=date("Y",strtotime($date_posted)); // Get the Year from the date and store in a variable
if ($date_posted_year>$jobs_restrict_year) { // Show only Jobs posted after this year ?>
<tr>
<td class="jobs_noshow text-center"><?php echo $ri; ?></td>
<td class="text-center"><?php echo $d->postedDate; ?></td>
<td><?php echo $d->title; ?></td>
<td class="jobs_noshow ctext notreq"><?php echo $d->level; ?></td>
<td class="jobs_noshow text-center notreq"><?php echo $d->location; ?></td>
<td class="jobs_noshow text-center"><?php echo $d->requirementID; ?></td>
<td class="text-center"><a class="button background-livec border-radius text-white" style="color:white" data-fancybox="ajax" href="?contentid=jobs-detail&requirementID=<?php echo $d->requirementID; ?>&requirementSeqNo=<?php echo $d->requirementSeqNo; ?>" data-type="ajax">View</a></td>
</tr>
<?php } ?>
<?php $ri=$ri+1; } ?>
</tbody>
</table>
<script type="text/javascript">
$(document).ready(function () {
var table = $('#example').DataTable( {
"pageLength": 25,
"sPaginationType":"full_numbers",
"oLanguage": {
"sInfo": 'Showing _START_ to _END_ of _TOTAL_ Jobs.',
"sInfoEmpty": '',
"sEmptyTable": "No Jobs found currently",
}
});
$('#example').removeClass( 'display' ).addClass('table table-striped table-bordered');
});
</script>
<style> .dataTables_filter { display: none; } </style>
<!-- End of Table -->
</div>
<?php // } else { ?>
<div style="margin: 20px 0 40px 0px;height:200px;text-align:center;">
<h1 style="font-size:16px;">Server is unavailable at the moment. Please try after some time.</h1>
</div>
<?php //}?>
</div>
<!--jobs end-->
<script type="text/javascript">
function search_by_category() {
industry = $('#industry option:selected').val();
//city1 = $('#city option:selected').val();
minyear = $('#minyear option:selected').val();
maxyear = $('#maxyear option:selected').val();
//sortBy = $('#sort option:selected').val();
var city = $('select#city').val();
var cur_pg = "<?php echo $cpg; ?>";
var tot = "<?php echo $total; ?>";
var tot_pgs = Math.ceil(tot/25);
//if(cur_pg=="")
cur_pg = 1;
var last_pg = tot_pgs - cur_pg;
if(last_pg==0)
records = tot - ((tot_pgs -1) * 25);
else
records = 25;
var strt_val = ((cur_pg-1) * 25) + 1;
if(industry=='F & A - BPO')
industry ='F amp A - BPO';
if(industry=='OIL & GAS')
industry ='OIL amp GAS';
city1 = document.getElementById("city").value;
if(city1=="" || city1=="null") {
city="";
}
if(industry!="" || city!="" || minyear!="" || maxyear!="") {
location.href="hotjobs.php?contentid=hotjobs&industry="+industry+"&location="+city+"&expMin="+minyear+"&expMax="+maxyear+"&sortBy=&startingRowNo=1"+"&noOfRows="+records+"&page="+cur_pg;
} else {
//alert("Please select any one of the fields");
location.href="hotjobs.php?contentid=hotjobs&industry="+industry+"&location="+city+"&expMin="+minyear+"&expMax="+maxyear+"&sortBy=&startingRowNo=1"+"&noOfRows="+records+"&page="+cur_pg;
}
}
function sort_by_location() {
var order = '<?php echo $sortBy; ?>';
industry = $('#industry option:selected').val();
city = $('#city option:selected').val();
minyear = $('#minyear option:selected').val();
maxyear = $('#maxyear option:selected').val();
city1 = document.getElementById("city").value;
if(industry=='F & A - BPO')
industry ='F amp A - BPO';
if(industry=='OIL & GAS')
industry ='OIL amp GAS';
if(city1=="") {
city="";
} else {
city = $('select#city').val();
}
if(order=="" || order=="DESC") {
location.href="hotjobs.php?contentid=hotjobs&industry="+industry+"&location="+city+"&expMin="+minyear+"&expMax="+maxyear+"&sortBy=ASC"+"&startingRowNo=1&noOfRows=10";
} else {
location.href="hotjobs.php?contentid=hotjobs&industry="+industry+"&location="+city+"&expMin="+minyear+"&expMax="+maxyear+"&sortBy=DESC"+"&startingRowNo=1&noOfRows=10";
}
}
function select_max() {
minyear = document.getElementById("minyear").value;
maxyear = document.getElementById("maxyear").value;
if(parseInt(maxyear)>=parseInt(minyear)) {
return true;
} else {
if(maxyear!="") {
alert("Maximum year must be equal or greater than minimum year");
$('#maxyear').val("");
return false;
}
}
}
</script>
Also, if i change the $url in my code to https:// , no data is displayed... I raised a Support request to the Hosting provider, but they seem to have vanished into the ozone.... Any help would be highly appreciated. Cheers - Murali
I wrote this script to rename my many tv series I have on my pc, works by finding a string in the file name and replacing it
the script works fine until I want to replace the file name with something that is also in the path
file = band ep01.avi
path = j:\media\ TV shows\Band of Brothers\
so if I try to change "Band" to "Band of Brothers" the path changes as well
is there a way I can change the code so it dosent effect the path ??
<?php
$path = 'J:\media\TV shows\Band of Brothers';
foreach(glob($path.'/*.*') as $filename){
echo $filename."</BR>";
}
?>
<table align="center" width="200px" border="0" cellspacing="1" cellpadding="3">
<form name="form1" method="get" action="mov.php">
<tr>
<td colspan="3"><strong> </strong></td>
</tr>
<tr>
<td width="71">Replace</td>
<td width="6">:</td>
<td width="301"><input name="rep" type="text" id="rep"></td>
</tr>
<tr>
<td>With</td>
<td>:</td>
<td><input name="with" type="text" id="with"></td>
</tr>
<tr>
<tr>
<td colspan="3" align="center"><input type="submit" name="Submit" value="Submit"></td>
</tr></form>
</table>
<?php
if (isset($_GET["rep"])) {
$rep1=$_GET['rep'];
}
if (isset($_GET["with"])) {
$with1=$_GET['with'];
}
foreach(glob($path.'/*.*') as $filename){
$strip = str_replace($rep1, $with1, $filename);
echo $strip."</br>";
rename($filename,$strip);
}
?>
Hi, I want to update a txt files 10. row with a form but I could not it how can I do it? I currently have a small 2 page message board, the main file is named index.php and the other core.php - I would like to rename the main file with the form to chat.php, but when I do that, the script no longer posts messages, and goes to the website root. Can someone tell me whats wrong? Here is the form info from the current index.php (that i wish to rename chat.php) Code: [Select] <form action="./" method="post"> <p>name (25 chars max)<br> <input id="name" name="author" maxlength="20" size="25"></p> <p>message (150 chars max)<br> <input id="message" name="message" maxlength="150" size="45"></p> <p>what is <?php echo "$num1 &#43; $num2?" ?><br> <input id="captcha" name="captcha" maxlength="2" size="10"></p> <p><input id="submit" name="submit" type="submit" value="submit"> (ip addresses are recorded)</p> </form> and the 2nd file core.php's function that I think is acting up (here or with the form above?) function getPosts() { $author = isset($_POST['author']) ? $_POST['author'] : false; $message = isset($_POST['message']) ? $_POST['message'] : false; global $nameMax; global $messageMax; global $error; if ($author && $message && ($error==false) ) { if (strlen($author) <= $nameMax && strlen($message) <= $messageMax) { $this->inputPost($author, $message); header('Location: ./'); } Why when I rename index.php to chat.php is it not working and falling back to the website root when I submit? any help would be great! I am sure it is something simple, but I am new...
I have a hopefully small issue on a form submitting data to the mysql database table and email. The email side works fine as does the adding the data to the database table but if I upload two files, it stores the support ticket twice in the database table where as I want to store just once and the files be stored as a array in the database table. I got the code from the link https://www.codexworld.com/upload-multiple-images-store-in-database-php-mysql/
<?php
require_once "registerconfig.php";
if (isset($_POST['submit'])) {
// File upload configuration
$targetDir = "support-ticket-images/";
$allowTypes = array('pdf','doc','docx','jpg','png','jpeg','gif');
$statusMsg = $errorMsg = $insertValuesSQL = $errorUpload = $errorUploadType = '';
// Escape user inputs for security
$ticket_subject = htmlentities($_POST['ticket_subject'], ENT_QUOTES);
$ticket_message = strip_tags($_POST['ticket_message'], ENT_QUOTES);
$ticket_status ='PENDING SUPPORT';
$username = htmlentities($_SESSION["user_name"], ENT_QUOTES);
$user_id = htmlentities($_SESSION["user_id"], ENT_QUOTES);
$fileNames = array_filter($_FILES['files']['name']);
if(!empty($fileNames)){
foreach($_FILES['files']['name'] as $key=>$val){
// File upload path
$fileName = basename($_FILES['files']['name'][$key]);
$targetFilePath = $targetDir . $fileName;
// Check whether file type is valid
$fileType = pathinfo($targetFilePath, PATHINFO_EXTENSION);
if(in_array($fileType, $allowTypes)){
// Upload file to server
if(move_uploaded_file($_FILES["files"]["tmp_name"][$key], $targetFilePath)){
// Image db insert sql
$insertValuesSQL .= "('".$ticket_subject."','".$ticket_message."','".$fileName."','".$ticket_status."','".$username."', '".$user_id."'),";
}else{
$errorUpload .= $_FILES['files']['name'][$key].' | ';
}
}else{
$errorUploadType .= $_FILES['files']['name'][$key].' | ';
}
}
if(!empty($insertValuesSQL)){
$insertValuesSQL = trim($insertValuesSQL, ',');
// Insert image file name into database
$insert = $link->query("INSERT INTO DB TABLE NAME (ticket_subject, ticket_message, file_name, ticket_status, user_name, user_id) VALUES $insertValuesSQL");
if($insert){
$to = "emailaddress";
$subject = "A new support ticket has been submitted";
$message = " <strong>$username</strong> has just created a support ticket, below is the support ticket
<br /><br />
<u>Support Ticket Details</u>
<br /><br>
<strong>Support Ticket Subject</strong>: $ticket_subject
<br/><br><strong>Support Ticket Message</strong>: $ticket_message
<p><strong><u>Support Ticket Files</u></strong>
<br>
<img src='$fileName'>
";
// Always set content-type when sending HTML email
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=iso-8859-1" . "\r\n";
// More headers
$headers .= 'From: <noreply@emailaddress>' . "\r\n";
$mail=mail($to,$subject,$message,$headers);
$errorUpload = !empty($errorUpload)?'Upload Error: '.trim($errorUpload, ' | '):'';
$errorUploadType = !empty($errorUploadType)?'File Type Error: '.trim($errorUploadType, ' | '):'';
$errorMsg = !empty($errorUpload)?'<br/>'.$errorUpload.'<br/>'.$errorUploadType:'<br/>'.$errorUploadType;
header("location: support-ticket-confirmation?user=$username");
}else{
$statusMsg = "Sorry, there was an error uploading your file.";
}
}
}else{
$statusMsg = 'Please select files to upload.';
}
// Display status message
echo $statusMsg;
}
?>
The structure of the db table column is file_name, VARCHAR(255), latin1_swedish_ci, NOT NULL Hello I have a simple question about file handling... Is it possible to list all files in directories / subdirectories, and then read ALL files in those dirs, and put the content of their file into an array? Like this: array: [SomePath/test.php] = "All In this php file is being read by a new smart function!"; [SomePath/Weird/hello.txt = "Hello world. This is me and im just trying to get some help!";and so on, until no further files exists in that rootdir. All my attempts went totally crazy and none of them works... therefore i need to ask you for help. Do you have any ideas how to do this? If so, how can I be able to do it? Thanks in Advance, pros So far I have managed to create an upload process which uploads a picture, updates the database on file location and then tries to upload the db a 2nd time to update the Thumbnails file location (i tried updating the thumbnails location in one go and for some reason this causes failure) But the main problem is that it doesn't upload some files Here is my upload.php
<?php
include 'dbconnect.php';
$statusMsg = '';
$Title = $conn -> real_escape_string($_POST['Title']) ;
$BodyText = $conn -> real_escape_string($_POST['ThreadBody']) ;
// File upload path
$targetDir = "upload/";
$fileName = basename($_FILES["file"]["name"]);
$targetFilePath = $targetDir . $fileName;
$fileType = pathinfo($targetFilePath,PATHINFO_EXTENSION);
$Thumbnail = "upload/Thumbnails/'$fileName'";
if(isset($_POST["submit"]) && !empty($_FILES["file"]["name"])){
// Allow certain file formats
$allowTypes = array('jpg','png','jpeg','gif','pdf', "webm", "mp4");
if(in_array($fileType, $allowTypes)){
// Upload file to server
if(move_uploaded_file($_FILES["file"]["tmp_name"], $targetFilePath)){
// Insert image file name into database
$insert = $conn->query("INSERT into Threads (Title, ThreadBody, filename) VALUES ('$Title', '$BodyText', '$fileName')");
if($insert){
$statusMsg = "The file ".$fileName. " has been uploaded successfully.";
$targetFilePathArg = escapeshellarg($targetFilePath);
$output=null;
$retval=null;
//exec("convert $targetFilePathArg -resize 300x200 ./upload/Thumbnails/'$fileName'", $output, $retval);
exec("convert $targetFilePathArg -resize 200x200 $Thumbnail", $output, $retval);
echo "REturned with status $retval and output:\n" ;
if ($retval == null) {
echo "Retval is null\n" ;
echo "Thumbnail equals $Thumbnail\n" ;
}
}else{
$statusMsg = "File upload failed, please try again.";
}
}else{
$statusMsg = "Sorry, there was an error uploading your file.";
}
}else{
$statusMsg = 'Sorry, only JPG, JPEG, PNG, GIF, mp4, webm & PDF files are allowed to upload.';
}
}else{
$statusMsg = 'Please select a file to upload.';
}
//Update SQL db by setting the thumbnail column to equal $Thumbnail
$update = $conn->query("update Threads set thumbnail = '$Thumbnail' where filename = '$fileName'");
if($update){
$statusMsg = "Updated the thumbnail to sql correctly.";
echo $statusMsg ; }
else
{ echo "\n Failed to update Thumbnail. Thumbnail equals $Thumbnail" ; }
// Display status message
echo $statusMsg;
?>
And this does work on most files however it is not working on a 9.9mb png file which is named "test.png" I tested on another 3.3 mb gif file and that failed too? For some reason it returns the following Updated the thumbnail to sql correctly.Updated the thumbnail to sql correctly. Whereas on the files it works on it returns REturned with status 0 and output: Retval is null Thumbnail equals upload/Thumbnails/'rainbow-trh-stache.gif' Failed to update Thumbnail. Thumbnail equals upload/Thumbnails/'rainbow-trh-stache.gif'The file rainbow-trh-stache.gif has been uploaded successfully. Any idea on why this is? I am using WPSQT plugin in my blog site .I code some files in PHP also.how to add that files in plugin files.
first of all...its good to see the site back .
my question guys is i'm wondering is there a way of getting the column number when reading a .cvs file?
ie. a, b, c, d, aa, ab etc?
$row = 1;
if (($handle = fopen($file, "r")) !== FALSE)
{
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)
{
$num = count($data);
echo "<p> $num fields in line $row: <br /></p>\n";
$row++;
for ($c=0; $c < $num; $c++)
{
//echo $data[$c] . "<br />\n";
}
}
fclose($handle);
}
now $num counts the columns...but i want to convert that into a alphabetical column...is there a easy solution?
thanks guys
lets say I own a file, and you own a file, both these files are the exact same file, the only difference is the filename. So lets say we both have The Gimp 2.6 but one is named TG2.6.exe and the other is named the_Gimp-2.6.exe. What would be the best way to count the files that are the same even if they have a different file name? Another example would be: I have a file called me.jpg and someone else has a file me.jpg but they are two completely different pictures. What would I do to tell that? Hey, Trying to learn to generate PDF files, something apparently WAAAAYYY more complex than I thought. Can someone please give me an explanation on '$optlist' from this function..... PDF_load_image ( resource $pdfdoc , string $imagetype , string $filename , string $optlist ) What is it? PHP.net doesn't have any info at all. Thanks, IceKat. BTW - Any (recent) tutorials or pages would be appreciated. Everything I find is out of date or doesn't work. |
|||||||