how to delete a table

Question

slap01 0 Newbie Poster

14 Years Ago

i code this without the delete function, but when i started using it, there's and error.
need help with this code

<?php

$_GET['id'];

	$username = "root";
	$password = '123456';
	$hostname = "localhost";
	$db = mysql_connect($localhost, $username, $password)
	or die ("Unable to connect to mySQL".mysql_error());
	mysql_select_db('mynewdbase');

$del = "DELETE FORM newdbase WHERE id = $id";

$nres = mysql_query("$del);

?>
<HTML>
<BODY>
<form method = "get" action = "act1.php">
Storename: <select name="store">
<option value="">---Select---</option>
<option value="Aling Nena">Aling Nena</option>
<option value="Aling Tentay">Aling Tentay</option>
<option value="Aling Toyang">Aling Toyang</option>
</select>
<br>
Sales <input type = "text" name = "sales"><br>
Date  <input type = "text" name = "year" size = "3" value = "<?php echo date('Y'); ?>">
-<input type = "text" name = "month" size = "3" value = "<?php echo date('m'); ?>">
-<input type = "text" name = "day" size = "3" value = "<?php echo date('d'); ?>"><br>
<input type = "submit" name = "submit" value = "Save">
<input type = "reset" name = "clear" value = "Cancel">
</form>
</BODY>
</HTML>

<?php
if (isset($_GET['submit']))
{
	$username = "root";
	$password = '123456';
	$hostname = "localhost";
	$db = mysql_connect($localhost, $username, $password)
	or die ("Unable to connect to mySQL".mysql_error());

mysql_select_db('mynewdbase');

	$store = $_GET['store'];
	$sales = $_GET['sales'];
	$year = $_GET['year'];
	$month = $_GET['month'];
	$day = $_GET['day'];

$ans = "INSERT INTO newdbase VALUES ('$store', '$sales', '$year' ,'$month', '$day')";

	$result = mysql_query($ans);

	if($ans!='')
	echo '<br>Saving Successful';
	else
	echo '<br>Failed'. mysql_error();

$queryshow = "SELECT * FROM newdbase";
$result2 = mysql_query($queryshow);
$c = count($result2);
echo '<table border ="1">';
echo '<th>Storename</th><th>Sales</th><th>Date</th><th></th>';
if ($c>0)
	{
	while ($a=mysql_fetch_array($result2))
		{
			echo '<tr>';
			echo '<td><a href = "act1.php" ? id = $id></td>;
			echo '<td>'. $a['store'] . '</td>';
			echo '<td>'.  $a['sales'] . '</td>';
			echo '<td>'.  $a['year'] . '-'.$a['month'].'-'.$a['day'].'</td>';
			echo '</tr>';
		}
	}
echo '</table>';
}
?>

php

8 Contributors
21 Replies
117 Views
1 Week Discussion Span
Latest Post 14 Years Ago Latest Post by Stefano Mtangoo

dorien 0 Light Poster

14 Years Ago

What error do you get?

MooGeek 16 Posting Whiz

14 Years Ago

Lol because of this

$id =  $_GET['id']; //you forgot to put the $id = 

	$username = "root";
	$password = '123456';
	$hostname = "localhost";
	$db = mysql_connect($localhost, $username, $password)
	or die ("Unable to connect to mySQL".mysql_error());
	mysql_select_db('mynewdbase');

$del = "DELETE FORM newdbase WHERE id = $id";

$nres = mysql_query("$del);

?>

you should try my site it might help you better :)

FlashCreations 20 Posting Whiz

14 Years Ago

Lol because of this

$id =  $_GET['id']; //you forgot to put the $id = 

	$username = "root";
	$password = '123456';
	$hostname = "localhost";
	$db = mysql_connect($localhost, $username, $password)
	or die ("Unable to connect to mySQL".mysql_error());
	mysql_select_db('mynewdbase');

$del = "DELETE FORM newdbase WHERE id = $id";

$nres = mysql_query("$del);

?>

you should try my site it might help you better :)

It also might be useful to note that once quotes are opened, they must be closed. But in your instance, quotes aren't necessary on this line.

<?php
$id =  $_GET['id']; //you forgot to put the $id = 

	$username = "root";
	$password = '123456';
	$hostname = "localhost";
	$db = mysql_connect($localhost, $username, $password)
	or die ("Unable to connect to mySQL".mysql_error());
	mysql_select_db('mynewdbase');

$del = "DELETE FORM newdbase WHERE id = $id";

$nres = mysql_query($del); //Much better
?>

Stefano Mtangoo 455 Senior Poster

14 Years Ago

DROP tabble_name ;

don't condemn me, that is from heading ;)
Now, seriously PMC have got it!

it200219 0 Light Poster

14 Years Ago

Hi,

Is the issue resolved ? If not, try this code, which will tell you error.

<?php

    $username = "root";
    $password = "123456";    
    $hostname = "localhost";
    $db = mysql_connect($hostname, $username, $password) 
    or die ("Unable to connect to mySQL".mysql_error());
    mysql_select_db('mynewdbase') or die(mysql_error());

    $flag = $_GET['flag'];                        

if($flag==1)                                        
{
$id = $_GET['id'];
$del = "DELETE FROM newdbase WHERE id = '$id'";
$nres = mysql_query($del) or die(mysql_error());


if(!$nres)                                                    
echo " Failed to delete:" . mysql_error();
else
echo " Deleting successful";
}
?>

<HTML>
<BODY>
<form method = "get" action = "act1.php">
Storename:<input type = "text" name = "store"><br>
Sales <input type = "text" name = "sales"><br>
Date  <input type = "text" name = "year" size = "3" value = "<?php echo date('Y'); ?>">
-<input type = "text" name = "month" size = "3" value = "<?php echo date('m'); ?>">
-<input type = "text" name = "day" size = "3" value = "<?php echo date('d'); ?>"><br>
<input type = "submit" name = "submit" value = "Save">
<input type = "reset" name = "clear" value = "Cancel">
</form>
</BODY>
</HTML>

<?php

    $store = $_GET['store'];
    $sales = $_GET['sales'];
    $year = $_GET['year'];
    $month = $_GET['month'];
    $day = $_GET['day'];

$ans = "INSERT INTO newdbase VALUES ('','$store', '$sales', '$year' ,'$month', '$day')";

    $result = mysql_query($ans) or die(mysql_error());

    if($result!='')                                     
    echo '<br>Saving Successful';
    else
    echo '<br>Failed'. mysql_error();

$queryshow = "SELECT * FROM newdbase";
$result2 = mysql_query($queryshow) or die(mysql_error());
$c = count($result2);
echo '<table border ="1">';
echo '<th>Action</th><th>Storename</th><th>Sales</th><th>Date</th>';
if ($c>0)
    {
    while ($a=mysql_fetch_array($result2))
        {
            echo '<tr>';
            echo '<td><a href = "act1.php?id= $id & flag = 1">Delete</a></td>'; 
            echo '<td>'. $a['store'] . '</td>';
            echo '<td>'.  $a['sales'] . '</td>';
            echo '<td>'.  $a['year'] . '-'.$a['month'].'-'.$a['day'].'</td>';
            echo '</tr>';
        }
    }
echo '</table>';

?>

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

slap01 0 Newbie Poster · Answer 1 · 2010-08-29T18:58:58+00:00

i tried those but still i have error., i also tried my new code but everytime i select delete, it adds one more table, how come? here's my code:

<?php

    $username = "root";
    $password = "123456";    
    $hostname = "localhost";
    $db = mysql_connect($hostname, $username, $password)
    or die ("Unable to connect to mySQL".mysql_error());
    mysql_select_db('mynewdbase');

    $flag = $_GET['flag'];                        

if($flag==1)                                        
{
$id = $_GET['id'];
$del = "DELETE FROM newdbase WHERE id = '$id'";
$nres = mysql_query($del);


if(!$nres)                                                    
echo " Failed to delete:" . mysql_error();
else
echo " Deleting successful";
}
?>

<HTML>
<BODY>
<form method = "get" action = "act1.php">
Storename:<input type = "text" name = "store"><br>
Sales <input type = "text" name = "sales"><br>
Date  <input type = "text" name = "year" size = "3" value = "<?php echo date('Y'); ?>">
-<input type = "text" name = "month" size = "3" value = "<?php echo date('m'); ?>">
-<input type = "text" name = "day" size = "3" value = "<?php echo date('d'); ?>"><br>
<input type = "submit" name = "submit" value = "Save">
<input type = "reset" name = "clear" value = "Cancel">
</form>
</BODY>
</HTML>

<?php

    $store = $_GET['store'];
    $sales = $_GET['sales'];
    $year = $_GET['year'];
    $month = $_GET['month'];
    $day = $_GET['day'];

$ans = "INSERT INTO newdbase VALUES ('','$store', '$sales', '$year' ,'$month', '$day')";

    $result = mysql_query($ans);

    if($result!='')                                     
    echo '<br>Saving Successful';
    else
    echo '<br>Failed'. mysql_error();

$queryshow = "SELECT * FROM newdbase";
$result2 = mysql_query($queryshow);
$c = count($result2);
echo '<table border ="1">';
echo '<th>Action</th><th>Storename</th><th>Sales</th><th>Date</th>';
if ($c>0)
    {
    while ($a=mysql_fetch_array($result2))
        {
            echo '<tr>';
            echo '<td><a href = "act1.php?id= $id & flag = 1">Delete</a></td>'; 
            echo '<td>'. $a['store'] . '</td>';
            echo '<td>'.  $a['sales'] . '</td>';
            echo '<td>'.  $a['year'] . '-'.$a['month'].'-'.$a['day'].'</td>';
            echo '</tr>';
        }
    }
echo '</table>';

?>

slap01 0 Newbie Poster · Answer 2 · 2010-08-29T20:19:51+00:00

i think your code is same as mine., anyway, i dont get an error but my problem now is everytime i select delete, it only adds one more table., rather than deleting it

Stefano Mtangoo 455 Senior Poster · Answer 3 · 2010-08-29T20:53:02+00:00

i tried those but still i have error., i also tried my new code but everytime i select delete, it adds one more table, how come? here's my code:

<?php

    $username = "root";
    $password = "123456";    
    $hostname = "localhost";
    $db = mysql_connect($hostname, $username, $password)
    or die ("Unable to connect to mySQL".mysql_error());
    mysql_select_db('mynewdbase');

    $flag = $_GET['flag'];                        

if($flag==1)                                        
{
$id = $_GET['id'];
$del = "DELETE FROM newdbase WHERE id = '$id'";
$nres = mysql_query($del);


if(!$nres)                                                    
echo " Failed to delete:" . mysql_error();
else
echo " Deleting successful";
}
?>

<HTML>
<BODY>
<form method = "get" action = "act1.php">
Storename:<input type = "text" name = "store"><br>
Sales <input type = "text" name = "sales"><br>
Date  <input type = "text" name = "year" size = "3" value = "<?php echo date('Y'); ?>">
-<input type = "text" name = "month" size = "3" value = "<?php echo date('m'); ?>">
-<input type = "text" name = "day" size = "3" value = "<?php echo date('d'); ?>"><br>
<input type = "submit" name = "submit" value = "Save">
<input type = "reset" name = "clear" value = "Cancel">
</form>
</BODY>
</HTML>

<?php

    $store = $_GET['store'];
    $sales = $_GET['sales'];
    $year = $_GET['year'];
    $month = $_GET['month'];
    $day = $_GET['day'];

$ans = "INSERT INTO newdbase VALUES ('','$store', '$sales', '$year' ,'$month', '$day')";

    $result = mysql_query($ans);

    if($result!='')                                     
    echo '<br>Saving Successful';
    else
    echo '<br>Failed'. mysql_error();

$queryshow = "SELECT * FROM newdbase";
$result2 = mysql_query($queryshow);
$c = count($result2);
echo '<table border ="1">';
echo '<th>Action</th><th>Storename</th><th>Sales</th><th>Date</th>';
if ($c>0)
    {
    while ($a=mysql_fetch_array($result2))
        {
            echo '<tr>';
            echo '<td><a href = "act1.php?id= $id & flag = 1">Delete</a></td>'; 
            echo '<td>'. $a['store'] . '</td>';
            echo '<td>'.  $a['sales'] . '</td>';
            echo '<td>'.  $a['year'] . '-'.$a['month'].'-'.$a['day'].'</td>';
            echo '</tr>';
        }
    }
echo '</table>';

?>

Its seems that all the files send action to act1.php. the deciding factor is flag and as I look at your messy code I cannot get it well (honestly). I will advice you to make class and use its object. Here is an example of how you can do that, completely untested

manager.php

class ManageSales{
	private var $conn;
	
	public function __construct(){
		$username = "root";
		$password = "123456";    
		$hostname = "localhost";
		$db = mysql_connect($hostname, $username, $password)
		or die ("Unable to connect to mySQL".mysql_error());
		mysql_select_db('mynewdbase');
		$this->conn = $db;
	
	}
	
	public function deleteData(){
		$id = $_GET['id'];
		$del = "DELETE FROM newdbase WHERE id = '$id'";
		$nres = mysql_query($del);

		if(!$nres){                                                    
			return false;
		}
		else{
			return true;
		}

	}
	
	public function addData(){
			$store = $_GET['store'];
			$sales = $_GET['sales'];
			$year = $_GET['year'];
			$month = $_GET['month'];
			$day = $_GET['day'];
			$ans = "INSERT INTO newdbase VALUES ('','$store', '$sales', '$year' ,'$month', '$day')";
			$result = mysql_query($ans);
			if($result!=0) {
				return true;
			}			
			else{
				return false;
			}
	}

}

acts1.php

include "manager.php"
mgr = new ManageSales();
if($flag==1)  {
	mgr.deleteData()
}
else{
	mgr.addData()
}

Stefano Mtangoo 455 Senior Poster · Answer 4 · 2010-08-29T20:58:46+00:00

BTW that code is for PHP 5.x so if you work with PHP 4 it will need slight modification :)

