PHP - Variable From Table??

Hello,

I'm working on a PHP register form, all I want to do, is to be able to insert an extra variable into the database:

Code: [Select]
// now we insert it into the database
$insert = "   INSERT INTO users (username, password) VALUES ('".$_POST['username']."', '".$_POST['pass']."')   ";

$add_member = mysql_query($insert);
right, so I have the username and password variable being passed. But I also want to pass a variable into a column called 'weaponAttachments', all I want for this variable to be is 5000.

So, in other words, something like this: 5000['weaponAttachments']

Thanks

<?php
function money($amount,$separator=true,$simple=false){
    return
        (true===$separator?
            (false===$simple?
                number_format($amount,2,'.',','):
                str_replace('.00','',money($amount))
            ):
            (false===$simple?
                number_format($amount,2,'.',''):
                str_replace('.00','',money($amount,false))
            )
        );
}
$income = 5000000000;
$daily = money($income*24,true,true);
$weekly = money(($income*24)*7,true,true);
$monthly = money((($income*24)*7)*30,true,true);

?>
</center>
<center>
<table border="1">
  <tr>
    <td>Daily</td>
    <td><?php echo $daily ?></td>
  </tr>
  <tr>
    <td>Weekly</td>
    <td><?php echo $weekly ?></td>
  </tr>
  <tr>
    <td>Monthly</td>
    <td><?php echo $monthly ?></td>
  </tr>
</table>
</form>
</center>



What am I doing wrong? Im fairly new to this

Hi,

I'm trying to drop a table form a database using the table name as a variable. This variable is set within a session. I am using a form where you input the table name, then the DROP TABLE procedure is executed in the next page.

I know that the variable gets passed because it prints the table name variable out when I "echo".

The execution is simple (code found in deletetable.php)

$temp = $_POST['temp'];
$query = "DROP TABLE $temp";
if(mysql_query($query)){
echo "<h1 style='color:green;'>Table $temp deleted</h1>";}
else{
echo "<h1 style='color:red;'>Deletion of table '$temp' failed!</h1>";}


Here's my code for the two pages:
delete_table.php

<?php
include("includes/header.html");
session_start();
$hostname = $_SESSION['hostname'];
$user = $_SESSION['user'];
$passwd = $_SESSION['passwd'];
$database = $_SESSION['database'];
$tblname = $_SESSION['table'];

$conn = mysql_connect($hostname, $user, $passwd, $database);
/*if(! $conn )
{
  die('Could not connect: ' . mysql_error());
}*/
?>
<div id="container">
<div id="header">Create DB</div>
<div id="breadcrumbs">
<?php
function check_port($port) {
    $conn = @fsockopen("127.0.0.1", $port, $errno, $errstr, 0.2);
    if ($conn) {
        fclose($conn);
        return true;
    }
}

function server_report() {
    $report = array();
    $svcs = array('3306'=>'MySQL');
    foreach ($svcs as $port=>$service) {
        $report[$service] = check_port($port);
    }
    return $report;
}

$report = server_report();
?>
<div id="server"><p>Server is <?php echo $report['MySQL'] ? "running" : "offline"; ?></p></div>
<?php
if(!$_SESSION['hostname']){

echo "<font color='red'>Not connected to server!</font>";
} else {

echo "<font color='green'>Server: ".$_SESSION['hostname']."</font>";
} 
if(!$_SESSION['database']){

echo "";
}else{

echo "<br><font color='green'>Database: ".$_SESSION['database']."</font>";
}
?>
</div>
<div id="nav">
<p><a href="#" onclick="javascript:window.open('connect_db.php','_self');"><img src="server_conn_ico.png" align="left" />Server Connection</a></p>
<p><a href="databases.php"><img src="databases_ico.png" align="left" />View Database</a></p>
<p><a href="create_db.php"><img src="server_folder_ico.png" align="left" />Create Database</a></p>
<p><a href="drop_db.php"><img src="drop_ico.png" align="left" />Drop Database</a></p>
<p><a href="create_table.php"><img src="status_ico.png" align="left" />Add Table</a></p>
<p><a href="add_fields.php"><img src="server_ico.png" align="left" />Add Fields</a></p>
<p class="active"><a href="delete_table.php"><img src="status_delete_ico.png" align="left" />Delete Table</a></p>
<p><a href="view_tables.php"><img src="user_admin_ico.png" align="left" />View Tables</a></p>
<p><a href="view_data.php"><img src="user_admin_ico.png" align="left" />View Table Data</a></p>
<p><a href="http://localhost/phpmyadmin/" target="_blank"><img src="phpmyadmin_ico.png" align="left" />phpMyAdmin</a></p>
<p><a href="connect_info.php"><img src="health_ico.png" align="left" />System Info</a></p>
<p><a href="error_log.php"><img src="logs_ico.png" align="left" />Server Log</a></p>
<p><a href="bug_report.php"><img src="bugs-icon.png" align="left" />Bug Reports</a></p>
</div>
<div id="controls"><a href="javascript:self.close()"><img src="controls.png" /></a></div>
<div id="main">
<div id="content">
<!--<h1>Delete Database Table</h1>-->
<?php
if(empty($database)) {

echo "<p>You must be connected to a database in order to delete a table.</p>";
}else{
//echo 'Connected successfully to \''.$database.'\'';

// Check tables

$sql = "SHOW TABLES FROM $database";

$result = mysql_query($sql);

if (mysql_num_rows($result) > 0) {

echo "<p style='text-align:left;padding-left:24px;'>Available tables:</p>\n";

echo "<pre style='text-align:left;padding-left:24px;font-size:1.2em;'>\n";

while ($row = mysql_fetch_row($result)) {

echo "{$row[0]}\n";

}

echo "</pre>\n";

}
?>
<form action="deletetable.php" method="post">
Enter table you'd like to delete from '<?php echo $database; ?>' database:
<input name="temp" type="text" /><br/>
<input name="Submit" type="submit" value="  Delete Table  " />&nbsp;&nbsp;&nbsp;<input type='button' value='  Cancel  ' onclick="javascript:window.location='connect_db.php';"></p>
</form>
<?php
}
include("includes/footer.html");
?>


