PHP - Setting Up An Array

i have checkboxes in a form with the name="array[]" and in the php i use the implode function to separate all the values of all that was checked with a comma....my question is... how can i set the order of the array a certain way... i'd like to ultimately have a field where if you check a box you can enter into the field 1, 2, 3, 4 and so on and when you submit the form it will set the order according to what was entered

thanks

I'm somewhat new to OOP PHP, and I'm still learning, but basically I want searchcolumns() to set which MySQL columns that it'll search inside but I don't know where to go from what I've already coded.

Here's the basic input to be sent to my classes file:

$getusers = new database;
$getusers->search($_GET['search']);
$getusers->searchcolumns('username','account','email');

And to put it simple, I need my $where variable to output this:

$where .= "(username LIKE '%$search%' OR account LIKE '%$search%' OR email LIKE '%$search%')";

Except replacing the already set columns with the ones that I assigned in the searchcolumns() array, and then adding an OR string if there's more than 1 column set.

Here's the code as I have it at the moment, for obvious reasons, it doesn't work how I want it to:

// Search columns
function searchcolumns($columns) {

$this->column = explode(", ", $columns);
}

// Search results
function search($search) {

$search = ($_POST['search']);

if (isset($_GET['search']) && strlen($_POST['search']) > 1) {

$searchresult = explode(" ", $search);

$where = "WHERE";

foreach ($searchresult as $key => $search) { 

$where .= "($this->column LIKE '%$search%')";
if ($key != (sizeof($searchresult) - 1))   

$where .= " AND ";
} 

$this->where = $where;
}

}

Sorry if this has been somewhat confusing to explain, but hopefully someone understands what I'm trying to achieve.

There's probably an obvious reason but I can't seem to find it...

I start with the $_POST array, received from a form:
Code: [Select]
array(9) {
  ["Name"]=>
  string(3) "KTN"
  ["SQLServer"]=>
  string(24) "10.6.11.20\VSQLI028,1433"
  ["Username"]=>
  string(2) "GF"
  ["Password"]=>
  string(2) "GF"
  ["MasterDB"]=>
  string(11) "GFMaster_KN"
  ["Version"]=>
  string(3) "4.9"
  ["Prod"]=>
  string(1) "1"
  ["Monitored"]=>
  string(1) "0"
  ["button"]=>
  string(38) "updateColumnName=EnvironmentID;Value=1"
}
I get the button value from the array, and unset the button array value.
Code: [Select]
function load_POST($name) { //returns value and removes it from $_POST array. returns NULL if not existing.
  $debug = 0;
  if ( $debug == 1 ) {
    $backtrace = backtrace();
    echo __FUNCTION__."()";
    echo " <i>called by ".basename($backtrace[1]['file'])."</i><br/>\n";
  }
  $post = NULL;
  if( array_key_exists($name, $_POST) ) {
    $post = urldecode($_POST[$name]);
    if ( $debug == 1 ) {
      echo "post $name, value: $post<br/>\n";
    }
  } else {
    if ( $debug == 1 ) {
      echo "post $name: doesn't exist<br/>\n";
    }
  }
  unset($_POST[$name]);
  return $post;
}
$_POST is now:
Code: [Select]
array(8) {
  ["Name"]=>
  string(3) "KTN"
  ["SQLServer"]=>
  string(24) "10.6.11.20\VSQLI028,1433"
  ["Username"]=>
  string(2) "GF"
  ["Password"]=>
  string(2) "GF"
  ["MasterDB"]=>
  string(11) "GFMaster_KN"
  ["Version"]=>
  string(3) "4.9"
  ["Prod"]=>
  string(1) "1"
  ["Monitored"]=>
  string(1) "0"
}
Then I create the object to assign the values to:
Code: [Select]
object(Environment)#1 (9) {
  ["EnvironmentID"]=>
  NULL
  ["Name"]=>
  NULL
  ["SQLServer"]=>
  NULL
  ["Username"]=>
  NULL
  ["Password"]=>
  NULL
  ["MasterDB"]=>
  NULL
  ["Version"]=>
  NULL
  ["Prod"]=>
  int(0)
  ["Monitored"]=>
  int(0)
}
So far so good 
Then, for each remaining $_POST value, I update the Object accordingly:
First one, parametername: Name, parameter: KTN
Code: [Select]
object(Environment)#1 (10) {
  ["EnvironmentID"]=>
  NULL
  ["Name"]=>
  string(3) "KTN"
  ["SQLServer"]=>
  NULL
  ["Username"]=>
  NULL
  ["Password"]=>
  NULL
  ["MasterDB"]=>
  NULL
  ["Version"]=>
  NULL
  ["Prod"]=>
  int(0)
  ["Monitored"]=>
  int(0)
  ["ColumnName=EnvironmentID;Value=1"]=>
  object(stdClass)#3 (1) {
    ["ColumnName"]=>
    string(1) "1"
  }
}
And there we have the problem, for some reason the button value is added to the object somehow... Any ideas?
Thanks in advance!

I made a website in PHP mvc framework. Now I want to remove "public" keyword from URL. I tried by removing  require "../app/init.php";  these dots and bringing htaccess & index.php file in root directory. But it doesn't work. I searched on google but didn't find anything. Here is my index page code:

 

Quote

<?php 
session_start();

require "../app/init.php";

$app = new App();

 

and my htaccess code:

 

Quote

RewriteEngine On

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php?url=$1 [L,QSA]

Please give me a solution to it. Thank you

can anyone tell me why $username is not setting properly?  the password is, but $username is no.  it is setting as blank:
Code: [Select]
if ($_POST['go']) {
//Connect to the database through our include
if ($_POST['logid'] ==  "&#59;5757120050531338739&#61;49121200000&#63;"){
$username="oldcheney";
$username = stripslashes($username);
$username = strip_tags($username);
$username= strtolower($username);
$username = mysql_real_escape_string($username);

$password="password";}
else if($_POST['logid']=="&#59;5757120050531338721&#61;49121200000&#63;"){
$username="yankeehill";
$password="password";}
else if($_POST['logid']=="%6277202936423578^00000000^X&#63;"){
$username="holdrege";
$password="password";}

$password = md5($password);