PHP - Jquery Directory Tree Check Box Delete Form

Hello
i have a text box and a button on my webpage and want to get the text box to find the username i type into it from the database and when it does it will then go to number and delete any text that is under usernames number field as you can see i have no idea how.

Code: [Select]
$result = mysql_query("DELETE FROM mytable WHERE username='$username1' AND number='$number1'" );
Code: [Select]
<form name="form1" method="post" action="p.php">
<p><input type="submit" value="Enter" /></p>
<input name="username" type="text" id="username" size="15" maxlength="35" value="<?php echo $username1; ?>" />
</form>

Can I use php to delete multiple rows that have a checkbox selected. I'm not sure how to go about doing this.  Any  suggestions? 

 if ($d = opendir("uploads")) {
    while ($file = readdir($d)) {
      if ($file != "." && $file != ".."    )
   //  if( is_file($file) )
       {
        $files[] = $file;
      }
    }
    closedir($d);
  }

if ($file != "." && $file != ".."    $file !=  ????????  )   just a bit stuck here

Hello, Its my first day coding so please forgive me for some of the silly errors I might make.   I am writing a small upload script and I want to have some sort of orginazation by uploading images to a direcotry based on the day.

The following is my code but it will fail to save the file   Warning: file_put_contents(images/14-09-26/5425905a18bba.png): failed to open stream: No such file or directory   This is becuase the directory with the data part is not created how should I go about first checking that this directory is there and then creating it ?
 

<?php
ini_set('display_errors',1); 
error_reporting(E_ALL);

$today = date('y-m-j'); 
define('UPLOAD_DIR', 'images/' .$today. '/');
$img = $_POST['data'];
$img = str_replace('data:image/png;base64,', '', $img);
$img = str_replace(' ', '+', $img);
$data = base64_decode($img);
$file = UPLOAD_DIR . uniqid() . '.png';
$success = file_put_contents($file, $data);
print $success ? $file : 'Unable to save the file.';
?>

I am trying to come up with a backlink checker without a page refresh, i have come up with the code for the checking and is in form_requests.php

Code: [Select]

$linkAction = $_POST['action'];
$recip_url= $_POST['recip_url'];

if($lnkAction == '1' && isset($recip_url))
{
$this_url = 'http://www.my_url.co.uk';

$recip_url = $recip_url;

$source = fopen($recip_url, 'r');

$contents = stream_get_contents($source);

if(stristr($contents, $this_url)) {
echo '0';
} else {
echo '1';
}

fclose($source);
}

I know this works fine

Here is the code from the requesting page

Quote

<!-- INCLUDE cont_header.html -->
<script>
$(document).ready(function(){
   $("#copy").click(function(){
       $.copy($("#backlink").html());
   });
   $("#close").click(function(){
      $("#modal").fadeTo('slow', 0, function(){
         $("#lightbox").fadeTo('slow', 0, function(){
            $("#modal").remove();
            $("#lightbox").remove();
         });
      });
   });   
   $("#ChkLink").click(function(){
      var linkUrl = $("#recip_url").val();
      var lnkAction = $('#lnkAction').val();
      
      if(linkUrl<1) {
         alert("the link check box is empty");
         return false;
      }
      
      if(!linkUrl.match(/https?:\/\/([-\w\.]+)+(:\d+)?(\/([\w/_/\.]*(\?\S+)?)?)?/)) {
         alert("you entered an invalid url");
         return false;
      }
      
      var dataString = '&lnkAction=' + lnkAction + '&recip_url=' + linkUrl;
      
      $("#checking").html('<img src="./styles/images/preloader_small.gif" width="25" height="25" /> checking backlink...');
      
      //alert(dataString);
      
      $.ajax({
         type: "POST",
         url: "./form_request.php",
         data: dataString,
         success: function(data) {
            if(data!='1') {
               $("#recip_url").val('');
               $("#checking").html('backlink found');
            }
            else
            { 
               alert('not found');
            }
         }
      });
      return false;
   });
});
</script>
<p style="color:#003"><strong>Please copy and paste the code below to your website then enter the page URL in the box below and select check. Alternatively you can hit the copy text button then just paste your clipboard contents to your page.</strong></p>
<hr />
<p style="background-color:#CCC">
<table cellspacing="4">
   <tr>
     <td valign="top">Title</td>
     <td valign="top" bgcolor="#FFFFFF">{BACK_T}</td>
  </tr>
   <tr>
     <td valign="top">Description</td>
     <td valign="top" bgcolor="#FFFFFF">{BACK_D}</td>
  </tr>
   <tr>
     <td valign="top">URL</td>
     <td valign="top" bgcolor="#FFFFFF">{BACK_U}</td>
  </tr>
</table>

<div id="backlink" style="width:500px; background-color:#DDFFFE; display:none">
{BACKLINK}
</div>
<p align="center">
  <button id="copy">copy html text code</button>
</p>
<p align="center" id="checking">
<br />
<form id="checklinkfrm" name="checklinkfrm">
<input type="text" style="width:250px" id="recip_url" name="recip_url" />
<input type="hidden" style="width:250px" id="lnkAction" name="lnkAction" value="1" />
<input type="submit" name="ChkLink" id="ChkLink" value="check link" />
</form>
</p>
<p align="center">
    <input type="button" name="close" id="close" value="{CLOSE}" class="button"  />
