PHP - Php Code Works In All Files Except For One

I have made a bit of code that queries the database for articles published within the last year.

<?php echo $numposts = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->posts WHERE post_status = 'publish' AND post_type = 'post' AND 'post_date' > '" . date("Y") . "-01-01-01 00:00:00'");
if (0 < $numposts) $numposts = number_format($numposts); ?>

I really don't even know how it works and need to because I want to figure out how to make it also get articles published within the last day, month and week.

I suppose if I understood what needs changing I might be able to work with it but so far everything I've tried either returns the exact same number or nothing at all.

It's for Wordpress just to note.

Any ideas?

Hi,

I have some code which works but when I created a function and call this same code it doesn't. The error I get is as follows:

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/fhlinux010/l/languageschoolsuk.com/user/htdocs/admin/email.php on line 42
Error retrieving schools

The code
function CreateSchoolCheckboxes()
{
echo '<div style="height:400px;width:400px;font:16px/26px Georgia, Garamond, Serif;overflow:scroll;">';

$querySchools = "SELECT * FROM school";
$result = mysql_query($querySchools, $conn)
or die ("Error retrieving schools ".mysql_error());

while($row = mysql_fetch_array($result))
{
$schoolname = $row['name'];    
echo '<input type="checkbox" name="school" value="'.$schoolname.'">';
echo $schoolname . '<br>';
}      

echo '</div>';
}

Im sure that this is probably something simple but any suggestions would be much appreciated.

Thanks,
Joe

Hello, 

I'm new on this forum and i have not seen the rules to post a code, so i will try to explain my best :

I have learned the basics of php during the past few days and i have a php code that is supposed to read parameters in several fields of a Mysql database and to return those parameters as variables in an array. (well that's how i understand it... please correct me if i'm wrong)

So here the code and the part that doesn't seem to work properly (colored in red) :

 //I have changed the following values which are confidential...
 $DBName = "MyDatabase";
 $DBHostName = "MyMysqlServer";
 $DBUserName = "MyUsername";
 $DBPassword = "MyPassword";
 $Table = "MyTable";
 //The fields which are in MyTable :
 // MemberID SMALLINT
 // MemberName VARCHAR(20)
 // MemberPassword VARCHAR(20)
 // MemberEmailAddress VARCHAR(50)
 // MemberDateTimeInscription VARCHAR(19)
 //Reading member parameters
  echo"<br>Reading the parameters of a member.";
  echo"<br>Defining the parameters of the member to read.";
  $CurrentName = "Ashley";
  $CurrentPassword = "65hl3y";
  $CurrentEmailAddress = "Ashley@HisDomain.com";
  echo"<br>Trying to start a connection with the Mysql server.";
  mysql_connect($DBHostName,$DBUserName,$DBPassword) OR DIE(mysql_error());
  echo"<br>Selecting the table.";
  mysql_select_db($DBName) OR DIE(mysql_error());
  echo"<br>Searching for the fields corresponding to the CurrentName.";
  $Query = "SELECT * FROM ".$Table." WHERE MemberName = '".$CurrentName."'"; 
  $Result = mysql_query($Query) or die(mysql_error());
  echo"<br>Returning the parameters stored in the fields.";
  while($Row = mysql_fetch_array($Result,MYSQL_ASSOC)){
   /////This is the start of the part that does not seem to work properly.
   $MemberId = $row["MemberId"];
   $MemberName = $row["MemberName"];
   $MemberPassword = $row["MemberPassword"];
   $MemberEmailAddress = $row["MemberEmailAddress"];
   $MemberDateTimeInscription = $row["MemberDateTimeInscription"];
   echo"<br>MemberId : ".$MemberId;
   echo"<br>MemberName : ".$MemberName;
   echo"<br>MemberPassword : ".$MemberPassword;
   echo"<br>MemberEmailAddress : ".$MemberEmailAddress;
   echo"<br>MemberDateTimeInscription : ".$MemberDateTimeInscription;
  /////This is the end of the part that does not seem to work properly.  
  }
  echo"<br>Ending the connection with the Mysql server.";
  mysql_close();


All of echo are here for debug, i'm a beginner with php.

This is what the php page shows :
Reading the parameters of a member.
Defining the parameters of the member to read.
Trying to start a connection with the Mysql server.
Selecting the table.
Searching for the fields corresponding to the CurrentName.
Returning the parameters stored in the fields.
MemberId :
MemberName :
MemberPassword :
MemberEmailAddress :
MemberDateTimeInscription :
Ending the connection with the Mysql server.

