PHP - Multi Table If Then

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.');

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");
	
?>

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

I have to multi select tables, the table on the left is field with the contents of an array, I then have it so the user can make there selections from the left box and move them into the right. They then hit submit and it gets stored inmysql table as an array. The problem I am  having is keeping the selections in that right box after any sort of page refresh.
Any ideas I have pasted the php and html code below, the add/remove function is controlled by javascript, I won't bother pasting that as i don't think it has anything to do with it.

PHP ********
Code: [Select]
<?php
/ ------- PARSING PERSONAL TRAINER DETAILS VENUE ---------
if ($_POST['parse_var'] == "fromPool"){
    
    $venue = $_POST['venue'];
    if (is_array($_POST['venue'])) {
  $venue = explode("\n", $_POST['venue']);
} else {
  $venue = $_POST['venue'];
}

     // Update the database data now here for all fields posted in the form
     $sqlUpdate = mysql_query("UPDATE ptdata SET venue='$venue' WHERE id='$id' LIMIT 1");
     if ($sqlUpdate){
            $success_msg = '<img src="images/Form/round_success.png" width="20" height="20" alt="Success" />Your venue information has been updated successfully';
     } else {
            $error_msg = '<img src="images/Form/round_error.png" width="20" height="20" alt="Failure" /> ERROR: Problems arose during the information exchange, please try again later</font>';
     }
}
// ------- END PARSING PERSONAL TRAINER DETAILS VENUE ---------
?>
<?php

//////////   Venue Array PHP For Multi Selection Boxes  ////////////

$dbString = ''; // To be pulled from Database

$toPool = explode(',', $dbString); 

$pool = Array('Your Home','My Home','Outside','Private Studio','Your Work','Gym');

if($_SERVER['REQUEST_METHOD'] == 'POST'){

    $toPool = (count($_POST['venue']) > 0)? $_POST['venue'] : Array();

    $newDbString = implode(',', $toPool); //  Store in Database;


}

$fromPool = array_diff($pool, $toPool);


?>

html ***********

<form action="ptmemberaccount.php" method="post" enctype="multipart/form-data"onsubmit="multipleSelectOnSubmit()">
<table width="500" align="left">
  <tr>
    <td width="500" height="300" align="center">
    <select multiple="multiple" name="fromBox[]" id="fromBox"> 


<?php



foreach($fromPool as $itm){

    echo "\t" . '<option value="' . $itm . '">' . $itm . '</option>' . PHP_EOL;

}

?>

</select>
    <select multiple="multiple" name="venue[]" id="toBox">


<?php 



foreach($toPool as $itm){
    
        echo "\t" . '<option value="' . $itm . '">' . $itm . '</option>' . PHP_EOL;

}

?>

</select> </td>
  </tr>
  <tr>
    <td align="center" height="35"><script type="text/javascript">

createMovableOptions("fromBox","toBox",400,200,'Training Venues','Selected Training Venues');

</script>

<p>Use the buttons to Add/Remove selections</p></td></td>
  </tr>
  <tr>
    <td align="center" height="100">
    <input type="submit" value="OK">
   
  </tr>
</table>
</form>

If you need anymore info let me know, also if anyone knows a better way of achieving this i am open to suggestions.

Many Thanks

MOD EDIT: code tags added

What am I missing here?

The array:
protected $form_bonus = array(
"Attacker" => array(
"Ashwin" => array(
"normal" => 1.15,
"rps" => 1.38), 
"Cordelon" => array(
"normal" => 1.15,
"rps" => 1.38),
"Mersan" => array(
"normal" => 1.15,
"rps" => 1.38),
"Phlanixian" => array( 
"normal" => 1.195,
"rps" => 1.494),
"Slythe" => array(
"normal" => 1.15,
"rps" => 1.38)
),
"Defender" => array(
"Ashwin" => array(
"normal" => 1.15,
"rps" => 1.38), 
"Cordelon" => array(
"normal" => 1.15,
"rps" => 1.38),
"Mersan" => array(
"normal" => 1.15,
"rps" => 1.38),
"Phlanixian" => array(
"normal" => 1.15,
"rps" => 1.38),
"Slythe" => array(
"normal" => 1.15,
"rps" => 1.38)
)
);

accessing it:
$bonus *= form_bonus[$this->role][$this->race]['rps'];

error:
PHP Parse error:  syntax error, unexpected '['

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>

Basically what I want to do is create an array of inheritance.  so here is the levels
Owner->Admin->moderator->User->guest

owner has all the abilities of admin, moderator, user and guest..

So I want to be able to sort through them and end with an array like this
Code: [Select]
$array['Owner'] = array('Admin', 'Moderator', 'User', 'Guest');
Currently my code works sort of. Basically Admin is only set to inherit Moderator. Moderator only inherits User. So this code works but only to 2 levels. I don't want to add a billion foeachs within each other for each level(currently 4) but I might add more roils so then I would have to add more foreachs. There must be a magic way to do this. Any feedback is appreciated!

Code: [Select]
<?PHP

$sql = 'SELECT * FROM '.self::$Config['PERMISSIONS']['Database'].'.permissions_inheritance';

$result = DB::Query($sql);
while($row = DB::fetch($result)){
if($row['type'] == '0'){
$group_i[$row['child']][] = $row['parent'];
}elseif($row['type'] == '1'){
$user_i[$row['child']][] = $row['parent'];
}
}