</p>



Outside jquery everything works fine but using jquery i get alerts if a invalid url is entered and if the field is blank but if everything is correct all i get is the preloader

hi

people can vote 3 times with 3 select menus
but i want them not to be able to choose 3x the same select option

the options in the select menus come out of the database

this is how i let them vote

Code: [Select]
<?php

include("./includes/egl_inc.php");
$secure = new secure();
$secure->secureGlobals();
session_start();

if (isset ($_GET['match'])) 
{ 

$matchid = (int)$_GET['match'];
$_SESSION['matchid'] = $matchid;
$matchmaps = mysql_fetch_array(mysql_query("SELECT maps,game FROM ffa_matches WHERE id=$matchid"));
$matchmapschecker = $matchmaps[maps];
$matchgamechecker = $matchmaps[game];

$maps=mysql_query("SELECT id,map FROM ffa_maplists where gameid = $matchgamechecker");
while(list($id,$map)=mysql_fetch_row($maps))
{ 
$maplist.="<option value='$id'>$map</option>\n";

}


  $out[body].="<table width='98%' border='0' cellspacing='0' cellpadding='0' style='border:1px solid black'>
   <tr style='color:#cccccc; background-color:black;'>
<td valign='middle' background='$config[bg2]' align='center' colspan='10'>

<br/>Choose Maps<br/>
</td>
   </tr></table><table width='98%' border='0' cellspacing='0' cellpadding='0' style='border:1px solid black'>
<tr style='background-color:black;'>
<td>
<form action='ffainsertmapvote.php' method='post'>
<select name='map1'>$maplist</select>
<select name='map2'>$maplist</select>
<select name='map3'>$maplist</select>
<input type='hidden' name='match' value='$matchid' />
<input type='submit' value='Vote' />
</form> </td>
</tr></table>";


}



include("$config[html]");
?>

do i need jquery to fix this? i dont want the user to be able to go to a next screen without having max 2 the same options selected

thanks in advance !

Ok this is puzzleing. I am geting "Could not delete data: 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 '1' at line 1". but its is deleting the entry that needs to be removed. The "1" is the entry. Just not sure what is causing the error. I do have another delete php but I have put that on the back burning for the time being.     <?php

         $con = mysqli_connect("localhost","user","password","part_inventory");
    // Check connection
if (mysqli_connect_errno()) {
  printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
} else {
    
    $result = mysqli_query($con, "SELECT * FROM amp20 ");
    
    $amp20ptid = $_POST['amp20ptid'];                // escape variables for security
    $amp20ptid = mysqli_real_escape_string($con, $_POST['amp20ptid']);
    
    mysqli_query($con, "DELETE FROM amp20 WHERE amp20ptid = '$amp20ptid'");
      
    
if (!mysqli_query($con, $amp20ptid));

{
 die('Could not delete data: ' . mysqli_error($con));    
}
 echo "Part has been deleted to the database!!!\n";
    mysqli_close($con);
}
?>

I am new to php and I thought it best to start by using a CMS and creating small functions to extend it's functionality. I will start by explaining the situation around what I want to do. I am trying to create a module for the drupal CMS. The module I am trying to create I am creating for my girlfriends son (for when it is complete he will be the one maintaining it through the web interface). He wants a game server (WOW) and a web site that once they create an account on the web site it will create an account on the game server as well. If I understand the way this works correctly for this game server to work you need a logon database and then a character and world database for each realm you have. With that basically what happens is you go to the drupal web site and click create account, input a username, email address and password and agree to terms of service. Then drupal does some checks and writes the information to the drupal database and with the module I creating it will write to the logon database as well. I am working on the admin forms so you can edit how many realms the server has the sql statement to login to the game and add and delete realms. I have been looking at an example of a form for drupal here http://drupal.org/node/717746 but have converted it to my purpose and it brings up some questions here is what I have so far:

