Learn VBA & Macros in 1 Week!

PHP - Search Name And Pull Information - Mysql

Full Excel VBA Course - Beginner to Expert

Search Name And Pull Information - Mysql	View Content

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

Similar Tutorials

View Content

I found an article on how to implement a mysql search (http://www.iamcal.com/publish/articles/php/search/) and it seemed like a good way to go, but I can't get it up and running.

Here is my code:
Code: [Select]
<?php
$db_host = 'localhost';
$db_user = 'username';
$db_pwd = 'password';

$database = 'dbname';
$table = 'Principals';

if (!mysql_connect($db_host, $db_user, $db_pwd))
die("Can't connect to database");

if (!mysql_select_db($database))
die("Can't select database");

$searchterms = 'dorr oliver';

function search_split_terms($terms){

$terms = preg_replace("/\"(.*?)\"/e", "search_transform_term('\$1')", $terms);
$terms = preg_split("/\s+|,/", $terms);

$out = array();

foreach($terms as $term){

$term = preg_replace("/\{WHITESPACE-([0-9]+)\}/e", "chr(\$1)", $term);
$term = preg_replace("/\{COMMA\}/", ",", $term);

$out[] = $term;
}

return $out;
}

function search_transform_term($term){
$term = preg_replace("/(\s)/e", "'{WHITESPACE-'.ord('\$1').'}'", $term);
$term = preg_replace("/,/", "{COMMA}", $term);
return $term;
}

function search_escape_rlike($string){
return preg_replace("/([.\[\]*^\$])/", '\\\$1', $string);
}

function search_db_escape_terms($terms){
$out = array();
foreach($terms as $term){
$out[] = '[[:<:]]'.AddSlashes(search_escape_rlike($term)).'[[:>:]]';
}
return $out;
}

function search_perform($terms){

$terms = search_split_terms($terms);
$terms_db = search_db_escape_terms($terms);
$terms_rx = search_rx_escape_terms($terms);

$parts = array();
foreach($terms_db as $term_db){
$parts[] = "Principals RLIKE '$term_db'";
}
$parts = implode(' OR ', $parts);

$sql = "SELECT * FROM Principal WHERE $parts";

$rows = array();

$result = mysql_query($sql);
while($row = mysql_fetch_array($result, MYSQL_ASSOC)){

$row[score] = 0;

foreach($terms_rx as $term_rx){
$row[score] += preg_match_all("/$term_rx/i", $row[Principals], $null);
}

$rows[] = $row;
}

uasort($rows, 'search_sort_results');

return $rows;
}

function search_rx_escape_terms($terms){
$out = array();
foreach($terms as $term){
$out[] = '\b'.preg_quote($term, '/').'\b';
}
return $out;
}

function search_sort_results($a, $b){

$ax = $a[score];
$bx = $b[score];

if ($ax == $bx){ return 0; }
return ($ax > $bx) ? -1 : 1;
}

function search_html_escape_terms($terms){
$out = array();

foreach($terms as $term){
if (preg_match("/\s|,/", $term)){
$out[] = '"'.HtmlSpecialChars($term).'"';
}else{
$out[] = HtmlSpecialChars($term);
}
}

return $out;
}

function search_pretty_terms($terms_html){

if (count($terms_html) == 1){
return array_pop($terms_html);
}

$last = array_pop($terms_html);

return implode(', ', $terms_html)." and $last";
}

#
# do the search here...
#

$results = search_perform($searchterms);
$term_list = search_pretty_terms(search_html_escape_terms(search_split_terms($searchterms)));
The table name is 'Principals' and the field name I am trying to search is 'Principal'. I am getting an error on the line:

while($row = mysql_fetch_array($result, MYSQL_ASSOC)){

The error is:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

Can anyone shed some light on this for me?