This topic is locked

New Button with MySQL Commands

11/18/2008 12:25:19 PM
PHPRunner General questions
T
taumic author

Hallo,

I am a PHPR-beginner and this is my first question to the forum. Till now I work with the"try and error" principle <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=10193&image=1&table=forumtopics' class='bbc_emoticon' alt=';)' />
I want to add a button on the list page, called "Del NEW". If someone click this button the following mysql-command should be run:
=================================

use cobs_master ;

delete from cobsconfig where mandant = "NEU" ;

=================================
Please explain it very simple, so I can comprehend the activity
Thank you in advance!
Mike
---------------------------

PHPRunner V. 5.0 (587)
Hallo,

I have try the following (from other examples of the forum):
I want to create a button on the list page in HTML mode on the Visual Editor tab
[codebox]{BEGIN mt_del_link}<SPAN class=buttonborder><INPUT class=button onclick="window.location.href='cobsconfig_list.php?editid1={$show_key1}&amp;mt_del=yes';" type=button value="Del NEU"></SPAN>{END mt_del_link}[/codebox]
Then I put the following code in the List page: Before process eventon the Events tab to delete the data sets:
[codebox]if ($_REQUEST["mt_del"]=="yes")

{

global $conn;

$strDel = "delete from cobsconfig where mandant = 'NEU'" ;

db_exec($strDel.$conn);

}[/codebox]
The result is knockdown! When I compiling and running my programm I not even can see the button ?!

What is wrong - can anybody help ?
I have tried many other examples from the forum - but anywhere is a worm inside.
Thank you
Mike

J
Jane 11/19/2008

Hi,
try to use following code:

<SPAN class=buttonborder><INPUT class=button onclick="window.location.href='cobsconfig_list.php?editid1={$show_key1}&mt_del=yes';" type=button value="Del NEU"></SPAN>

T
taumic author 11/19/2008

Hi,

try to use following code:


Hi Jane,
wow ! It works perfect !

Many thanks for your help!
Mike