PHP - Recursively Change Database Field Names With Php

I have the following mysql query:
Code: [Select]
        $lead_query=$this->db->query("
   SELECT `first_name`, `last_name` , `state` FROM leads WHERE `lead_id`='$lead_id'
   ");
   $this->view->lead_query=$lead_query->fetchALL();
Now when I retrieve the above details  I need to return the first_name last_name together(separated as space) and the name of the key as client_name in the array.

I need it that way because when i return a json_encode($lead_query), I want to return the first_name.last_name as client_name.

I need to update a particular table and there be a whole lot of field names. I'd like to do it without having to use them the same way you can access then like $row[12] after a "select" query. The standard for updating (at least how I write it) goes like this ...
Code: [Select]
$query = "UPDATE linguistics SET welcome1='$var3', welcome2='$var4' WHERE language = '$lengua'";
Well, I'd like to do it where I don't have to name welcome1 and welcome2, but instead refer to their numerical position within the database. On a "select" query we can do this. Can this be done on an update? Something perhaps like ...
Code: [Select]
$query = "UPDATE linguistics SET 3='$var3', 4='$var4' WHERE language = '$lengua'";
... where 3 and 4 represent the 4th and 5th fields respectively. I know that this particular phrasing doesn't work because I've tried it, but surely there has to be something. This will save me LOTS of time. Thanks!!

I currently have php code that outputs information from my database, but how do i make it also display the name of the fields beside each entry of the database?

heres my PHP code:
Code: [Select]
<?php

$server = "";      // Enter your MYSQL server name/address between quotes
$username = "";    // Your MYSQL username between quotes
$password = "";    // Your MYSQL password between quotes
$database = "";    // Your MYSQL database between quotes

$con = mysql_connect($server, $username, $password);       // Connect to the database
if(!$con) { die('Could not connect: ' . mysql_error()); }  // If connection failed, stop and display error
mysql_select_db($database, $con);  // Select database to use
// Query database
$result = mysql_query("SELECT * FROM Properties");

if (!$result)
{
    echo "Error running query:<br>";
    trigger_error(mysql_error());
}
elseif(!mysql_num_rows($result))
{
    // no records found by query.
    echo "No records found";
}
else
{
    $i = 0;
    echo '<div style="font-family:helvetica; font-size:15px; padding-left:15px; padding-top:20px;">';
    while($row = mysql_fetch_array($result)) {     // Loop through results
        $i++;
         echo '<img class="image1" src="'. $row['images'] .'" />';   //image
        echo "Displaying record $i<br>\n";
        echo "<b>" . $row['id'] . "</b><br>\n";      // Where 'id' is the column/field title in the database
        echo $row['Location'] . "<br>\n";            // Where 'location' is the column/field title in the database
        echo $row['Property_type'] . "<br>\n";       // as above
        echo $row['Number_of_bedrooms'] . "<br>\n";  // ..
        echo $row['Purchase_type'] . "<br>\n";       // ..
        echo $row['Price_range'] . "<br>\n";         // ..
    }
echo '</div>';
}

mysql_close($con);  // Close the connection to the database after results, not before.
?>



thanks in advance

Okay, so I'm trying to run a query to pull the information from a specific item that they click on in order to edit it.

When I run an echo $query, though, it shows the field names rather than the information from the table.

How can I make it so that it pulls the information rather than the field names?

Here's what I have...


<?php
include("lib.php");
define("PAGENAME", "Edit Equipment");

if ($player->access < 100)

$msg1 = "<font color=\"red\">"; //name error?
$error = 0;

$query = $db->execute("SELECT * FROM items WHERE id=?", array($_POST['id']));

echo "$id";

$result = mysql_query($query);

echo "$query";

$data = mysql_fetch_assoc($result); 

$msg1 .= "</font>"; //name error?


?>


Thanks!!

Hi all,

I have the following MySQL insert query:
Code: [Select]
$insert= mysql_query   ("INSERT INTO tablename (column1,`".$EXPfields."`) VALUES ('$something','".$EXPvalues."')");
where $EXPfields is an array of table-field-names and $EXPvalues is an array of table-field-values.

Now I want to write an equivalent query, but using UPDATE instead of INSERT INTO, but I don't want to write out all the field names/values separately, but again want to use $EXPfields and $EXPvalues.

So something like this:
Code: [Select]
$update = mysql_query ("UPDATE tablename
                     SET (column1,`".$EXPfields."`) = ('$something','".$EXPvalues."')
                     WHERE ....
                  ");

Is this possible? If so, what is the proper syntax? Thanks!

Hello again!   I'm here with another PHP/Mysqli related question, I want to output the data i receive from the Query:

SHOW tables; 

Into html code, more specific: links. This is what i try'd to do:

<div class="container">
  <div class="header" align="center">
   <nav>
		<ul>
			<li><a href="#">Home</a></li>
			<li><a href="#">Databases</a>
				<ul>
<?php
$mysqli = new mysqli('localhost','*****','*****','*****');
if ($mysqli->connect_error) {
    die("Connection failed: " . $mysqli->connect_error);
} 
$sql = 'show tables from osiris1q_mtg';
$result = $mysqli->query($sql);
if(!$result = $mysqli->query($sql)){
    die('There was an error running the query [' . $mysqli->error . ']');
}
    // output data of each row
    while($row = $result->fetch_assoc()){
    echo "<li><a href='#'></a>"$row"</li>";
}
} else {
    echo "<li><a href='#'></a>0 results</li>";
}				</ul>
			</li>
		</ul>
	</nav>
</div>    <!-- end .header -->
?>

This is the header.php file which is included in the actual index page. This doesn't return anything not even the html parts of it. Even all the files i have 'included' aren't showing up anymore. I hope i explained myself good enough for anyone to understand   How Anyone can help me out!   Thank you in Advance!

Hello everyone I'm very new here but i hope you could help me with a tricky problem I no longer know how to approach it because it's difficult to visalize the solution.

Anyway, I have a script that goes to the root of a site (with cURL) and picks up categories (links on the site) via regex.
All the links are placed  into the big array I have. The first layer (dimension) I've managed to create but the problem comes to when I need my script to delve into deeper dimensions.

I want, for each link it finds, go to that page and find those subcategories and place it in my array in the correct subarray. If the regex returns 0 matches, go up one step and go to the next node's site, until the whole big array has been exhausted.

Is this possible? Please help out guys and gals. I'll provide more info and code if requested.

Can anyone let me know what I am doing wrong.  I am sure it will (after the fact) be obvious, but I don't see it right now.  Wish to remove all array elements which do not implement ValidatorCallbackInterface.  Thanks

<?php
interface ValidatorCallbackInterface{}
class ValidatorCallback implements ValidatorCallbackInterface{}

function array_filter_recursive($input) {
    foreach ($input as &$value) {
        if (is_array($value)) {
            $value = array_filter_recursive($value);
        }
    }
    return array_filter($input, function($v) {
        return $v instanceOf ValidatorCallbackInterface;
    });
}

function recursive_unset(&$array) {
    foreach ($array as $key => $value) {
        if (is_array($value)) {
            recursive_unset($value);
            if(empty($value)) {
                unset($array[$key]);
            }
        }
        elseif(!$value instanceOf ValidatorCallbackInterface) {
            unset($array[$key]);
        }
    }
}

$validatorCallback = new ValidatorCallback();
$rules=[
    'callbackId'=>"integer",
    'info'=>[
        'arrayofobjects'=>[$validatorCallback],
        'foo1'=>'bar1'
    ],
    'foo2'=>'bar2',
    'bla'=>[
        'a'=>'aa',
        'b'=>'bb',
    ],
    'singleobject'=>$validatorCallback
];

echo('original rules'.PHP_EOL);
var_dump($rules);

$desiredrules=[
    'info'=>[
        'arrayofobjects'=>[$validatorCallback]
    ],
    'singleobject'=>$validatorCallback
];

echo('desired rules'.PHP_EOL);
var_dump($desiredrules);

echo('array_filter_recursive'.PHP_EOL);
var_dump(array_filter_recursive($rules));

echo('recursive_unset'.PHP_EOL);
recursive_unset($rules);
var_dump($rules);

 

original rules
array(5) {
  ["callbackId"]=>
  string(7) "integer"
  ["info"]=>
  array(2) {
    ["arrayofobjects"]=>
    array(1) {
      [0]=>
      object(ValidatorCallback)#1 (0) {
      }
    }
    ["foo1"]=>
    string(4) "bar1"
  }
  ["foo2"]=>
  string(4) "bar2"
  ["bla"]=>
  array(2) {
    ["a"]=>
    string(2) "aa"
    ["b"]=>
    string(2) "bb"
  }
  ["singleobject"]=>
  object(ValidatorCallback)#1 (0) {
  }
}
desired rules
array(2) {
  ["info"]=>
  array(1) {
    ["arrayofobjects"]=>
    array(1) {
      [0]=>
      object(ValidatorCallback)#1 (0) {
      }
    }
  }
  ["singleobject"]=>
  object(ValidatorCallback)#1 (0) {
  }
}
array_filter_recursive
array(1) {
  ["singleobject"]=>
  object(ValidatorCallback)#1 (0) {
  }
}
recursive_unset
array(2) {
  ["info"]=>
  array(2) {
    ["arrayofobjects"]=>
    array(1) {
      [0]=>
      object(ValidatorCallback)#1 (0) {
      }
    }
    ["foo1"]=>
    string(4) "bar1"
  }
  ["singleobject"]=>
  object(ValidatorCallback)#1 (0) {
  }
}

 