function wowcp_gameserver_settings($form_state) {
    $form['server'] = array(
        '#type' => 'fieldset',
        '#title' => t('WOW Game Server Core'),
    );
    $form['server']['decision'] = array(
        '#type' => 'select',
        '#title' => 'Select the Server Core that your WOW server runs on',
        '#options' => array('TrinityCore2', 'ArcEMU', 'Aspire', 'Mangos'),
        '#default_value' => TrinityCore2,
     );
    $form['server']['sql_command'] = array(
        '#type' => 'textfield',
        '#title' => 'Select the SQL command for your server core',
        '#size' => 150,
    );
    $form['server']['max_realms'] = array(
        '#type' => 'textfield',
        '#title' => t('Select the maximum realms allowed'),
        '#size' => 2,
    );
    $form['logon'] = array(
        '#type' => 'fieldset',
        '#title' => t('WOW Game Server LOGON database setup')
    );
    $form['logon']['logon_db'] = array(
        '#type' => 'textfield',
        '#title' => t('Enter the name of the LOGON database'),
        '#size' => 25,
    );
    $form['logon']['logon_username'] = array(
        '#type' => 'textfield',
        '#title' => t('Enter the username for the LOGON database'),
        '#size' => 25,
    );
    $form['logon']['logon_password'] = array(
        '#type' => 'textfield',
        '#title' => t('Enter the password for the LOGON database'),
        '#size' => 25,
    );
    $form['realm']['character'] = array(
        '#type' => 'fieldset',
        '#title' => t('WOW Game Server first realm'),
    );
    $form['realm']['character']['character_db'] = array(
        '#type' => 'textfield',
        '#title' => t('Enter the name of the CHARACTER database'),
        '#default_value' => $form_state['values']['character_db'],
        '#size' => 25,
    );
    $form['realm']['character']['character_username'] = array(
        '#type' => 'textfield',
        '#title' => t('Enter the username for the CHARACTER database'),
        '#default_value' => $form_state['values']['character_username'],
        '#size' => 25,
    );
    $form['realm']['character']['character_password'] = array(
        '#type' => 'textfield',
        '#title' => t('Enter the password for the CHARACTER database'),
        '#default_value' => $form_state['values']['character_password'],
        '#size' => 25,
    );
    $form['realm']['world']['world_db'] = array(
        '#type' => 'textfield',
        '#title' => t('Enter the name of the WORLD database'),
        '#defaule_value' => $form_state['values']['world_db'],
        '#size' => 25,
    );
    $form['realm']['world']['world_username'] = array(
        '#type' => 'textfield',
        '#title' => t('Enter the username for the WORLD database'),
        '#defaule_value' => $form_state['values']['world_username'],
        '#size' => 25,
    );
    $form['realm']['world']['world_password'] = array(
        '#type' => 'textfield',
        '#title' => t('Enter the password for the WORLD database'),
        '#defaule_value' => $form_state['values']['world_password'],
        '#size' => 25,
    );
    if (isset($form_state['storage']['new_name'])) {
        $form['character2'] = array(
            '#type' => 'fieldset',
            '#title' => t('WOW Game Server CHARACTER database setup for realm2'),
        );
        $form['character2']['character_db2'] = array(
            '#type' => 'textfield',
            '#title' => t('Enter the name of the CHARACTER database for relam2'),
            '#default_value' => $form_state['values']['character_db2'],
            '#size' => 25,
        );
        $form['character2']['character_username2'] = array(
            '#type' => 'textfield',
            '#title' => t('Enter the username for the CHARACTER database for realm2'),
            '#default_value' => $form_state['values']['character_username2'],
            '#size' => 25,
        );
    $form['character2']['character_password2'] = array(
        '#type' => 'textfield',
        '#title' => t('Enter the password for the CHARACTER database for realm2'),
        '#default_value' => $form_state['values']['character_password2'],
        '#size' => 25,
    );
    $form['world2'] = array(
        '#type' => 'fieldset',
        '#title' => t('WOW ame Server WORLD database setup for realm2'),
    );
        $form['world2']['world_db2'] = array(
        '#type' => 'textfield',
        '#title' => t('Enter the name of the WORLD database for realm2'),
        '#defaule_value' => $form_state['values']['world_db2'],
        '#size' => 25,
    );
    $form['world2']['world_username2'] = array(
        '#type' => 'textfield',
        '#title' => t('Enter the username for the WORLD database for realm2'),
        '#defaule_value' => $form_state['values']['world_username2'],
        '#size' => 25,
    );
    $form['world2']['world_password2'] = array(
        '#type' => 'textfield',
        '#title' => t('Enter the password for the WORLD database for realm2'),
        '#defaule_value' => $form_state['values']['world_password2'],
        '#size' => 25,
    );
    }
    $form['submit'] = array(
        '#type' => 'submit',
        '#value' => 'Submit',
    );
    $form['clear'] = array(
        '#type' => 'submit',
        '#value' => 'Reset',
        '#validate' => array('wowcp_form_clear'),
    );
    if (empty($form_state['storage']['new_name'])) {
        $form['new_name'] = array(
            '#type' => 'submit',
            '#value' => 'Add Realm',
            '#validate' => array('wowcp_form_new_name'),
        );
        $form['delete'] = array(
            '#type' => 'submit',
            '#value' => 'Delete Realm',
            '#validate' => array('wowcp_form_delete'),
        );
    }
    return $form;
}

If max_realms is set to a large number the way I see it you would have to hard code everything into the php file. Instead of that could you not remove from the if(isset) and have it that when they click on the add realm button check to make sure the textfield contains a number if it doesn't return an error if it does contain a number make sure it is not greater then max_realms and then use a start count and adding that number to all the arrays for that realm and validate all the information is what you expect. I think this would work for adding realms, I think where the problem would come in is in deleting realms (or it could be me over thinking it). For example if you have max_realms set to 4 you could have 5 the one default one that can't be deleted plus 4 others and the ones that can be deleted would be called realm1 - realm4 if you delete the first 2 you would minus count by 2 so if you clicked add realm again it would try and create realm3 which already exists. Is there another way on doing this that you could create the realms and delete them and it not try to add realms with the same array name?

Hi guys,

