PHP - Column And Variable Names Using Php And Mysql

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

The Code Below is for my Colony Building page for my game.
That particular code is supposed to display the number of buildings built, which it does, and also allow me to change the number of buildings built, which it doesn't.
The code is part of a loop that displays all the possible buildings of a given type, in this case Iron Mines, that can be built on the colony.
Basically what I need to know is, how do I change the name of the column that is being updated as the code loops. Currently it is setting all the forms to alter the number of Basic iron mines on a colony.
I am hoping I can somehow call the names of all the columns into an array and use the same code that picks which column value i am selecting, the $?(an array)[$b](an incrementing number to call the correct array value):
$?[$b].
Then I would replace Basic, in the column part of the UPDATE code with the array and result selector so that the first time i include() the code it creates the form and sets it to alter Basic, but the second time it sets the code to alter the value in the next column.

Code: [Select]
<?php 
$dbhost = 'localhost:3306';
$dbuser = 'root';
$dbpass = 'root';
$dbname = 'aosdb';
$conn = mysql_connect($dbhost,$dbuser,$dbpass)
or die ('Error connecting to mysql');
mysql_select_db($dbname);
$b=1;
$queryp = "SELECT * FROM IMBuilt WHERE idcol = $idcol";
$resultp = mysql_query($queryp);
$Base = mysql_fetch_row($resultp);
if(isset($_POST["built"])) {
if($_POST) {
$Badd = $Base[$b]+$_POST["built"];
$queryi="UPDATE IMBuilt SET Basic=$Badd WHERE idcol = $idcol";
mysql_query($queryi);
}
}
$queryf = "SELECT * FROM IMBuilt WHERE idcol = $idcol";
$resultf = mysql_query($queryf);
$Basic = mysql_fetch_row($resultf);
?>
<p class="bd" id="built">| Built: <?php echo $Basic[$b] ?> |</p>
<form class="bd" method="post" action="IronMineList.php"><input type="varchar" name="built"><input type="submit" value="Build"></form>
</div>

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=344739.0

I have data similar to below.  I am doing a MySQL query and doing a JOIN based on instructor name.  I am echoing classes and linking the instructor name to another page with their BIO.  All is working great, however I want to use the ID's for something else.  How do I differentiate the ID between the Instructors table and the Classes Table without changing the column name in the database?     For instance, I want to echo the Instructor ID and then echo the Classes ID, but they are both the same column name in the database and since they are joined, how will that work?     Instructors:   ID  |  Instructor    |  Title         |  Bio                                          | 1    |  Bob Smith  |  Chef       |  bob smith is a chef with...        | 2   |  Jane Doe    | Professor |  Jane doe is an instructor that... |   Classes:   ID  |  Instructor   |  Class Title      |  Class Description                                          | 4    |  Bob Smith  |  Baking      | this is a baking class where you learn....        | 5   |  Jane Doe    | Food Safety |  Food safety is very important... |

Hi,

I'm trying to edit some database fields, I have text1, text2, text3, text4, text5, text6 etc..

They are displayed on the index.php page, with an edit link so the user can choose which set to edit

// Extract details from database
$sql = "SELECT * FROM data WHERE id=1";
$stmt = $db->prepare($sql);
$stmt->execute();
$e = $stmt->fetch();

<h1><?php  echo $e['text1']) ?></h1>
<p><?php echo ($e['text2']); ?></p>
<p><a href="edit.php">EDIT</a></p>

<h1><?php  echo $e['text3']) ?></h1>
<p><?php echo ($e['text4']); ?></p>
<p><a href="edit.php">EDIT</a></p>

<h1><?php  echo $e['text5']) ?></h1>
<p><?php echo ($e['text6']); ?></p>
<p><a href="edit.php">EDIT</a></p>

 

edit.php:

// Extract details from database
$sql = "SELECT * FROM data WHERE id=1";
$stmt = $db->prepare($sql);
$stmt->execute();
$e = $stmt->fetch();

<form method="post" action="process.php" enctype="multipart/form-data">

<label>Page Title
<input type="text" name="text1" maxlength="90" value="<?php echo $e['text1'] ?>" />
</label>
<br>
<label>Title Text</label>
<textarea name="text2"><?php echo $e['text2'] ?></textarea>

<input id="button" type="submit" name="submit" value="Save Changes" />

and then update them: process.php

	$sql = "UPDATE data SET text1=?, text2=? WHERE id=1 LIMIT 1";
	$stmt = $db->prepare($sql);
	$stmt->execute(
		array(
			  $_POST['text1'],
			  $_POST['text2']
			 )
	);
	$stmt->closeCursor();

Question:

How can I pass the form values dynamically from the index.php page so I don't have to hard code text1, text2 etc into the edit.php and process.php page and have a different update & process page for each set of data?

 

Thanks in advance.