PHP - Multi Uplad Form

Hi,

I'm having problems retrieving the values from a form posting without getting a warning

My form records playername, hours played and minutes played

Code: [Select]
<li id="input1" style="margin-bottom:4px;" class="clonedInput">
Name:
        <select name="player[1][userid]" id="player[1][userid]" class="playerInput" style="width: 7em;" >
        <option value=""></option>
        <?php
while($row = mysql_fetch_array($sql)) {
echo '<option value="'.stripslashes($row['userid']).'">'.stripslashes($row['name']).'</option>';
}
mysql_data_seek($sql,0);
?>
        </select>       
        <select name="player[1][hours]" id="player[1][hours]">
        <option value="">Hours</option>
        <option value=""></option>
        <?php
for($x = 0; $x <= 23; $x++ ) {
             echo '<option value="'.$x.'">'.$x.'</option>';
}
?>
        </select>
        <select name="player[1][minutes]" id="player[1][minutes]">
        <option value="">Minutes</option>
        <option value=""></option>
        <?php
for($y = 15;  $y <= 59; $y+=15) {
             echo '<option value="'.$y.'">'.$y.'</option>';
}
?>
        </select>
</li>

I use some javascript to create new players as necessary so every player has a userid, hours, minutes played...
After posting the query string looks like this

/cLeagueHandler.php?player[1][userid]=1&player[1][hours]=3&player[1][minutes]=15&player[2][userid]=3&player[2][hours]=6&player[2][minutes]=45&submit=Save+Points

player1
userid = 1
hours = 3
minutes = 15

player2.......

The code i'm using to access the values is

Code: [Select]
        print_r ($_GET); // test display form values
       
foreach ($_GET as $key => $value) {
echo '<br/>'.$key.'<br/> ';
foreach ($value as $iKey => $iValue) { // Line 72
foreach ($iValue as $xKey => $xValue) {
echo " The $xKey for Player $iValue is $xValue <br/>";
}
}
}

The above code displays

Array ( [player] => Array ( [1] => Array ( [userid] => 1 [hours] => 3 [minutes] => 15 ) [2] => Array ( [userid] => 3 [hours] => 6 [minutes] => 45 ) ) [submit] => Save Points )
player
The userid for Player Array is 1
The hours for Player Array is 3
The minutes for Player Array is 15
The userid for Player Array is 3
The hours for Player Array is 6
The minutes for Player Array is 45

submit

Warning: Invalid argument supplied for foreach() in .................cLeagueHandler.php on line 72