I've been working on a script for a while now,
and I'm sure it doesn't look great and all, and it's probably really messed up..
But right now I've finally got it working!
There's only 1 thing I'd really like to add..
Searching through & listing of remote directories!
The directories I'm trying to list have directory listings enabled,
and I think it *should* be possible.
I just have no clue how.

Here's my current code in a beautiful mix of HTML and PHP:


<?
$border_size = "0";

function returner($what) {
$what=explode("/",$what);
$tps=count($what);
$what=$what[$tps-1];
return $what;
}

$page_url= "";
$home_url=returner(__FILE__);
if(isset($_GET['q'])) {
$qtext=$_GET['q'];
} else {
$qtext="";
}
function getdirsize($directory, $format=FALSE) {
$size = 0;
if(substr($directory,-1) == '/') {
$directory = substr($directory,0,-1);
}
if(!file_exists($directory) || !is_dir($directory) || !is_readable($directory)) {
return -1;
}
if($handle = opendir($directory)) {
while(($file = readdir($handle)) !== false) {
$path = $directory.'/'.$file;
if($file != '.' && $file != '..') {
if(is_file($path)) {
$size += filesize($path);
}
elseif(is_dir($path)) {
$handlesize = getdirsize($path);
if($handlesize >= 0) {
$size += $handlesize;
} else {
return -1;
}
}
}
}
closedir($handle);
}
if($format == TRUE) {
if($size / 1048576 > 1) {
return round($size / 1048576, 1).' MB';
}
elseif($size / 1024 > 1) {
return round($size / 1024, 1).' KB';
} else {
return round($size, 1).' bytes';
}
} else {
return $size;
}
}

if(isset($_GET['type'])){
  $type=$_GET['type'];
} else {
  $type="new";
}

$textures=0;
$models=0;
$avatars=0;
$seqs=0;
$sounds=0;

foreach (glob("textures/*.jpg") as $texture){
$textures++;
}
foreach (glob("models/*.zip") as $model){
$models++;
}
foreach (glob("avatars/*.zip") as $avatar){
$avatars++;
}
foreach (glob("seqs/*.zip") as $seq){
$seqs++;
}
foreach (glob("sounds/*.zip") as $sound){
$sounds++;
}
?>
<!DOCTYPE html>
<html>
<head>
<title>ObjectPath Search</title>
<style type="text/css">
#wrapper {
width: 850px;
margin: 30px auto 30px auto;
padding: 10px;
}

body 
{
color:#C6C6C6;
background:#1E1E1E;
/* margin:0; padding:0; */
overflow-x:hidden;
}

#tabs {
font: 85% "Trebuchet MS", sans-serif;
}

.left {
float: left;
}

.right {
float: right;
}

a:link, a:visited, a:active {
color: #3DB015;
text-decoration: none;
}

a:hover {
color: #00E0FF;
}

h2 {
color: #3DB015;
padding-bottom: 0.2em;
font-size: 110%;
}
ul#icon {margin: 0; padding: 0;}
ul#icon li {margin: 1px; position: relative; padding: 1px 0; cursor: pointer; float: left;  list-style: none;}
ul#icon span.ui-icon {float: left; margin: 0 1px;}
</style>
<link type="text/css" href="http://objects.jk-hosting.com/search/css/black-tie/jquery-ui-1.8.2.custom.css" rel="stylesheet" />
<script type="text/javascript" src="http://objects.jk-hosting.com/search/js/jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="http://objects.jk-hosting.com/search/js/jquery-ui-1.8.2.custom.min.js"></script>
<script type="text/javascript">
function formHandler(form){
var URL = document.form.site.options[document.form.site.selectedIndex].value;
window.location.href = URL;
};

$(function(){
// Tabs
$('#tabs').tabs();
});
</script>
</head>
<body>
<div id="wrapper">
<div id="tabs"> <!-- Tabs start -->
<ul>
<li><a href="#tab-search">Search</a></li>
<li><a href="#tab-list">List Objects</a></li>
<li><a href="#tab-info">OP info</a></li>
</ul>

<div id="tab-search"><!-- Searchtab start -->
Please enter a string to search for, and choose a folder to search in. <br /><br />
<form name="Search">
<input type='hidden' value='search' name='type'>
<input value='<? print $qtext; ?>' type='text' name='q'> 
<select name='map'>
<option selected='selected' value='models'>Models</option>
<option value='avatars'>Avatars</option>
<option value='textures'>Textures</option>
<option value='seqs'>Seqs</option>
<option value='sounds'>Sounds</option></select> <input type='submit' value='Search'>
</form>
</div> <!-- Searchtab end -->

<div id="tab-list"><!-- Listtab start -->
Please pick a folder to browse. <br /><br />
<form name="form">
<select name="site" onChange="javascript:formHandler()">
<option value="#">Look in folder...</option>
<option value="<? print $page_url; ?>?type=list&map=models">Models</option>
<option value="<? print $page_url; ?>?type=list&map=avatars">Avatars</option>
<option value="<? print $page_url; ?>?type=list&map=textures">Textures</option>
<option value="<? print $page_url; ?>?type=list&map=seqs">Seqs</option>
<option value="<? print $page_url; ?>?type=list&map=sounds">Sounds</option>
</select>
</form>
</div> <!-- Listtab end -->