//echo count($group_i);
print_r($group_i);
$groups = array();


foreach($group_i as $Key=>$Value){
foreach($Value as $K=>$V){
$new_array[$Key][] = $V;
if(isset($group_i[$V]) && is_array($group_i[$V])){
foreach($group_i[$V] as $Q=>$A){
if(is_array($A)){
foreach($A as $C=>$X){
$new_array[$Key][] = $X;
}
}else{
$new_array[$Key][] = $A;
}
}
}
}

}
Let me know if you have any questions! I hope you enjoy the challenge lolol

Hello friends,

how can i combain this codes

If i've 3 functions $limited,$refere,$pass
all have commen result echo "good";

if($limited){

if($hits >= $limited){
echo "U1";
}else{
echo "Good";
}

} else {
echo "Good";
} 

=================================

if($refere){

if($me >= $you){
echo "U2";
}else{
echo "Good";
}

} else {
echo "Good";
} 

=================================

if($pass){

if($she >= $he){
echo "U3";
}else{
echo "Good";
}

} else {
echo "Good";
} 

thansk, it would really helps me alot

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>";
               }
         }

Hi can anybody help me out with the following problem I am having? I need to populate the key values in the multi-dimentional array structure shown below and the values will be used later in the following way:

<tr>
  <td><?php echo $sm_array[1]['col_1']; ?></td>
  <td><?php echo $sm_array[1]['col_2']; ?></td>
  <td><?php echo $sm_array[1]['col_3']; ?></td>
  <td><?php echo $sm_array[1]['col_4']; ?></td>
  //and so on, up to 10
</tr>
<tr>
  <td><?php echo $sm_array[2]['col_1']; ?></td>
  <td><?php echo $sm_array[2]['col_2']; ?></td>
  <td><?php echo $sm_array[2]['col_3']; ?></td>
  <td><?php echo $sm_array[2]['col_4']; ?></td>
  //and so on, up to 10
</tr>

This is the array structure, $td->innertext is just a different value each time and is not important for this example, it could essentially be anything:

sm_array[$row] = array( "col_1" => $td->innertext,
                        "col_2" => $td->innertext,
                        "col_3" => $td->innertext,
                        "col_4" => $td->innertext,
                        "col_5" => $td->innertext,
                        "col_6" => $td->innertext,
                        "col_7" => $td->innertext,
                        "col_8" => $td->innertext,
                        "col_9" => $td->innertext,
                        "col_10" => $td->innertext,
);

But I need to add the values inside a loop, like this:

while($row=0; $row<=10; $row++) {
  $sm_array[$row] = array( "col_".$row => $td->innertext);
}

But this doesn't allow me to change the key name inside the loop, so for $sm_array[1] there will be 10 keys and their values, and the same for $sm_array[2], it will also have 10 keys and different values for each key and so on! But for some reason the key value will not work this way inside a loop, it doesn't allow "col_".$row and I even tried to echo the key name, like this:

while($row=0; $row<=10; $row++) {
  $sm_array[$row] = array( "<?php echo $row; ?>" => $td->innertext);
}

It only seems to accept a fixed string or integer as the key, like this:

while($row=0; $row<=10; $row++) {
  $sm_array[$row] = array( "col_1" => $td->innertext);
  // or like this
  $sm_array[$row] = array( 1 => $td->innertext);
}

But then I have a problem, I can't change the key name dynamically! I have tried doing this with conditional staments like this, but it only accepts the first key name and the 2nd, 3rd etc, etc all fail:

while($row=0; $row<=10; $row++) {
  if($row==1){
     $sm_array[$row] = array( "col_1" => $td->innertext);
  }else if($row==2){
     $sm_array[$row] = array( "col_2" => $td->innertext);
  } //and so on
}

Can somebody please tell me what I am doing wrong or can't this be done or is their some other way of doing this?

Thanks in advance
Grant

I have been trying to solve this problem for a few days now and can't seem to work it out. I'm sure i'm missing some simple point..
I am using a mysql PDO fetch to return 2 fields in each row and then put them into an array of their own:
foreach ($st->fetchAll() as $row){
$subs[] = array($row['subscriber'],$row['plant']);
Some of the rows share the same $row[0], which is the 'subscriber' field. What I want to do is make up another array with each smaller array having a single, unique $row[0] and any number of added 'plant' fields following (e.g $row[1],$row[2] etc).
I've tried all sorts of ways to achieve this but am at a loss. Would someone be able to point me in the right direction ? Thanks.

I'm working on a PHP SMS gateway of sorts. I have the txt message saved to the variable $message but I have a small problem with multi-message text messages..

When most phones send multiple messages as one, they include a (X/Y) before the message.. X indicating which message it is out of Y messages.

A rough example:

Quote

the first message comes through:
$message = "(1/2) This is a multimessage text message that";

the second message comes through:
$message = "(2/2) will use more than one message to send";




I would like to be able to parse these... as such:

Quote

if ($message == "(1/Y)") {
// Save first message
} elseif ($message == "(2+/Y)") {
// Append to original message
// This number can be anything 2 and above
} else {
// One message text, so save it like normal
}



If I can figure this out, I'll write a tutorial in a few days on how to set up a free php sms gateway for your own project! Including how/where to get a free number to use!

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