I don't understand why the variables $MemberId, $MemberName, $MemberPassword, $MemberEmailAddress, $MemberDateTimeInscription are empty.

Your advices are welcome,
Thanks,

Dear php freaks,

In my test file the following code works perfectly:

Code: [Select]
<!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" />
 <script language="javascript" type="text/javascript">
 function dropdownlist(listindex)
 {
 
document.formname.subcategory.options.length = 0;
 switch (listindex)
 {
 
case "1" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 
break;
 
case "2" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 
break;
 
case "3" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 document.formname.subcategory.options[4]=new Option("3","3");
 
break;

case "4" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 document.formname.subcategory.options[4]=new Option("3","3");
 document.formname.subcategory.options[5]=new Option("4","4");
 
break;

case "5" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 document.formname.subcategory.options[4]=new Option("3","3");
 document.formname.subcategory.options[5]=new Option("4","4");
 document.formname.subcategory.options[6]=new Option("5","5");
 
break;

case "6" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 document.formname.subcategory.options[4]=new Option("3","3");
 document.formname.subcategory.options[5]=new Option("4","4");
 document.formname.subcategory.options[6]=new Option("5","5");
 document.formname.subcategory.options[7]=new Option("6","6");

break;

case "7" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 document.formname.subcategory.options[4]=new Option("3","3");
 document.formname.subcategory.options[5]=new Option("4","4");
 document.formname.subcategory.options[6]=new Option("5","5");
 document.formname.subcategory.options[7]=new Option("6","6");
 document.formname.subcategory.options[8]=new Option("7","7");
break;

case "8" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 document.formname.subcategory.options[4]=new Option("3","3");
 document.formname.subcategory.options[5]=new Option("4","4");
 document.formname.subcategory.options[6]=new Option("5","5");
 document.formname.subcategory.options[7]=new Option("6","6");
 document.formname.subcategory.options[8]=new Option("7","7");
 document.formname.subcategory.options[9]=new Option("8","8");
break;

case "9" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 document.formname.subcategory.options[4]=new Option("3","3");
 document.formname.subcategory.options[5]=new Option("4","4");
 document.formname.subcategory.options[6]=new Option("5","5");
 document.formname.subcategory.options[7]=new Option("6","6");
 document.formname.subcategory.options[8]=new Option("7","7");
 document.formname.subcategory.options[9]=new Option("8","8");
 document.formname.subcategory.options[10]=new Option("9","9");
break;

case "10" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 document.formname.subcategory.options[4]=new Option("3","3");
 document.formname.subcategory.options[5]=new Option("4","4");
 document.formname.subcategory.options[6]=new Option("5","5");
 document.formname.subcategory.options[7]=new Option("6","6");
 document.formname.subcategory.options[8]=new Option("7","7");
 document.formname.subcategory.options[9]=new Option("8","8");
 document.formname.subcategory.options[10]=new Option("9","9");
 document.formname.subcategory.options[11]=new Option("10","10");
 
break;
 
}
 return true;
 }

 </script>
 </head>
 <title>Dynamic Drop Down List</title>
 <body>
 
<form id="formname" name="formname" method="post" action="submitform.asp" >
 <table width="50%" border="0" cellspacing="0" cellpadding="5">
 <tr>
 <td width="41%" align="right" valign="middle">Aantal kinderen :</td>
 <td width="59%" align="left" valign="middle"><select name="category" id="category" onchange="javascript: dropdownlist(this.options[this.selectedIndex].value);">
 <option value="">------</option>
 <option value="1">1</option>
 <option value="2">2</option>
 <option value="3">3</option>
 <option value="4">4</option>
 <option value="5">5</option>
 <option value="6">6</option>
 <option value="7">7</option>
 <option value="8">8</option>
 <option value="9">9</option>
 <option value="10">10</option>
 </select></td>
 </tr>
 <tr>
 <td align="right" valign="middle">Waarvan thuiswonend :
 </td>
 <td align="left" valign="middle"><script type="text/javascript" language="JavaScript">
 document.write('<select name="subcategory"><option value="">-----</option></select>')
 </script>
 <noscript><select name="subcategory" id="subcategory" >
 <option value="">Select Sub-Category</option>
 </select>
 </noscript></td>
 </tr>
 </table>
 
</form>
 
 
</body>
 </html>
 


When i want to implement it in my signup page, it doesnt do anything. I've checked it a thousand times, i double checked that also the