<div id="tab-info"><!-- Info tab start -->  
The OP currently contains: <br /><br />
<table>
<tr><td><b><? echo $models; ?></b></td> <td>Models</td></tr>
<tr><td><b><? echo $avatars; ?></b></td> <td>Avatars</td></tr>
<tr><td><b><? echo $textures; ?></b></td> <td>Textures</td></tr>
<tr><td><b><? echo $seqs; ?></b></td> <td>Seqs</td></tr>
<tr><td><b><? echo $sounds; ?></b></td> <td>Sounds</td></tr>
</table>
</div> <!-- Info tab end -->
</div> <!-- Tabs end -->
</div>

<!-- Start PHP generated content -->

<?
if($type=="search" || $type=="list") {
$M=$_GET['map'];
if($type=="search") {
$Q=$_GET['q'];
$empty="Nothing found with <b>\"" . $Q . "\"</b> in it's name.<br />\nPlease make a more general search query, or try a different folder.\n\n";
} else {
$Q="";
$empty='This folder is empty';
}
if($M=="textures") {
$ext="jpg";
} else {
$ext="zip";
}
$i=0;
print "<hr>\n";
$endfile=array();
$endsize=array();
$endsize2=array();
    foreach (glob($M."/*".$Q."*.".$ext) as $filename) {
$filename = explode(".", $filename);
$filename=$filename[0];
$filename = explode("/", $filename);
$filename=$filename[1];
$i++;
$endfile[$i]=$filename;
if($ext=="jpg") {
$endfile[$i]="<a name='".$endfile[$i]."' href='".$pageurl."?type=view&name=".$endfile[$i]."&folder=".$M."&from=".$type."&addon=".$Q."'>".$endfile[$i]."</a>";
}
$endsize[$i]=$size;
$endsize2[$i]=$size2;
}
if($i != 1) {
print "<b>".$i."</b> items were found.\n<hr>\n";
} else {
print "<b>".$i."</b> item was found.\n<hr>\n";
}
    echo("<table width='100%' border='" . $border_size . "' cellspacing='0' cellpadding='0' >\n");
if($i!=0) {
for ($t = 1; $t < $i; $t++) {
$thumbfile = $M."/".$endfile[$t].'.jpg';
if(file_exists($thumbfile)) {
$thumbnail = "<a name='".$endfile[$t]."' href='".$page_url."?type=view&name=".$endfile[$t]."&folder=".$M."&from=".$type."&addon=".$Q."'><ul id='icon'><li class='ui-state-default ui-corner-all' title='".$endfile[$t]."'><span class='ui-icon ui-icon-image'></span></li></ul></a>";
} else {
$thumbnail = "";
}
if($t=="1") {
echo("<tr><td width='10%'>Number</td><td width='3%'><ul id='icon'><li class='ui-state-default ui-corner-all' title='".$endfile[$t]."'><span class='ui-icon ui-icon-image'></span></li></ul></td><td width='60%'>Name</td></tr>\n");
}
echo("<tr><td>" . $t . "</td><td>".$thumbnail."</td><td>" . $endfile[$t] . "</td></tr>\n");
flush();
}
$thumbfile = $M."/".$endfile[$t].'.jpg';
if(file_exists($thumbfile)) {
$thumbnail = "<a name='".$endfile[$t]."' href='".$page_url."?type=view&name=".$endfile[$t]."&folder=".$M."&from=".$type."&addon=".$Q."'><ul id='icon'><li class='ui-state-default ui-corner-all' title='".$endfile[$t]."'><span class='ui-icon ui-icon-image'></span></li></ul></a>";
} else {
$thumbnail = "";
}
echo("<tr><td>" . $t . "</td><td>".$thumbnail."</td><td>" . $endfile[$t] . "</td></tr>\n");
}
print "</table>\n";     
if($i=="0") {
print $empty;
}
} elseif($type=="view") {
$filename=$_GET['name'];
$folder=$_GET['folder'];
  
if($_GET['from']=="list"){
$addon="?type=list&map=".$folder."#".$filename;
}

if($_GET['from']=="search"){
$addon="?type=search&q=".$filename."&map=".$folder."#".$filename;
}
print"<center><a href='".$home_url."'>Home</a></center>";
print "<hr>\n<center><img src='".$folder."/".$filename.".jpg'></img></center>\n<hr>\n<br />\n<a href='".$page_url."".$addon."'>Previous Page</a>\n";
}
$htmlshow="";
if($_GET['type']=="returnOPfile") {
if(isset($_GET['split'])) {
$splitter=$_GET['split'];
} else {
$splitter=" | ";
}
if(isset($_GET['html'])) {
$htmlshow="<br />";
}
foreach (glob("textures/*.jpg") as $texture){
if(isset($_GET['size'])) {
$size=$splitter.filesize($texture);
}
    $texture = explode("/", $texture);
$texture=$texture[1];
print "textures".$splitter.$texture.$size."\n".$htmlshow;
}
  
foreach (glob("models/*.zip") as $model){
if(isset($_GET['size'])) {
$size=$splitter.filesize($model);
}
    $model = explode("/", $model);
$model=$model[1];
print "models".$splitter.$model.$size."\n".$htmlshow;
}
  
foreach (glob("avatars/*.zip") as $avatar){
if(isset($_GET['size'])) {
$size=$splitter.filesize($avatar);
}
    $avatar = explode("/", $avatar);
$avatar=$avatar[1];
print "avatars".$splitter.$avatar.$size."\n".$htmlshow;
}
  
foreach (glob("seqs/*.zip") as $seq){
if(isset($_GET['size'])) {
$size=$splitter.filesize($seq);
}
    $seq = explode("/", $seq);
$seq=$seq[1];
print "seqs".$splitter.$seq.$size."\n".$htmlshow;
}
    foreach (glob("sounds/*.zip") as $sound){
if(isset($_GET['size'])) {
$size=$splitter.filesize($sound);
}
      $sound = explode("/", $sound);
$sound=$sound[1];
print "sounds".$splitter.$sound.$size."\n".$htmlshow;
}
}
?>

