Luke Warm

Now I'm getting the first two textboxes (still in the last table) Sorry, I probably messed up somewhere. Here's what I have now: <?php session_start(); $hostname = $_SESSION['hostname']; $user = $_SESSION['user']; $passwd = $_SESSION['passwd']; $database = $_SESSION['database']; $table = $_SESSION['table']; $conn = mysql_connect($hostname, $user, $passwd, $database); include("includes/header.html"); ?> <div id="container"> <div id="header"> <?php include("includes/title.php"); ?> </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="connect_db.php"><img src="images/server_conn_ico.png" align="left" />Server Connection</a></p> <p><a href="databases.php"><img src="images/databases_ico.png" align="left" />View Database</a></p> <p><a href="create_db.php"><img src="images/server_folder_ico.png" align="left" />Create Database</a></p> <p><a href="drop_db.php"><img src="images/drop_ico.png" align="left" />Drop Database</a></p> <p><a href="create_table.php"><img src="images/status_ico.png" align="left" />Add Table</a></p> <p><a href="add_fields.php"><img src="images/server_ico.png" align="left" />Add Fields</a></p> <p><a href="delete_table.php"><img src="images/status_delete_ico.png" align="left" />Delete Table</a></p> <p><a href="view_tables.php"><img src="images/tables_ico.png" align="left" />View Tables</a></p> <p class="active"><a href="view_data.php"><img src="images/user_admin_ico.png" align="left" />View Table Data</a></p> <p><a href="dbkiss_front.php"><img src="images/dbkiss_ico.png" align="left" />Database Browser</a></p> <p><a href="connect_info.php"><img src="images/health_ico.png" align="left" />Server Info</a></p> <p><a href="error_log.php"><img src="images/logs_ico.png" align="left" />Server Log</a></p> <p><a href="backup.php"><img src="images/backup_ico.png" align="left" />Backup</a></p> <p><a href="bug_report.php"><img src="images/bugs-icon.png" align="left" />Bug Reports</a></p> <p><a href="logged_out.php" onclick="logOut();"><img src="images/server_logout_ico.png" align="left" />Logout</a></p> </div> <div id="controls"><a href="javascript:self.close()"><img src="images/controls.png" /></a></div> <div id="main"> <div id="content"> <?php mysql_select_db($database); if(empty($database)) { echo "<p>You must be connected to a database in order to view any table data.</p>"; }else{ $sql = "SHOW TABLES FROM $database"; $result = mysql_query($sql); $table = array(); while ($row = mysql_fetch_row($result)) { $table[] = $row[0]; } if (count($table) == 0) { echo "<p>The database '" . $database . "' contains no tables.</p>\n"; } else { foreach($table AS $aTable) { echo "<p style='text-align:left;float:left;width:100%;margin-top:15px;'>Table: <font color='green'>$aTable</font>"; // sending query $result = mysql_query("SELECT * FROM {$aTable}"); if (!$result) { die("Query to show fields from table failed"); } } $fields_num = mysql_num_fields($result); echo "<form action='updateinfo.php' method='post'><table border='0' style='text-align:left;width:100%;'><tr>"; // printing table headers for($i=0; $i<$fields_num; $i++) { $field = mysql_fetch_field($result); echo "<td style='text-align:left;padding:3px;font-size:11px;color:green;'>{$field->name}</td>"; } echo "</tr>\n"; // printing table rows foreach($table AS $aTable) { $result = mysql_query("SELECT * FROM {$aTable}"); echo "<tr>"; // $row is array... foreach( .. ) puts every element // of $row to $cell variable //foreach($row as $cell) echo "<td style='text-align:left;padding:3px;font-size:12px;border:1px solid #888;background:#fff;clear:both;float:left;'><input type='text' name='fieldName' value='".$var['fieldName']."' /></td>"; echo "</tr>\n"; } mysql_free_result($result); echo "</table>"; //++$i; ?> <input type="submit" value=" Submit changes " /> <input type="button" value=" Cancel " onclick="window.location='view_data.php'" /> </form> <?php } } include("includes/footer.php"); ?>

I am getting some results on the "edit" page, however, only the last table's data is appearing in the text boxes. Here's the code for my edit page: <?php session_start(); $hostname = $_SESSION['hostname']; $user = $_SESSION['user']; $passwd = $_SESSION['passwd']; $database = $_SESSION['database']; $table = $_SESSION['table']; $conn = mysql_connect($hostname, $user, $passwd, $database); include("includes/header.html"); ?> <div id="container"> <div id="header"> <?php include("includes/title.php"); ?> </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="connect_db.php"><img src="images/server_conn_ico.png" align="left" />Server Connection</a></p> <p><a href="databases.php"><img src="images/databases_ico.png" align="left" />View Database</a></p> <p><a href="create_db.php"><img src="images/server_folder_ico.png" align="left" />Create Database</a></p> <p><a href="drop_db.php"><img src="images/drop_ico.png" align="left" />Drop Database</a></p> <p><a href="create_table.php"><img src="images/status_ico.png" align="left" />Add Table</a></p> <p><a href="add_fields.php"><img src="images/server_ico.png" align="left" />Add Fields</a></p> <p><a href="delete_table.php"><img src="images/status_delete_ico.png" align="left" />Delete Table</a></p> <p><a href="view_tables.php"><img src="images/tables_ico.png" align="left" />View Tables</a></p> <p class="active"><a href="view_data.php"><img src="images/user_admin_ico.png" align="left" />View Table Data</a></p> <p><a href="dbkiss_front.php"><img src="images/dbkiss_ico.png" align="left" />Database Browser</a></p> <p><a href="connect_info.php"><img src="images/health_ico.png" align="left" />Server Info</a></p> <p><a href="error_log.php"><img src="images/logs_ico.png" align="left" />Server Log</a></p> <p><a href="backup.php"><img src="images/backup_ico.png" align="left" />Backup</a></p> <p><a href="bug_report.php"><img src="images/bugs-icon.png" align="left" />Bug Reports</a></p> <p><a href="logged_out.php" onclick="logOut();"><img src="images/server_logout_ico.png" align="left" />Logout</a></p> </div> <div id="controls"><a href="javascript:self.close()"><img src="images/controls.png" /></a></div> <div id="main"> <div id="content"> <?php mysql_select_db($database); if(empty($database)) { echo "<p>You must be connected to a database in order to view any table data.</p>"; }else{ $sql = "SHOW TABLES FROM $database"; $result = mysql_query($sql); $table = array(); while ($row = mysql_fetch_row($result)) { $table[] = $row[0]; } if (count($table) == 0) { echo "<p>The database '" . $database . "' contains no tables.</p>\n"; } else { foreach($table AS $aTable) { echo "<p style='text-align:left;float:left;width:100%;margin-top:15px;'>Table: <font color='green'>$aTable</font>"; if (!mysql_connect($hostname, $user, $passwd)) die("Can't connect to database"); if (!mysql_select_db($database)) die("Can't select database"); // sending query $result = mysql_query("SELECT * FROM {$aTable}"); if (!$result) { die("Query to show fields from table failed"); } } $fields_num = mysql_num_fields($result); echo "<form action='updateinfo.php' method='post'><table border='0' style='text-align:left;width:100%;'><tr>"; // printing table headers for($i=0; $i<$fields_num; $i++) { $field = mysql_fetch_field($result); echo "<td style='text-align:left;padding:3px;font-size:11px;color:green;'>{$field->name}</td>"; } echo "</tr>\n"; // printing table rows while($row = mysql_fetch_row($result)) { echo "<tr>"; // $row is array... foreach( .. ) puts every element // of $row to $cell variable foreach($row as $cell) echo "<td style='text-align:left;padding:3px;font-size:12px;border:1px solid #888;background:#fff;clear:both;float:left;'><input type='text' value='{$cell}' /></td>"; echo "</tr>\n"; } mysql_free_result($result); echo "</table>"; //++$i; ?> <input type="submit" value=" Submit changes " /> <input type="button" value=" Cancel " onclick="window.location='view_data.php'" /> </form> <?php } } include("includes/footer.php"); ?> The session variable are at the top of the page. I'm using a mysql_fetch_row array to gather the data. Is there a better way to do this?

Thanks for the replies guys. I understand how to insert the edited data. I just don't know how to assign the session variables like $database or $table, etc. to pull the information from the database to the form in order to edit it. I'm using an array to read the table data. Just not sure how to pull individual fields into a form for editing.

Gang, I'm trying to create a form that allows me to edit table data within a MySQL database. I've been able to display the data, no problem. I want to be able to edit the fields in the database tables but have had no luck. I'm using session variables to connect and gather the information I need. Here's the code for collecting the table data: <?php mysql_select_db($database); if(empty($database)) { echo "<p>You must be connected to a database in order to view any table data.</p>"; }else{ // Show table data start $sql = "SHOW TABLES FROM $database"; $result = mysql_query($sql); $table = array(); while ($row = mysql_fetch_row($result)) { $table[] = $row[0]; } if (count($table) == 0) { echo "<p>The database '" . $database . "' contains no tables.</p>\n"; } else { foreach($table AS $aTable) { echo "<p style='text-align:left;float:left;width:100%;margin-top:15px;'>Table: <font color='green'>$aTable</font>"; if (!mysql_connect($hostname, $user, $passwd)) die("Can't connect to database"); if (!mysql_select_db($database)) die("Can't select database"); // sending query $result = mysql_query("SELECT * FROM {$aTable}"); if (!$result) { die("Query to show fields from table failed"); } $fields_num = mysql_num_fields($result); echo "<div style='text-align:left;width:100%;'><table border='0'><tr><td></td>"; // printing table headers for($i=0; $i<$fields_num; $i++) { $field = mysql_fetch_field($result); echo "<td style='text-align:left;padding:3px;font-size:11px;color:green;'>{$field->name}</td>"; } echo "</tr>\n"; // printing table rows while($row = mysql_fetch_row($result)) { echo "<tr><td style='text-align:center;padding:3px;font-size:10px;border:1px solid #888;background:#fff;'><a href='edit_data.php?=$row[0]' style='color:red;text-decoration:none;'>edit</a></td>"; // $row is array... foreach( .. ) puts every element // of $row to $cell variable foreach($row as $cell) echo "<td style='text-align:left;padding:3px;font-size:10px;border:1px solid #888;background:#fff;clear:both;float:left;'>$cell</td>"; echo "</tr>\n"; } mysql_free_result($result); echo "</table></div>"; } } } //end show table data include("includes/footer.php"); ?> I'm not sure how to create a form using the session variables in order to be able to edit the correct information since I want to edit numerous databases. Any help would be great! Thanks

I have an application I've written that allows me to create, drop databases, add tables, fields,etc. I want to be able to view the error.log in a textarea (or whatever) within the application to keep track of Apache.

I do. So far I've tried: <?php include('includes/error.log'); ?> Nothing.

Hey gang, Is there any way to view the apache error.log file in PHP?

I get the following message: DROP TABLE smithereensDeletion of table smithereens failed! -- No database selected HOWEVER... This works! $temp = $_POST['temp']; $sql = "DROP TABLE $temp"; mysql_select_db( $database ); $retval = mysql_query( $sql ); if(!$retval) { die('Could not delete table: ' . mysql_error()); } echo "Table $temp deleted successfully\n"; I appreciate your help. Thanks.

I placed the entire page code in my original post. Here it is again with your code included: <?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"><br/> <?php $temp = $_POST['temp']; $query = "DROP TABLE ".$temp; echo $query; mysql_query($query) or die ('Deletion of table '$temp' failed! -- '.mysql_error()); echo "<h1 style='color:green;'>Table $temp deleted</h1>"; include("includes/footer.html"); ?>

I did add the ";" to the echo line and error reporting is definitely on and displaying. I'm on a Linux machine FYI.

I get nothing. deletetable.php won't even load.

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 " /> <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!!

Running the loops is actually better. Rather than trying to run a query each time, looping to show them all works fine. I appreciate the help. Thanks, Keith

Here's the entire page code: <? include("includes/header.html"); session_start(); $_SESSION['hostname'] = $_POST['hostname']; $_SESSION['user'] = $_POST['user']; $_SESSION['passwd'] = $_POST['passwd']; $_SESSION['database'] = $_POST['database']; $_SESSION['table'] = $_POST['table']; ?> <div id="container"> <div id="header">Create DB</div> <div id="breadcrumbs"> <?php if(!$_SESSION['passwd'] && !$_SESSION['database'] && !$_SESSION['table']){ echo "<font color='red'>Not connected to server!</font>"; } else { echo "<font color='green'>Server: ".$_SESSION['hostname']."<br/>"; if(!$_SESSION['database']){ echo "</font>"; }else{ echo "Database: ".$_SESSION['database']."</font>"; } } ?> </div> <div id="nav"> <p class="active"><a href="#" onclick="javascript:window.open('connect_db.php','_self');"><img src="server_conn_ico.png" align="left" />Connect</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><a href="delete_table.php"><img src="status_delete_ico.png" align="left" />Delete Table</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 Logs</a></p> </div> <div id="controls"><a href="javascript:self.close()"><img src="controls.png" /></a></div> <div id="main"> <div id="content"> <?php $action = htmlspecialchars($_GET['action'], ENT_QUOTES); ?> <?php if (!$action) { ?> <h1>MySQL Connection</h1> <form action="<?php echo $_SERVER['PHP_SELF']; ?>?action=test" id="create_db" method="post"> <table cellpadding="2"> <tr> <td>Hostname:</td> <td><input type="text" name="hostname" id="hostname" value="localhost" size="20" tabindex="1" /></td> <td></td> </tr> <tr> <td>Username:</td> <td><input type="text" name="user" id="user" value="" size="20" tabindex="2" /></td> <td></td> </tr> <tr> <td>Password:</td> <td><input type="password" name="passwd" id="passwd" value="" size="20" tabindex="3" /></td> <td></td> </tr> <tr> <td>Database:</td> <td><input type="text" name="database" id="database" value="" size="20" tabindex="4" /></td> <td style="text-align:left;">(optional)</td> </tr> <tr> <td colspan="3" style="text-align:center;"><input type="submit" id="submit" value=" Connect " tabindex="5" /> <input type="reset" value=" Clear " name="reset"></td> </tr> </table> </form> <?php } ?> <?php if ($action == "test") { $hostname = trim($_POST['hostname']); $user = trim($_POST['user']); $passwd = trim($_POST['passwd']); $database = trim($_POST['database']); $table = trim($_POST['table']); $link = mysql_connect("$hostname", "$user", "$passwd"); if (!$link) { echo "<h1>Could not connect to the server '" . $hostname . "'</h1>\n"; echo mysql_error(); echo "<p align='center'><input type='button' value=' Back ' onclick='javascript:history.back();'></p>"; }else{ //echo "<h1>Successfully connected to the server '" . $hostname . "'</h1>\n"; printf("MySQL client info: %s\n", mysql_get_client_info()); // printf("MySQL host info: %s\n", mysql_get_host_info()); } if ($link && !$database) { echo "<p>No database name was given.</p><p style='text-align:left;padding-left:24px;width:80%;'>Available databases:</p>\n"; $db_list = mysql_list_dbs($link); echo "<pre style='text-align:left;padding-left:24px;font-size:1em;line-height:12px;'>\n"; while ($row = mysql_fetch_object($db_list)) { echo $row->Database . "\n"; } echo "</pre>\n"; } if ($database) { $dbcheck = mysql_select_db("$database"); if (!$dbcheck) { echo "<p align='center'>".mysql_error()."</p>"; echo " <input type='button' value=' Cancel ' onclick='javascript:history.back();'></p>"; }else{ echo "<form name='frm1' method='get' action=''><p style='text-align:center;width:37%;float:left;margin-top:0px;'>Available tables: "; echo "<select name='tables'>"; $sql = "SHOW TABLES FROM $database"; $result = mysql_query($sql); while ($row = mysql_fetch_row($result)) { echo "<option value='{$row[0]}' selected>{$row[0]}</option>\n"; $table = $row[0]; } echo "</select></p>"; echo "<p style='text-align:left;padding-left:24px;float:right;width:60%;margin-top:-15px;border:1px solid #d6d6d6;'>Table Fields: $table"; echo "<pre style='text-align:left;padding-left:24px;font-size:1.2em;width:50%;float:right;'>"; $result = mysql_query("SHOW COLUMNS FROM $table"); if (!$result) { echo "<p>The database '" . $database . "' contains no tables.</p>\n"; exit; } if (mysql_num_rows($result) > 0) { while ($row = mysql_fetch_assoc($result)) { print_r ($row); } echo "\n</pre></form>"; } else { //echo mysql_error(); echo '<p style=\'text-align:center;margin-bottom:-100px;\'><input type="button" value=" Create New Table " onclick="javascript:window.open(\'create_table.php\',\'_self\');">'; echo " <input type='button' value=' Cancel ' onclick='javascript:history.back();'></p>"; } } } } include("includes/footer.html"); ?> Hope this helps. Thank you.

The form gets submitted to itself " <?php echo $_SERVER['PHP_SELF']; ?> " and the method is POST.

Hi, I'm developing a PHP/MySQL application to create databases much like phpMyAdmin but just for localhost. I have everything working except in my TABLE listings. I get the TABLE listing OK, connect to a database that I specify in a SESSION, am able to list the TABLES in a drop down, and list the field attributes in a textarea. My problem is when I do a query of the tables, the last table's field attributes are the only ones listed so I'd like to pick a table from the drop down and show it's field attributes in the textarea. So far, I've searched for a remedy to no avail. Here's my code for the drop down after all connections are made: echo "<form name='frm1'><p style='text-align:left;padding-left:24px;'>Available tables: "; echo "<select name='tables'>"; $sql = "SHOW TABLES FROM $database"; $result = mysql_query($sql); while ($row = mysql_fetch_row($result)) { echo "<option value='{$row[0]}' selected>{$row[0]}</option>\n"; $table = $row[0]; } echo "</select></p>\n"; echo "<p style='text-align:left;padding-left:24px;'>Table Fields:"; echo "<pre style='text-align:left;padding-left:24px;font-size:1.2em;'><textarea cols='68' rows='60' name='info'>"; $result = mysql_query("SHOW COLUMNS FROM $table"); if (!$result) { echo 'Could not run query: ' . mysql_error(); exit; } if (mysql_num_rows($result) > 0) { while ($row = mysql_fetch_assoc($result)) { print_r($row); } echo "\n</textarea></pre></form>"; All the information is stored in SESSION variables obtained from a form: session_start(); $_SESSION['hostname'] = $_POST['hostname']; $_SESSION['user'] = $_POST['user']; $_SESSION['passwd'] = $_POST['passwd']; $_SESSION['database'] = $_POST['database']; $_SESSION['table'] = $_POST['table']; If someone could help, it would be greatly appreciated. Thanks.

I placed the code in my includes file as a function, getting error from that file now. Thanks anyway...

This is the start of the php: <?php # This script lists the images in the "uploads" directory. require_once ('includes/functions.inc.php'); $dir = 'uploads/'; // Define the directory to view. $files = scandir($dir); // Read all the images into an array. // Display each image caption as a link to the JavaScript function: foreach ($files as $image) { if (substr($image, 0, 1) != '.') { // Ignores anything starting with a period. // Get the image's size in pixels: $image_size = getimagesize ("$dir/$image"); // Calculate the image's size in kilobytes: $file_size = round ( (filesize ("$dir/$image")) / 1024) . "kb"; // Make the image's name URL-safe: $image = urlencode($image); This is where the "$path" statment begins...

It's occurring in the line: $path = "/var/www/html/uploads/";

$path = "/var/www/html/uploads"; $image = $_GET['delete']; $pf = $path.$image; if(is_file($pf)){ unlink($pf); } <a href='imageUploads.php?delete=$image'>Delete</a> Getting: Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in imagesUpload.php

When I put my mouse over the "delete" link, it shows the correct path: imagesUpload.php?delete=imagename.jpg Even if I change the code so "imagesUploads.php?delete=" shows full path, still deletes all files in the directory.

Exactly how do I do that?

I've added this code to the page: // Delete file when button clicked if(isset($_GET['delete'])) { unlink("uploads/".$image); echo "<center>File deleted!</center>"; } With a link added for each file to be deleted: <a href='imageUploads.php?delete=$image'>Delete</a> It deletes ALL the images in the directory instead of just one. NOTE: "uploads" is the directory where the files are stored...

I took your advice and created a function from the code you sent but it still doesn't work. I inserted the function into the page PHP code. Did not create a separate "include" file, if that makes a difference. Here's the function: function deleteMe() { if(unlink("/var/www/html/uploads/".$_FILES["file"]["name"])){ echo 'Deleted original file!'; } }

I'm working on a project to upload files. The uploading is working fine. I want to add a button to delete individual files loaded into a list. I've tried the unlink() function to no avail. I've attached my code. Any help would be appreciated... [attachment deleted by admin]