-formname of my signup page is 'formname'
-the element name stays 'subcategory'

I really need this to be implemented. Where can be the problem? What should i look for?

Hi all,
I am a bit of a noob when it comes to website building and php etc so please have patients with me I am learnig as I go.

I have come across this problem before and cannot remember what I did to fix it but any way it is presenting its self to me again.

I have this page: http://minecraftcons...a.com/index.php with an include file loading random images, however the same code on these pages:
http://minecraftconsolecrafting.comxa.com/sections/build-navi.php
http://minecraftconsolecrafting.comxa.com/sections/springhill-kingdom-01.php
are not working.

I have other websites that this method of coding is working fine on for example here is another of my websites:
http://divinegardensandlandscapes.com/index.php here the include code for random image loader is working fine on all pages it appears on so what is happening when this fail takes place?

Any help and or advice would be hugely appreciated, Thanks in advance.

Please remeber I am a noob when answering. Thanks
Edited by eGate-Network, 12 July 2014 - 10:55 PM.

Code: [Select]
<?php
$objConnect = mysql_connect("localhost","","cgdfgdfg") or die(mysql_error());
$objDB = mysql_select_db("ffdfvbbd");
$pic2 = "SELECT * FROM images";
if (!isset($_GET['Page'])) $_GET['Page']='0';
$pic1 = mysql_query($pic2);
$Num_Rows = mysql_num_rows($pic1);
$Per_Page = 16;   // Per Page
$Page = $_GET["Page"];
if(!$_GET["Page"])
{$Page=1;}
$Prev_Page = $Page-1;
$Next_Page = $Page+1;
$Page_Start = (($Per_Page*$Page)-$Per_Page);
if($Num_Rows<=$Per_Page)
{$Num_Pages =1;}
else if(($Num_Rows % $Per_Page)==0)
{$Num_Pages =($Num_Rows/$Per_Page) ;}
else
{$Num_Pages =($Num_Rows/$Per_Page)+1;
$Num_Pages = (int)$Num_Pages;}
$pic2 .="ORDER by thumbnailID DESC LIMIT $Page_Start , $Per_Page" ;
$pic1  = mysql_query($pic2);
$cell = 0;
$link1 = "SELECT * FROM images";
echo '
    <div id="tablediv">
      <table border="0" cellpadding="17" cellspacing="0" class="table">
        <tr>';

  while($pic = mysql_fetch_array($pic1)) {

    if($cell % 4 == 0) {
      echo '</tr><tr>';
    }

    if($cell == 2) {
      echo '
        <td>
          filler
        </td>';
    } elseif ($cell == 3) {
      echo '
        <td>
          filler
        </td>';
    } else {
      echo '
        <td>
          <a href="/' . $pic["link"] . '.php">
            <div class="image">
              <img src="https://s3.amazonaws.com/images/' . $pic["pic"] . '.png" 
                   alt="' . $pic["alt"] . '" 
                   height="200" 
                   width="200" 
              />
            </div>
          </a>
        </td>'; 
    }
    $cell++;
  }
  echo '</tr></table></div>';
?>The code above works just fine.

However, once I add a WHERE function,as shown below, I get a "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource" error.

Code: [Select]
<?php
$objConnect = mysql_connect("localhost","","cgdfgdfg") or die(mysql_error());
$objDB = mysql_select_db("ffdfvbbd");
$pic2 = "SELECT * FROM images WHERE folder = 'blog' "; //WHERE FUNCTION IS HERE
if (!isset($_GET['Page'])) $_GET['Page']='0';
$pic1 = mysql_query($pic2);
$Num_Rows = mysql_num_rows($pic1);
$Per_Page = 16;   // Per Page
$Page = $_GET["Page"];
if(!$_GET["Page"])
{$Page=1;}
$Prev_Page = $Page-1;
$Next_Page = $Page+1;
$Page_Start = (($Per_Page*$Page)-$Per_Page);
if($Num_Rows<=$Per_Page)
{$Num_Pages =1;}
else if(($Num_Rows % $Per_Page)==0)
{$Num_Pages =($Num_Rows/$Per_Page) ;}
else
{$Num_Pages =($Num_Rows/$Per_Page)+1;
$Num_Pages = (int)$Num_Pages;}
$pic2 .="ORDER by thumbnailID DESC LIMIT $Page_Start , $Per_Page" ;
$pic1  = mysql_query($pic2);

My mysql table includes column thumbnailID   folder   link   pic   alt   time

The folder column is there so I can specify what I want in the page.