Hello,
In m script, I need to get the content of another php file as a string, including the content of all the files which are included in it and in lower levels.
Any idea how to do it?
I tried output buffer+include but it doesn't get the content of the included files.

Thanks

Hi, I have a multidimensional array where each array has a parent id node to create a hierarchical tree.


$hierarchy[] = array('id' => 1, 'parent_id' => 0, 'name' = 'root1');
$hierarchy[] = array('id' => 2, 'parent_id' => 0, 'name' = 'root2');
$hierarchy[] = array('id' => 3, 'parent_id' => 1, 'name' = 'root1-1');
$hierarchy[] = array('id' => 4, 'parent_id' => 1, 'name' = 'root1-2');
$hierarchy[] = array('id' => 5, 'parent_id' => 3, 'name' = 'root1-1-1');
$hierarchy[] = array('id' => 6, 'parent_id' => 2, 'name' = 'root2-1');


I'm trying to come up with a recursive key/value search routine that will return all ancestor arrays of the found item without knowing the depth of the tree.  All nodes with 0 for the parent_id are root level nodes.

Basically I want to search for something like "where key = name and value = xxx" and have it return all ancestors of that node.

So if I wanted to search for "key = name and value = root1-1", it should return and array like:

array[0] = array('id' => 1, 'parent_id' => 0, 'name' = 'root1'); //parent node first
array[1] = array('id' => 3, 'parent_id' => 1, 'name' = 'root1-1');  //first child after parent