<!-- End PHP generated content -->

</body>
</html>


So right now my question to you PHP freaks is,
can you please help me edit my script so I can search through a remote directory?

*This* is one of the directories I wish to be able to search through & list..

Thanks in advance. 

Edit;
It might help if you know what the site currently looks like.
*Click*

Greetings Fellow PHPFreaks! 

LovableCodeMan here - newbie to this forum an pretty new to this PHP thing that all these youngsters are raving about - who knew?! 

Anyway, so I have an HTML form set up with a PHP document attached in order to send the data from the form to an email -a pretty basic setup by todays standards. 

In the PHP document, you can see that there is a section for the user (sender@xyz.com) to submit the information in the form to us & is sent to our email address "receiver@xyz.com". The bottom segment is to send a confirmation email back to the sender - to "sender@xyz.com" - as a thank you and a "We will get back to you ASAP" etc etc etc. 

The confirmation email sent to the sender@xyz.com works flawlessly when pressing the "Send Your Message" button, but then I just see "https://www.xyz.com/scripts/mail.php" in the address bar and no email is received by receiver@xyz.com - aka "Us".

This is the PHP document - confidential information redacted & the "sender@xyz.com" & "receiver@xyz.com" replace the real email addresses.

<!doctype html>
<?php
    
    $title = $_POST['title'];
	$first = $_POST['first'];
	$surname = $_POST['surname'];
	$email = $_POST['email']; <!------- sender@xyz.com--->
	$internationalCode = $_POST['internationalCode'];
    $number = $_POST['number'];
    $userMessage = $_POST['userMessage'];
	$company = $_POST['company'];
	$Industrytype = $_POST['Industrytype'];
	$inc_status = $_POST['inc_status'];
	$state = ['state'];
    
	$email_from = "$first $surname <smtp server login>";

    $Password = 'smtp server password';

    $email_subject = "Website Enquiry from $first $surname";

	$messageTo = "receiver@xyz.com";

    $email_body = 
    "User title: $title. \n".
    "The department this message is for is: $department.\n".
    "User First Name: $first.\n".
    "User Surname Name: $surname. \n".
    "User email: $email.\n".
	"International Dialing Code: $internationalCode. \n".
    "User Contact Number: $number.\n".
	"State of Incorporation: $state.\n".
	"File: $attachment.\n".
	"Company Name: $company, $inc_status.\n".
	"Industry type: $Industrytype.\n".
    "User Message is: $userMessage.\n";

    $headers = "From: $email_from" . "\r\n" . "Reply to: $first $surname". "\r\n";

    mail($messageTo, $email_subject, $email_body, $headers, "-fweb_support@xyz.com");

    header('Location: https://www.xyz.com/thank_you.html');


<!--------Confirmation email send to sender@xyz.com below---------------->


	$respond_subject = "Thank you for your message";

		/* Prepare autoresponder message */
		$respond_message = "
Hi $first,

Thank you for messaging to us. We will aim to reply to you within 24 hours.

In the meantime, why not follow our other stories via, as well as following, our Facebook page. Simply go to https://www.facebook.com/xyz/ 

Yours sincerely,

The Support Team
receiver@xyz.com.
		";

		$headers = 'From: <Sender> <no-reply@xyz.com>' . "\r\n" .
			'Reply-To: $email' . "\r\n" .<!------- sender@xyz.com--->
			'X-Mailer: PHP/' . phpversion();

		/* Send the message using mail() function */
		mail($email, $respond_subject, $respond_message, $headers, "-fno-reply@xyz.com");
//}
?>

 

This is the HTML document:

 