Anyhow, why won't it work?

PHP = 5.5.14 MySQL = 5.2.17   This simple .php script works as a standalone OK:

<?php

require '<snip partial URL>mysqli.php';

// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$result = mysqli_query($con,"SELECT `callsign`, `qth`, `submitted` FROM `lqplogs` ORDER BY `callsign`");

echo "<table>
<tr>
<th><u>CALLSIGN</u></th><th><u>QTH</u></th><th><u>LOG SUBMITTED</u></th>
</tr>";


while($row = mysqli_fetch_array($result)) {
  echo "<tr>";
  echo "<td>" . $row['callsign'] . "</td>";
  echo "<td>" . $row['qth'] . "</td>";
  echo "<td>" . $row['submitted'] . "</td>";
  echo "</tr>";
}

echo "</table>";

mysqli_close($con);
?>

A separate .html page with other info works by itself OK too, but when I try to embed the PHP script (with PHP start & end tags, of course)  *between* these HTML tags:   <table> <tr> <td>   ... Full PHP Script Embedded here...   </td> </tr> </table>   I get this mess:

"; while($row = mysqli_fetch_array($result)) { echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
CALLSIGN	QTH	LOG SUBMITTED
" . $row['callsign'] . "	" . $row['qth'] . "	" . $row['submitted'] . "
"; mysqli_close($con); ?> 

Any thoughts as to why are appreciated.   Thanks!   - FreakingOUT    

Not sure if this is the right place for this, but I need to be able to run some PHP code before anything loads up on the server.

Inside one folder i have around 200 folder's and each folder's having 150 mp3 files.

I want to get metadata of each mp3 file's 

below is the code which i have tried but getting below error.

Fatal error: Uncaught exception 'UnexpectedValueException' with message 'RecursiveDirectoryIterator::__construct(C:\Users\Desktop\Rajesh song,C:\Users\Desktop\Rajesh song): The system cannot find the path specified. (code: 3)' in C:\xampp\htdocs\getID3-master\rajupal.php:4 Stack trace: #0 C:\xampp\htdocs\getID3-master\rajupal.php(4): RecursiveDirectoryIterator->__construct('C:\\Users\\Deskto...') #1 {main} thrown in C:\xampp\htdocs\getID3-master\rajupal.php on line 4

<?php
include("getid3/getid3.php"); 
$directory = 'C:\Users\Desktop\Rajesh song';
$filename = new RecursiveIteratorIterator(new RecursiveDirectoryIterator($directory));
while($filename->valid()) {
if (!$filename->isDot()) {
$getID3 = new getID3;
$file = $getID3->analyze($filename);
//print_r($file);
$playtime_seconds = $file['playtime_seconds'];
$dumpa=gmdate("H:i:s", $playtime_seconds);
$filesize = $file['filesize'];
$filepath = $file['filepath'];
$filename = $file['filename'];
$filename1 = $file['fileformat'];
echo "<table class='table table-striped'>";
echo "<tr>";
echo "<th>File Path</th>";
echo "<th>Name</th>";
echo "<th>Size(kb)</th>";
echo "<th>Duration</th>";      
echo "<th>File Type</th>";
echo "</tr>";
echo "<tr>";
echo "<td> ".$filepath."</td>";
echo "<td> ".$filename."</td>";
echo "<td> ".$filesize."</td>";
echo "<td> ".$dumpa."</td>";      
echo "<td> ".$filename1."</td>";      
echo "</tr>";
echo "</table>";
}
$filename->next();
}
?>

 

Edited July 26, 2020 by sapnawat

Hello everyone,

I'm having this problem which is really annoying, tried to solve it but couldn't, I write that code in PHPMyAdmin and it works great, but it doesn't work in the website it self

ok long story short, there are three tables, hotels, cities, countries
hotels include in addition to hotel info, 2 columns (city_id) and (country_id)
Cities include id and name and also countries include id and name

what I was trying to do, that when a person inputs a city or country name in the search form, it should get the hotels that exists in this city or country, but unfortunately it shows all the hotels in all cities and countries, although the pagination code for number of pages works just fine, it count the number of hotels in that city or country and show the number of pages correctly

so here is the code for both

for hotel search