Executing file deletetable.php:

<?php
include("includes/header.html");
session_start();
$hostname = $_SESSION['hostname'];
$user = $_SESSION['user'];
$passwd = $_SESSION['passwd'];
$database = $_SESSION['database'];
//$tblname = $_SESSION['table'];

$conn = mysql_connect($hostname, $user, $passwd, $database);
?>
<div id="container">
<div id="header">Create DB</div>
<div id="breadcrumbs">
<?php
function check_port($port) {
    $conn = @fsockopen("127.0.0.1", $port, $errno, $errstr, 0.2);
    if ($conn) {
        fclose($conn);
        return true;
    }
}

function server_report() {
    $report = array();
    $svcs = array('3306'=>'MySQL');
    foreach ($svcs as $port=>$service) {
        $report[$service] = check_port($port);
    }
    return $report;
}

$report = server_report();
?>
<div id="server"><p>Server is <?php echo $report['MySQL'] ? "running" : "offline"; ?></p></div>
<?php
if(!$_SESSION['hostname']){

echo "<font color='red'>Not connected to server!</font>";
} else {

echo "<font color='green'>Server: ".$_SESSION['hostname']."</font>";
} 
if(!$_SESSION['database']){

echo "";
}else{

echo "<br><font color='green'>Database: ".$_SESSION['database']."</font>";
}
?>
</div>
<div id="nav">
<p><a href="#" onclick="javascript:window.open('connect_db.php','_self');"><img src="server_conn_ico.png" align="left" />Server Connection</a></p>
<p><a href="databases.php"><img src="databases_ico.png" align="left" />View Database</a></p>
<p><a href="create_db.php"><img src="server_folder_ico.png" align="left" />Create Database</a></p>
<p><a href="drop_db.php"><img src="drop_ico.png" align="left" />Drop Database</a></p>
<p><a href="create_table.php"><img src="status_ico.png" align="left" />Add Table</a></p>
<p><a href="add_fields.php"><img src="server_ico.png" align="left" />Add Fields</a></p>
<p class="active"><a href="delete_table.php"><img src="status_delete_ico.png" align="left" />Delete Table</a></p>
<p><a href="view_tables.php"><img src="user_admin_ico.png" align="left" />View Tables</a></p>
<p><a href="view_data.php"><img src="user_admin_ico.png" align="left" />View Table Data</a></p>
<p><a href="http://localhost/phpmyadmin/" target="_blank"><img src="phpmyadmin_ico.png" align="left" />phpMyAdmin</a></p>
<p><a href="connect_info.php"><img src="health_ico.png" align="left" />System Info</a></p>
<p><a href="error_log.php"><img src="logs_ico.png" align="left" />Server Log</a></p>
<p><a href="bug_report.php"><img src="bugs-icon.png" align="left" />Bug Reports</a></p>
</div>
<div id="controls"><a href="javascript:self.close()"><img src="controls.png" /></a></div>
<div id="main">
<div id="content">
<?php
$temp = $_POST['temp'];
$query = "DROP TABLE $temp";
if(mysql_query($query)){
echo "<h1 style='color:green;'>Table $temp deleted</h1>";}
else{
echo "<h1 style='color:red;'>Deletion of table '$temp' failed!</h1>";}

include("includes/footer.html");
?>


Your help is greatly appreciated!!

I have a dropdown menu

<td width="148" height="35" valign="top"><b>Type: </b> </td>
            <td><select name ="tabledrop">
<option value="goggles">goggles</option>
<option value="headbands">headbands</option>
 <input type='hidden' id='tabledrop' name='tabledrop' value = ''/>
</select>
</td>

those 2 options are actually names of my tables.


I tried this and got some syntax error.


$type = $_POST['tabledrop'];
$item = $_POST['goggles_name'];
$price = $_POST['goggles_price'];
$file = $_FILES['goggles_image']['name'];

$query = "INSERT into $type SET [$type]_name = '$item' , [$type]_price = '$price' , [$type]_image = '$file'";

Hi, i cant seem to get something working, should be simple but its not working for me.

I just need to only display a table if a variable in my table = a certain value.

The column in the table is called 'option1_available' and if its value is set to 'Y' i want it to display a table.

Appreciate any help, Thanks