if I was to search for "key = name and value = root1-1-1", it should return:

array[0] = array('id' => 1, 'parent_id' => 0, 'name' = 'root1'); //parent node first
array[1] = array('id' => 3, 'parent_id' => 1, 'name' = 'root1-1');  //first child after parent
array[2] = array('id' => 5, 'parent_id' => 3, 'name' = 'root1-1-1'); //first grandchild

So the main problem comes in the iteration and keeping track of parents.  If I just want the array with the answer I can get that node, but I can't get it with all of the ancestors attached.  How would you go about this?  Any good ideas out there?

Thanks!

Is there a way to duplicate all rows in a table AND change one field's value for each new row?   For example...   TABLE:  comments FIELDS:  commentid userid comment weeknumber   Say there are only 5 comments in there like this (I have MANY rows, but keeping sample size small for example's sake)...   1-17-hello-3 2-41-hey-3 3-18-yo-3 4-67-sup-3 5-12-hola-3   I would like to duplicate them AND make the "weeknumber" = 4, so the table ultimately has 10 rows like this...   1-17-hello-3 2-41-hey-3 3-18-yo-3 4-67-sup-3 5-12-hola-3 1-17-hello-4 2-41-hey-4 3-18-yo-4 4-67-sup-4 5-12-hola-4   Is this doable?   Thanks...