Code: [Select]
class hotelManager
{


public function getHotel($where)
{
$where = isset($_POST['where']) ? $_POST['where'] : "";
$dbObj = new DB();
$sql = "select * from hotels where city_id = (select id from cities where name = '$where' ) or country_id = (select id from countries where name = '$where' )";
$result = MYSQL_QUERY($sql);
$arr = array();
echo "<table>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td valign=\"top\" width=\"120px\">";
$rowid = $row['id'];
$imageqry=mysql_query("SELECT * FROM `hotelphotos` where hotel_id='$rowid' LIMIT 1");
$image=mysql_fetch_array($imageqry);
$imagename=$image['attachmentName'];
echo "<img src=\"foxmaincms/webroot/files/small/$imagename\"/>";
echo "</td>";
echo "<td valign=\"top\">";

echo "<table>
<tr>
<td valign=\"top\">
<a href=\"hotels.php?id=".$row['id']."\" class=\"titleslink\">".$row['name']."</a>
</td>
</tr>
<tr>
<td class=\"text\" valign=\"top\">
".$row['location']."
</td>
</tr>
</table>";

echo "</td>";
echo "</tr>";
}
echo "</table>";

for hotel pagination

Code: [Select]
<?php
  include("includes/hotelsManager.php");
  $hotelObj = new hotelManager();
  $where = isset($_POST['where']) ? $_POST['where'] : "";
  if(isset($_POST['where']))
  {
    
$hotelObj -> getHotel($where);


$per_page = 9;

//Calculating no of pages
$sql = "select * from hotels where city_id = (select id from cities where name = '$where' ) or country_id = (select id from countries where name = '$where' )";
$result = MYSQL_QUERY($sql) or die("<br />No Hotels found in this city, please check the city name and try again");
$count = mysql_num_rows($result);
$pages = ceil($count/$per_page)
?>


<div id="loading" ></div>
<div id="maincontent" ></div>
<ul id="pagination">
thank you in advance

Hi guys, I need a help to find out what is a problem. Some of my code does not work on my local comp and in the same time it works well when I place it on Internet server.
First example:
Code: [Select]
<body>
<?php 
if($_POST['submit_form'] == "Submit") 
{ $varNewTeam = $_POST['Reg_Team']; 
$varNewCity = $_POST['Reg_City']; 

 $db = mysql_connect('localhost', 'root', '') or die ('no connection with server');
  mysql_select_db('db_m ,$db) or die('DB error');
mysql_query ("INSERT INTO reg2012 VALUES ('$varNewTeam','$varNewCity')") or die('insert error');
} 
?>
<form action="registration_2012_form.php" method="post">
<p>Team: <input type="text" name="Reg_Team" size="20" maxlength="50" value="<?=$varNewTeam;?>" /><br /></p>
<p>City: <input type="text" name="Reg_City" size="20" maxlength="50" value="<?=$varNewCity;?>" /><br /></p>
<p><input type="Submit" value="Submit" name="submit_form" /></p>
</form>
</body>
On local comp: It gives me message "Undefined index: submit_form".
On Net server works well.
If I split the code in two files. In the first one I leave the form with "action=FILE2.php" and put my php code in the second file "FILE2.php" - it starts work even on local server.

second example:
Code: [Select]
<body>
<?php 
  $db = mysql_connect('localhost', 'root', '') or die ('no connection with server');
  mysql_select_db('db_m' ,$db) or die('DB error');
mysql_query ("CREATE TABLE temp1 (team char(50), city char(50) )") or die('create tables error');
?>
</body>
It works in the Net and can not create the TABLE on my local comp.

I use XAMPP on my local comp (if it's important)

This one requires lots of up front information:

I have a page, for this example that I will call page.php. It takes get parameters, and for this example I'll call the parameter "step". So I have a URL like this: page.php?step=1 This page has a form with an action of page.php?step=1. The code on the page validates the posting information. If the information is bad, it returns the user to page.php?step=1; if it is good, it takes the user to page.php?step=2 via header( "location:page.php?step=2" ). So redirection is done by relative path, not full URLs.
This all works as expected.

Now what I've done is set .htaccess to be HTTPS for this page, via this code:

# Turn SSL on for payments
RewriteCond %{HTTPS} off
RewriteCond %{SCRIPT_FILENAME} \/page\.php [NC]
RewriteRule ^(.*)$ https://%{HTTP_HOST}/$1 [R=301,L]

This works (initially). However, once you try to post the form, it just redirects back to the step=1 version of the page. I really don't know how or why that would be.

I'm not sure how else I can explain this or what other information you may have. But it's frustrating to not get a page working in HTTPS that works in HTTP. Very odd. Any suggestions? (I don't even really know the best location to figure out when/why it's redirecting back to the original page.)

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?