<!doctype html>
<html>
  <head>
  	<meta name="viewport" content="width=device-width, initial-scale=1">
	<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
	<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>
  </head>
  <body>
  	<form role="form-inline" method="POST" action="../scripts/mail.php">
				<div class="form-group">
					<div class="row">
						<div class="col-lg-2 col-md-4 col-sm-4 col-xs-4 select ">
						  	<select class="" id="standard-select" name="title">
								<option selected disabled>Title *</option>
								<option>Dr.</option>
								<option>Mr.</option>
								<option>Mrs.</option>
								<option>Ms.</option>
								<option>Prof.</option>
								<option>Rev.</option>
								<option>Pastor.</option>
								<option>Miss.</option>
							</select>
						</div>
						<div class="col-lg-4 col-md-4 col-sm-8 col-xs-8">
						  	<input name="first" type="text" placeholder="First Name *" required/>
						</div>
						<div class="col-lg-6 col-md-4">
						  	<input name="surname" type="text" placeholder="Surname *" required/>
						</div>
					</div>
					<div class="row">
						<div class="col-lg-6 col-md-4 col-sm-6 col-xs-12">
						  <input name="email" type="email" placeholder="Email *" required/>
						</div>
						<label for="standard-select"></label>
						<div class="col-lg-2 col-md-4 col-sm-6 col-xs-5 select">
						  	<select class="" name="internationalCode" id="">
							<option data-countryCode="GB" value="44" Selected>UK (+44)</option>
							<option data-countryCode="US" value="1" >USA (+1)</option>
							<optgroup label="Other countries">
								<option data-countryCode="DZ" value="213">Algeria (+213)</option>
								<option data-countryCode="AD" value="376">Andorra (+376)</option>
								<option data-countryCode="AO" value="244">Angola (+244)</option>
								<option data-countryCode="AI" value="1264">Anguilla (+1264)</option>
								<option data-countryCode="AG" value="1268">Antigua &amp; Barbuda (+1268)</option>
								<option data-countryCode="AR" value="54">Argentina (+54)</option>
								<option data-countryCode="AM" value="374">Armenia (+374)</option>
							</optgroup>
							</select>
						</div>
						<div class="col-lg-4 col-md-4 col-sm-12 col-xs-7">
						  <input type="tel" name="number" placeholder="Telephone Number *" required/>
						</div>
					</div>
					<div class="row">
						<div class="col-lg-6 col-md-6 col-sm-6 col-xs-12 select">
							<select name="inc_status" required>
								<option selected disabled>Incorporation status *</option>
								<option>Limited by Guarantee</option>
								<option>Limited by Shares</option>
								<option>CIC</option>
								<option>CIO</option>
								<option>Unincorporated</option>
								<option>LLP</option>
								<option>LLC</option>
								<option>Other</option>
							</select>
						</div>
						<div class="col-lg-6 col-md-6 col-sm-6 col-xs-12 select">
							<select name="state" disabled>
								<option selected disabled>State of incorporation *</option>
									<option value="AL">Alabama</option>
									<option value="AK">Alaska</option>
									<option value="AZ">Arizona</option>
									<option value="AR">Arkansas</option>
									<option value="CA">California</option>
									<option value="CO">Colorado</option>
									<option value="CT">Connecticut</option>
									<option value="DE">Delaware</option>
									<option value="DC">District Of Columbia</option>
									<option value="FL">Florida</option>
							</select>
						</div>
					</div>
					<div class="row">
						<div class="col-xs-12 col-sm-12 col-md-6 col-lg-6">
							<input name="company" type="text" placeholder="Company *" required/>
						</div>
						<div class="col-xs-12 col-sm-12 col-md-6 col-lg-6 select">
							<select class="" name="Industrytype" id="select" value="">
								<option selected disabled value="">Industry *</option>
								<option value="Appraisal/Disposition">Appraisal/Disposition</option>
								<option value="Business Services">Business Services</option>
								<option value="Consulting">Consulting</option>
								<option value="Business Broker">Business Broker</option>
								<option value="Distribution">Distribution</option>
								<option value="Education">Education</option>
								<option value="Financial Services (Non-Lender)">Financial Services (Non-Lender)</option>
								<option value="Government">Government</option>
								<option value="Healthcare">Healthcare</option>
								<option value="Insurance">Insurance</option>
								<option value="Investment Banking">Investment Banking</option>
								<option value="Law">Law</option>
								<option value="Lender">Lender</option>
								<option value="Logistics">Logistics</option>
								<option value="Manufacturing">Manufacturing</option>
								<option value="Media/Print/Broadcast/Internet">Media/Print/Broadcast/Internet</option>
								<option value="Other">Other</option>
								<option value="Private Equity/Venture Capital">Private Equity/Venture Capital</option>
								<option value="Real Estate Services">Real Estate Services</option>
								<option value="Receivables">Receivables</option>
								<option value="Retail">Retail</option>
								<option value="Technology">Technology</option>
								<option value="Turnaround/Restructuring">Turnaround/Restructuring</option>
								<option value="Utility">Utility</option>
								<option value="Wholesale">Wholesale</option>
						</select>
						</div>
					</div>
					<div class="row">
						<div class="col-lg-12">
							<textarea name="userMessage" placeholder="Please type your message here. Do not include any personal information such as your NIN or any banking information."></textarea>
						</div>
					</div>
					<div class="row">
						<div class="col-lg-6 col-md-12 col-sm-12 col-xs-12">
							<div class="" style="background-color: #E0DDDD; padding: 20px;">
                                 <p style="font-size: 12px; color: #0d0155">Information is held under the provision of the General Data Protection Regulation (GDPR). We will not pass your details on to any other organisation. We will process your information in accordance with our privacy policy. By send this message, you agree to xxxxxxx's <a style="color: #0D0155; text-decoration: underline;" href="/privacy/online_privacy_notice.html" target="_new" class="inline_link__new_window">Online Privacy Policy</a>
                              </p>
							</div>
						</div>
						<div class="col-lg-6 col-md-12 col-sm-12 col-xs-12">
							<input type="submit" id="submit" name="submit" value="Send your message"/>
						</div>
					</div>
				</div>	
			</form>
  </body>