slap01 0 Newbie Poster · Answer 5 · 2010-08-29T21:38:02+00:00

tnx evstevemd, but im still on the basics :D don't know how to use class yet

Stefano Mtangoo 455 Senior Poster · Answer 6 · 2010-08-29T22:33:48+00:00

Now if that is the case I will advice you to make different actions for delete and add files. That is, make one action on form to add_data.php and another action to delete_data.php

Huakalero 0 Newbie Poster · Answer 7 · 2010-08-29T23:10:13+00:00

Are you trying to delete a table? or some records in it?

slap01 0 Newbie Poster · Answer 8 · 2010-08-29T23:46:05+00:00

@ evstevemd tried that and it works., but i want it on the same page

@ Huakalero i want to delete a table and the values on it

here's my new code:

<?php

    $username = "root";
    $password = "123456";    
    $hostname = "localhost";
    $db = mysql_connect($hostname, $username, $password)
    or die ("Unable to connect to mySQL".mysql_error());
    mysql_select_db('mynewdbase') or die(mysql_error());

    $flag = $_GET['flag'];                        

if($flag=="1")                                        
{
$id = $_GET['id'];
$del = "DELETE FROM newdbase WHERE id = '$id'";
$nres = mysql_query($del);


if(!$nres)                                                    
echo " Failed to delete:" . mysql_error();
else
echo " Deleting successful";
}
?>