In the php web script, when a user is redirected to faq, for example, the web script displays website.net/faqfolder in the web browser field Can it be modified to just display website.net/faq? If so, how?

My Php Buddies,

I have mysql tbl columns these:

id: 
date_&_time: 
account_activation_code: 
account_activation_status: 
id_video_verification_status: 
id_verification_video_file_url: 
username: 
password: 
primary_domain: 
primary_website_email: 
sponsor_username: 
 

Now, I want to display their row data by excluded a few columns.

Want to exclude these columns:

date_&_time

account_activation_code

account_activation_status

id_verification_video_file_url

password

 

So, the User's (eg. your's) homepage inside his account should display labels like these where labels match the column names but the underscores are removed and each words' first chars CAPITALISED:

Id: 1
Id Video Verification Status: 1
Username: requinix
Primary_domain: requinix.majesty
Primary Website Email: requeen@requinix.majesty
Sponsor Username: phpsane
Recruits Number: 2

 

For your convenience only PART 1 works. Need help on Part 2

My attempted code:

 

	PART 1
	<?php 
	// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
	// Query to get columns from table
$query = $conn->query("SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'members' AND TABLE_NAME = 'users'");
	while($row = $query->fetch_assoc()){
    $result[] = $row;
}
	// Array of all column names
$columnArr = array_column($result, 'COLUMN_NAME');
	foreach ($columnArr as $value) { 
echo "<b>$value</b>: ";?><br><?php 
} 
	?>
	 
	PART 2
	<?php 
	//Display User Account Details 
echo "<h3>User: <a href=\"user.php?user=$user\">$user</a> Details</h3>";?><br> 
<?php 
$excluded_columns = array("date_&_time","account_activation_code","account_activation_status","id_verification_video_file_url","password"); 
foreach ($excluded_columns as $value2) 
{    
    echo "Excluded Column: <b>$value2</b><br>";
}
foreach ($columnArr as $value) 
{ 
    
    if($value != "$value2")
    { 
        $label = str_replace("_"," ","$value"); 
        $label = ucwords("$label"); 
        //echo "<b>$label</b>: "; echo "$_SESSION[$value]";?><br><?php 
        echo "<b>$label</b>: "; echo "${$value}";?><br><?php 
    }
} 
?>
	

PROBLEM: Columns from the excluded list still get displayed.

Edited November 19, 2018 by phpsane

hi,
this is my first post, i hope someone here can give me a hand with this.
i have created a new field in the member_profile table in my database. lets say i named it newfield.
i would like a yes to be placed in this newfield at the same time i give moderator privlages to a member.
i can manually enter a yes in newfield now with phpmyadmin.

i believe this code applies the moderator settings, any ideas on a way to have this post yes in my new field as well.


//make Moderator
//////////////////////
if (isset($_POST['moderator']) && isset($_POST['list'])) {
    foreach ($_POST['list'] as $user_id) {
        managemember($user_id,'moderator');
}

    //notifications
    $show_notification = 1;
    $message = notifications(1);
}


any help greatly appreciated.