</html>

Anyone know where I'm going wrong, it "half works" so I'm Half Way There - & yes, I am Livin' on a Prayer! 

Thanks in advance! 

The LovableCodeman

Hi all.
Here is my scripts which allow user to check multiple rows of data and delete it , but it require select data and click for twice to delete the rows , what should be the error?

Code: [Select]
<form name="frmSearch" method="post" action="insert-add.php">

<table width="600" border="1">
  <tr>
    <th width="50"> <div align="center">#</div></th>
    <th width="91"> <div align="center">ID </div></th>
    <th width="198"> <div align="center">First Name </div></th>
    <th width="198"> <div align="center">Last Name </div></th>
    <th width="250"> <div align="center">Mobile Company </div></th>
    <th width="100"> <div align="center">Cell </div></th>
    <th width="100"> <div align="center">Workphone </div></th>
    <th width="100"> <div align="center">Group </div></th>
  </tr>
    </form>
<?

    echo "<form name='form1' method='post' action=''>";

while($objResult = mysql_fetch_array($objQuery))
{


    echo "<tr>";
    echo "<td align='center'><input name=\"checkbox[]\" type=\"checkbox\" id=\"checkbox[]\" value=\"$objResult[addedrec_ID]\"></td>";
    echo "<td>$objResult[addedrec_ID] </td>";
    echo "<td>$objResult[FirstName]</td>";
    echo "<td>$objResult[LastName] </td>";
    echo "<td>$objResult[MobileCompany] </td>";
    echo "<td>$objResult[Cell] </td>";
    echo "<td>$objResult[WorkPhone] </td>";
    echo "<td>$objResult[Custgroup] </td>";

   echo "</tr>";

}


 echo "<td colspan='7' align='center'><input name=\"delete\" type=\"submit\" id=\"delete\" value=\"Delete\">";

 if (isset($_POST['delete']) && isset($_POST['checkbox'])) // from button name="delete"
 {
 $checkbox = ($_POST['checkbox']); //from name="checkbox[]"
     $countCheck = count($_POST['checkbox']);

 for($d=0;$d<$countCheck;$d++)
     {
         $del_id  = $checkbox[$d];

 $sql = "DELETE from UserAddedRecord where addedrec_ID = $del_id";

 $result2=mysql_query($sql)  or trigger_error(mysql_error());;;

     }
         if($result2)
     { 
          $fgmembersite->GetSelfScript();
         }
         else
         {
 echo "Error: ".mysql_error();
         }
 }
  echo "</form>";


Thanks for every reply.

 <body>
 
 
  <?php
    

 
       include 'sql.php';
       $query = "SELECT * FROM validation";
       $result = mysqli_query($con , $query);  
       $rows = mysqli_fetch_assoc($result) ;
       $totals = mysqli_num_rows($result) ;
   
      
      
          ?>
            <div id="css">
    <form >
       <table width="80%" border="0" cellpadding="2" cellspacing="2" >
          <caption><h2>Personal Details of Customers</h2></caption>
          <tr class="white">
              <td bgcolor="#330033"> &nbsp; </td>
              <td bgcolor="#330033"> Id Number </td>
              <td bgcolor="#330033"> Full Name </td>
              <td bgcolor="#330033"> Email Address </td>
              <td bgcolor="#330033"> Website </td>
              <td bgcolor="#330033"> Comment </td>
              <td bgcolor="#330033"> Time </td>   
     
</tr>
       <?php while($rows=mysqli_fetch_assoc($result)
       {
       <tr>
      
      <input type="raido" name="ID" value="<?php echo $rows['ID']; ?>"  />
      <td bgcolor="#FFFFCC"><?php  echo $rows['ID'];?></td>
      <td bgcolor="#FFFFCC"><?php  echo $rows['Name'];?> </td>
      <td bgcolor="#FFFFCC"><?php  echo $rows['Email'];?></td>
      <td bgcolor="#FFFFCC"><?php  echo  $rows['Website'];?></td>
      <td bgcolor="#FFFFCC"><?php  echo $rows['Comment'];?></td>
      <td bgcolor="#FFFFCC"><?php  echo $rows['Time'];?></td>  
      
       <td>&nbsp;</td>
     
       <td> <a href="delete.php? ID= "$rows[ID]" /"> <input type="submit" name="del" value="Delete" /> </a> &nbsp;                                                     <input type="button" name=   "edit" value="Edit"  /> </td>
       </tr>
              } 

?>
 
     </table>
   </form>
  </div>
 
 </body>

Hi,   I wish to find out is there any possible that I can delete some data inside my php website but inside my sql database, the record will still at there?   Thank you.