<HTML>
<BODY>
<form method = "get" action = "act1.php">
Storename:<input type = "text" name = "store"><br>
Sales <input type = "text" name = "sales"><br>
Date  <input type = "text" name = "month" size = "3" value = "<?php echo date('m'); ?>">
-<input type = "text" name = "day" size = "3" value = "<?php echo date('d'); ?>">
-<input type = "text" name = "year" size = "3" value = "<?php echo date('Y'); ?>"><br>
<input type = "submit" name = "submit" value = "Save">
<input type = "reset" name = "clear" value = "Cancel">
</form>
</BODY>
</HTML>

<?php

    $store = $_GET['store'];
    $sales = $_GET['sales'];
    $year = $_GET['year'];
    $month = $_GET['month'];
    $day = $_GET['day'];

$ans = "INSERT INTO newdbase VALUES ('','$store', '$sales', '$year' ,'$month', '$day')";

    $result = mysql_query($ans);

    if($result!='')                                     
    echo '<br>Saving Successful';
    else
    echo '<br>Failed'. mysql_error();

$queryshow = "SELECT * FROM newdbase";
$result2 = mysql_query($queryshow);
$c = count($result2);
echo '<table border ="1">';
echo '<th>Action</th><th>Storename</th><th>Sales</th><th>Date</th>';
if ($c>0)
    {
    while ($a=mysql_fetch_array($result2))
        {
            echo '<tr>';
            echo "<td><a href = \"act1.php?id=".$a["id"]."&flag=1\" >Delete</a></td>"; 
            echo '<td>'. $a['store'] . '</td>';
            echo '<td>'.  $a['sales'] . '</td>';
            echo '<td>'.  $a['month'] . '-'.$a['day'].'-'.$a['year'].'</td>';
            echo '</tr>';
        }
    }