Line 72 is foreach ($value as $iKey => $iValue) {

If anyone could help me with this it would be great appreciated.......I want to be able to build and sql string to Insert a players id, hours, minutes into a database......(obviously not incl the submit value!)
Maybe this is not even the best way of approaching this.....I'm quiet new to PHP so apologies if this is long winded...I'm trying to give as much info as possible....

thanks in advance

tmfl

hi all

i have a problem here,

Iv got a form  that uploads images to a folder and updates the db with the name of that image, that work ok

but if one of the upload field are left blank then the script updates the db with empty values
how can i get it to only update the db with only submitted form field data????

here is the form
Code: [Select]
<?php

if (isset($_GET['id'])) {
$id = $_GET['id'];
}

?>

<form action="ud_image.php?id=<? echo "$id"?>" method="post" enctype="multipart/form-data" name="form1" id="form1">
<table class="udp">
  <tr>
    <th>Thumbnail:</th>
    <td><input type="hidden" name="MAX_FILE_SIZE" value="1029120" />
<input name="ufile[]" type="file" id="ufile[]" size="50" /></td>
</tr>
  <tr>
    <th>Image 1:</th>
    <td><input type="hidden" name="MAX_FILE_SIZE" value="1029120" />
<input name="ufile[]" type="file" id="ufile[]" size="50" /></td>
  </tr>
  <tr>
    <th>Image 2:</th>
    <td><input type="hidden" name="MAX_FILE_SIZE" value="1029120" />
<input name="ufile[]" type="file" id="ufile[]" size="50" /></td>
  </tr>
  <tr>
    <th>Image 3:</th>
    <td><input type="hidden" name="MAX_FILE_SIZE" value="1029120" />
<input name="ufile[]" type="file" id="ufile[]" size="50" /></td>
  </tr>
  <tr>
    <th>Image 4:</th>
    <td><input type="hidden" name="MAX_FILE_SIZE" value="1029120" />
<input name="ufile[]" type="file" id="ufile[]" size="50" /><input type="submit" name="Submit" value="Upload" /></td>
  </tr>
</table>
</form>



and here is the

processing page


<?php
include("protect/password_protect.php");

error_reporting(E_ALL);

include ("../includes/db_config.php");

$con = mysql_connect($db_hostname,$db_username,$db_password);
@mysql_select_db($db_database) or die( "Unable to select database");


$path1= "../thumbnails/".$_FILES['ufile']['name'][0];
$path2= "../images/".$_FILES['ufile']['name'][1];
$path3= "../images/".$_FILES['ufile']['name'][2];
$path4= "../images/".$_FILES['ufile']['name'][3];
$path5= "../images/".$_FILES['ufile']['name'][4];

//copy file to where you want to store file
copy($_FILES['ufile']['tmp_name'][0], $path1);
copy($_FILES['ufile']['tmp_name'][1], $path2);
copy($_FILES['ufile']['tmp_name'][2], $path3);
copy($_FILES['ufile']['tmp_name'][3], $path4);
copy($_FILES['ufile']['tmp_name'][4], $path5);
?>

<html>

<head>
<title>Update Project Images</title>
<link rel="stylesheet" type="text/css" href="../../project/backend/style.css" />
</head>
<body>
<table class="udip">
  <tr>
    <th><? echo "<img src=\"$path1\" width=\"150\" height=\"150\">";?></th>
    <th><? echo "<img src=\"$path2\" width=\"150\" height=\"150\">";?></th>
    <th><? echo "<img src=\"$path3\" width=\"150\" height=\"150\">";?></th>
    <th><? echo "<img src=\"$path4\" width=\"150\" height=\"150\">";?></th>
    <th><? echo "<img src=\"$path5\" width=\"150\" height=\"150\">";?></th>
  </tr>
  <tr>
    <td><? echo "File Name :".$_FILES['ufile']['name'][0]."<BR/>";?></td>
    <td><? echo "File Name :".$_FILES['ufile']['name'][1]."<BR/>";?></td>
    <td><? echo "File Name :".$_FILES['ufile']['name'][2]."<BR/>";?></td>
    <td><? echo "File Name :".$_FILES['ufile']['name'][3]."<BR/>";?></td>
    <td><? echo "File Name :".$_FILES['ufile']['name'][4]."<BR/>";?></td>
  </tr>
  <tr>
    <td><?echo "File Size :".$_FILES['ufile']['size'][0]."<BR/>";?></td>
    <td><?echo "File Size :".$_FILES['ufile']['size'][1]."<BR/>";?></td>
    <td><?echo "File Size :".$_FILES['ufile']['size'][2]."<BR/>";?></td>
    <td><?echo "File Size :".$_FILES['ufile']['size'][3]."<BR/>";?></td>
    <td><?echo "File Size :".$_FILES['ufile']['size'][4]."<BR/>";?></td>
  </tr>
  <tr>
    <td><? echo "File Type :".$_FILES['ufile']['type'][0]."<BR/>";?></td>
    <td><? echo "File Type :".$_FILES['ufile']['type'][1]."<BR/>";?></td>
    <td><? echo "File Type :".$_FILES['ufile']['type'][2]."<BR/>";?></td>
    <td><? echo "File Type :".$_FILES['ufile']['type'][3]."<BR/>";?></td>
    <td><? echo "File Type :".$_FILES['ufile']['type'][4]."<BR/>";?></td>
  </tr>
</table>
</body>
</html>
<?
$filesize1=$_FILES['ufile']['size'][0];
$filesize2=$_FILES['ufile']['size'][1];
$filesize3=$_FILES['ufile']['size'][2];
$filesize4=$_FILES['ufile']['size'][3];
$filesize5=$_FILES['ufile']['size'][4];

if($filesize1 && $filesize2 && $filesize3 && $filesize4 && $filesize5 != 0)

{
echo "We have recieved your files<p>";
}

else {
echo "Error in you images check and try again Database has been updated to blank images so no images will be shown on details page.";
}


$query = "UPDATE $db_table SET 
thumbnail = '".$_FILES['ufile']['name'][0]."', image1 = '".$_FILES['ufile']['name'][1]."', image2 = '".$_FILES['ufile']['name'][2]."', image3 = '".$_FILES['ufile']['name'][3]."', image4 = '".$_FILES['ufile']['name'][4]."' WHERE id = '".$_GET['id']."'";


if (!mysql_query($query,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";

mysql_close($con)


?>

hello,  is there a way to insert something 17 times into a database and change the 3rd field one at a time (from 1-17)?

Code: [Select]
$sql = "INSERT INTO picks VALUES (
NULL,
'" . mysql_real_escape_string($userid) ."',
'" . mysql_real_escape_string($weekid) ."',
'" . mysql_real_escape_string($pickid) ."'
)";
  mysql_query($sql) or die('Error, Check you fields and try again.');

Hello friends,

I've tried to search over the Internet but didn't found any tutorial how to do the following :-

let say we have form with input username and input email just 2 field

HTML Code

Code: [Select]
<form>
<table>
<tr>
<td>Username :</td>
<td><input id="username" size="20" type="text" name="username"></td>
</tr>
<tr>
<td>Email :</td>
<td><input id="email" size="20" type="text" name="email"></td>
</tr>
</table>
</form>

As you can see no submit button cause we will only check out if username and/or email is not stored already, by using ajax

My problem : i can only check out for username (1 field) but i can not check for 2 fields or more and i want to know how to apply it for 2 fields (username and email)

Here is my idea for only one field (username)

I'll add in the HTML code  this

Code: [Select]
<td><div id="status"></div></td>
and will add this java code

Code: [Select]
<SCRIPT type="text/javascript">
pic1 = new Image(16, 16);
pic1.src = "loader.gif";
$(document).ready(function(){
$("#username").change(function() {
var usr = $("#username").val();
if(usr.length >= 4)
{
$("#status").html('<img src="loader.gif" align="absmiddle">&nbsp;Checking availability...');
$.ajax({
type: "POST",
url: "check.php",
data: "username="+ usr,
success: function(msg){
$("#status").ajaxComplete(function(event, request, settings){
if(msg == 'OK')
{
$("#username").removeClass('object_error');
$("#username").addClass("object_ok");
$(this).html('&nbsp;<img src="tick.gif" align="absmiddle">');
}
else
{
$("#username").removeClass('object_ok');
$("#username").addClass("object_error");
$(this).html(msg);
}
});
}
});
}
else
{
$("#status").html('<font color="red">The username should have at least <strong>4</strong> characters.</font>');
$("#username").removeClass('object_ok');
$("#username").addClass("object_error");
}
});
});
</SCRIPT>

Explain : it will get the input of username and will send it to check.php

Now check.php code (should have all usernames that will compare with it)

Code: [Select]
<?php
if(isSet($_POST['username']))
{
$usernames = array('john','michael','terry', 'steve', 'donald');
$username = $_POST['username'];
if(in_array($username, $usernames))
{
echo '<font color="red">The username<STRONG>'.$username.'</STRONG> is already in use.</font>';
}
else
{
echo 'OK';
}
}
?>

Now it is very clear , if will automatic check the username

now my problem is how to apply it for also email

Hi Chaps,

I'm trying to put together a Nested Set Model (Hierarchical Data), but I have having problems when it comes to deleting/updating the 'nested' table.

I'm using this as a guide:
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html

But when trying to run a query, such as:

SELECT @myLeft := lft, @myRight := rgt, @myWidth := rgt - lft + 1
FROM nested_category
WHERE name = 'GAME CONSOLES';

DELETE FROM nested_category WHERE lft BETWEEN @myLeft AND @myRight;

UPDATE nested_category SET rgt = rgt - @myWidth WHERE rgt > @myRight;
UPDATE nested_category SET lft = lft - @myWidth WHERE lft > @myRight;


I get a MySQL syntax error.

This code works fine in something such as Windows Command Prompt, but not in PHP.

Is there a special way to run multiple queries in 1 PHP script?

Many thanks

common.php
Code: [Select]

<?php
session_start();
header('Cache-control: private'); // IE 6 FIX

if(isSet($_GET['lang']))
{
$lang = $_GET['lang'];

// register the session and set the cookie
$_SESSION['lang'] = $lang;

setcookie("lang", $lang, time() + (3600 * 24 * 30));
}
else if(isSet($_SESSION['lang']))
{
$lang = $_SESSION['lang'];
}
else if(isSet($_COOKIE['lang']))
{
$lang = $_COOKIE['lang'];
}
else
{
$lang = 'en';
}

switch ($lang) {
  case 'en':
  $lang_file = 'lang.en.php';
  break;

  case 'de':
  $lang_file = 'lang.de.php';
  break;

  case 'el':
  $lang_file = 'lang.el.php';
  break;

  default:
  $lang_file = 'lang.en.php';

}

include_once 'languages/'.$lang_file;
?>
ip2locationlite.class.php
Code: [Select]
<?php
final class ip2location_lite{
protected $errors = array();
protected $service = 'api.ipinfodb.com';
protected $version = 'v3';
protected $apiKey = '';

public function __construct(){}

public function __destruct(){}

public function setKey($key){
if(!empty($key)) $this->apiKey = $key;
}

public function getError(){
return implode("\n", $this->errors);
}

public function getCountry($host){
return $this->getResult($host, 'ip-country');
}

public function getCity($host){
return $this->getResult($host, 'ip-city');
}

private function getResult($host, $name){
$ip = @gethostbyname($host);

if(preg_match('/^(?:25[0-5]|2[0-4]\d|1\d\d|[1-9]\d|\d)(?:[.](?:25[0-5]|2[0-4]\d|1\d\d|[1-9]\d|\d)){3}$/', $ip)){
$xml = @file_get_contents('http://' . $this->service . '/' . $this->version . '/' . $name . '/?key=' . $this->apiKey . '&ip=' . $ip . '&format=xml');

try{
$response = @new SimpleXMLElement($xml);

foreach($response as $field=>$value){
$result[(string)$field] = (string)$value;
}

return $result;
}
catch(Exception $e){
$this->errors[] = $e->getMessage();
return;
}
}

$this->errors[] = '"' . $host . '" is not a valid IP address or hostname.';
return;
}
}
?>



index.php

Code: [Select]
<?php
include_once('ip2locationlite.class.php');
 
//Set geolocation cookie
if(!$_COOKIE["geolocation"]){
  $ipLite = new ip2location_lite;
  $ipLite->setKey('*****************');
 
  $visitorGeolocation = $ipLite->getCountry($_SERVER['REMOTE_ADDR']);
  if ($visitorGeolocation['statusCode'] == 'OK') {
    $data = base64_encode(serialize($visitorGeolocation));
    setcookie("geolocation", $data, time()+3600*24*7); //set cookie for 1 week
  }
}else{
  $visitorGeolocation = unserialize(base64_decode($_COOKIE["geolocation"]));
}
var_dump($visitorGeolocation);
?>


im using this http://ipinfodb.com/

in index.php i got this message

array(5) { ["statusCode"]=> string(2) "OK" ["statusMessage"]=> string(0) "" ["ipAddress"]=> string(13) "94.68.211.211" ["countryCode"]=> string(2) "GR" ["countryName"]=> string(6) "GREECE" }

how to switch automatic if GR go to index.php?lang=el
if DE go to  index.php?lang=de etc...

Hi guys
I got an issue that when a link on the site is loading, the other links does not load until the previous is complete but it will work if i try on 2 different browsers. How can i browse multiple links silmultanously?
Thanks

hello all, i have been sitting here googleing and googling but i can't seem to find what im looking for.

i am tring to create a personal site that lets me note services i do for my cars. I have multiple tables (cars, color, mfg, ...) in the main table cars i insted of putting the color black i put and int(11) of 1 which is suppose to "if statement" to the table colors and produce the correct color. same for mfg. although nothing i have tried has helped i always just have the else of the if echoed out.

i have heard of union and join left right i am so unsure of what is need any insite would be useful.

thanks in advance.

How i can delete record from table `order` and move it to `order2` the table `order2` structure is exactly like table `order`.here is the code that i made. 

<?
	include("connection.php");
	$id_product=$_GET["pid"];
	
	$sql_delete="DELETE FROM `order` WHERE id_product='$id_product'";
	
				
	$result=mysql_query($sql_delete) or die("Error in sql due to ".mysql_error());
	
	if ($result)
	header("Location: order_list.php");
	
?>

Hi, i webmaster multi sites and at the moment run php code to block unwanted ip addresses because of bad submittings.   I am running this code at the moment <?php

How do I do this?

It only does the first nine records and wont cycle through the many records in the second dimension.

Thanks.

         // External Loop is 1 - 9
         // Internal Loop is 0 - whatever it is
   
         //$muarray_s[0]                        = $facility_id;
         //$muarray_d[$external_loop][$interal_loop]   = $objfields['139339_date'];
         //$muarray_t[$external_loop][$interal_loop]   = $objfields['139339_time'];
         //$muarray_i[$external_loop][$interal_loop]   = $objfields['139339_main_id'];
         
         //$array_of_mu[$external_loop][$interal_loop]    = $checklist_item_disc;
         
         echo "Begin Draw Runway Image Function <br>";
         echo "Establish Array Looping Procedure";
         
         for ($j=0; $j<10; $j=$j+1) {
               // External Loop
               // This is actually the Condition not the mu
               
               for ($k=0; $k<count($array_of_mu); $k=$k+1) {
                     // Internal Loop
                     // This is the Mu Value;
                     echo "Mu Value is ".$array_of_mu[$j][$k]."<br>";
               }
         }

In javascript you can do multiple methods on the same line like:
if(document.getElementById('myElement').className.match(/^[0-9]/)){/*Do something*/}

in that we have getElementById() and match() on the same line, and it works the same as if you were to split them on multiple lines.

Is it possible to do that with php?

For example:
$obj = new MyObject();

$obj->add(2, 3)->to_string();

I am having a hell of a time getting this to work. I need the keys in an array to be specific, not a sequential number or a row in my database. I need to add to the array through each loop of my while() statement. This code does it, but does not use the keys I specify, after the first entry, it starts assigning numbers to keys. Any guidance would be great.

<?php
require_once ('includes/config.php');
require_once ('includes/connect.php');

$echoarray = array();
$resultsql = mysql_query("SELECT * FROM clients")or die(mysql_error());
while($row = mysql_fetch_array($resultsql)){
    if(empty($echoarray)){
$echoarray = array(
'id' => $row['ID'],
'name' => $row['First_Name'] . " " . $row['Last_Name'],
'price' => $row['Status'],
'number' => $row['Sex'],
'address' => $row['Phys_Street'],
'company' => $row['Agency'],
'desc' => $row['Notes'],
'age' => $row['Date_Birth'],
'title' => $row['Occupation'],
'phone' => $row['Phone'],
'email' => $row['Email'],
'zip' => $row['Phys_Zip'],
'country' => $row['Phys_City']
);
}
else
{
array_push($echoarray,
$echoarray['id'] = $row['ID'],
$echoarray['name'] = $row['First_Name'] . " " . $row['Last_Name'],
$echoarray['price'] = $row['Status'],
$echoarray['number'] = $row['Sex'],
$echoarray['address'] = $row['Phys_Street'],
$echoarray['company'] = $row['Agency'],
$echoarray['desc'] = $row['Notes'],
$echoarray['age'] = $row['Date_Birth'],
$echoarray['title'] = $row['Occupation'],
$echoarray['phone'] = $row['Phone'],
$echoarray['email'] = $row['Email'],
$echoarray['zip'] = $row['Phys_Zip'],
$echoarray['country'] = $row['Phys_City']
);
    
}

Any Ideas?

l have a video site, and each title is generated dynamically on a <li>. The problem is  some titles are longer than others and spill on to the next <li> throwing my site all off. What i need to do is designate 2 lines for the titles just in case the title is too long.

Code: [Select]
<ul>
    <li><?php echo $title; ?></li>
    <li>///continue $title or add blank line so it doesn't throw everything off</li>
</ul>

Hello!   I need small help. Need php script for changinh milti lines in myslq database. In database are fiekds: date, ip, status 1. 2014-09-01, 123, 0 2. 2014-09-01, 444, 0 3. 2014-09-01, 123, 0 4. 2014-08-31, 888, 0 5. 2014-09-01, 444, 0 6. 2014-09-01, 123, 0   Now script must search ip and date.   1. record is OK, 2. record is OK, 3. record NOT OK, because date and ip are in first record, must change status to 1 4. record is OK, 5. record NOT OK, because date and ip are in second record, must change status to 1 6. record NOT OK, because date and ip are in 1 and 3 record, must change status to 1