echo '</table>';

?>

Stefano Mtangoo 455 Senior Poster · Answer 9 · 2010-08-30T01:48:33+00:00

Now I suspect something is wrong with your if..else
Here is my suggestion:
add the files in the comments below

if($flag=="1"){
    //paste code of first file
}
else{
    //paste code for second file
}

Paste two files differently if you will still face errors

Stefano Mtangoo 455 Senior Poster · Answer 10 · 2010-08-30T01:49:47+00:00

@ Huakalero i want to delete a table and the values on it

Just use Drop Table Sql statement. Dropping table destroys data therein too

slap01 0 Newbie Poster · Answer 11 · 2010-08-30T09:32:53+00:00

the code remove the values of my table but my prob now is i dont know how to remove the table (the <tr> and <td>) when i select delete

Stefano Mtangoo 455 Senior Poster · Answer 12 · 2010-08-30T21:04:18+00:00

the code remove the values of my table but my prob now is i dont know how to remove the table (the <tr> and <td>) when i select delete

What do you mean by that?

slap01 0 Newbie Poster · Answer 13 · 2010-08-31T12:42:32+00:00

here's the sample output:

Storename:
Sales
Date - -

Saving Successful
Action Storename Sales Date
Delete slap1 123123.00 8-8-2010
Delete slap2 2123123.00 8-8-2010
Delete slap3 123142.00 8-8-2010

when delete is selected:

Saving Successful
Action Storename Sales Date
Delete slap1 123123.00 8-8-2010
Delete slap2 2123123.00 8-8-2010
Delete 000000.00 0-0-0

the values are deleted but the table still remains

didier_m 0 Newbie Poster · Answer 14 · 2010-09-01T14:01:40+00:00

You have select mynewtable and delete from newtable??? is this correct??

didier_m 0 Newbie Poster · Answer 15 · 2010-09-01T14:02:32+00:00

didier_m 0 Newbie Poster

14 Years Ago

sorry mynewdbase and newdbase

Stefano Mtangoo 455 Senior Poster · Answer 16 · 2010-09-02T23:28:27+00:00

here's the sample output:
Storename:
Sales
Date - -

Saving Successful
Action Storename Sales Date
Delete slap1 123123.00 8-8-2010
Delete slap2 2123123.00 8-8-2010
Delete slap3 123142.00 8-8-2010
when delete is selected:
Saving Successful
Action Storename Sales Date
Delete slap1 123123.00 8-8-2010
Delete slap2 2123123.00 8-8-2010
Delete 000000.00 0-0-0
the values are deleted but the table still remains

mysql_query("DROP TABLE table_name");