Script That Deletes A Row In A Mysql Database Usin

free web hosting
Open Discussion > CONTRIBUTE > Computers > Programming Languages > PHP Programming

Script That Deletes A Row In A Mysql Database Usin

kvarnerexpress
I have just made a script that deletes a row in a mysql database using an image as a button.

However it will only work in FireFox and not in IE.
Can any one see away around this and help me root out the problem.

This is the script in short:
PHP Code:
CODE
$query_products = "SELECT * FROM manufacturer ORDER BY name ASC";
include('external_files/pagination.php');

   // If the form was submitted, delete the items selected from the database
if(isset($_POST['delete'])){

 $query = 'DELETE FROM manufacturer WHERE manufacturer_id = '.(int)$_POST['delete']; // or die() doesn't go here
 $result = mysql_query($query) or print mysql_error();
echo"{$row_products['manufacturer_id']}";
       if ($result) { // If it ran OK.
           echo" <center><font color=\"#00CC00\">The manufacturer was Deleted!</font></center> ";
           $query_products = "SELECT * FROM manufacturer ORDER BY name ASC";
           include('external_files/pagination.php');
       } else { // If it did not run OK.
               // Send a message to the error log, if desired.
               echo"<div class='error'>The manufacturer could not be deleted due to a system error. We apologize for any inconvenience.</div>";
           }        
}?>
<!-- Call your variables -->


and:
PHP Code:
CODE

//.....etc etc
do {     ?><form action="<?php echo $PHP_SELF; ?>" method="post"><?                    
//Open all the items
           echo"
                                   <div class='item'>
                                       <div class='element'>{$row_products['name']}</div>
                                       <div class='element'>00/00/00</div>
                                       <div class='elementprimtool'>";?>
<input type="image" name="delete"
 src="images/delete.jpg"
 value="<?php echo $row_products['manufacturer_id'] ?>" />
<?

 

 

 


Reply

rvalkass
OK, try changing it so that it is all on one line, e.g.

CODE

<input type="image" name="delete" src="images/delete.jpg" value="<?php echo $row_products['manufacturer_id'] ?>" />


You could also try changing the closing tag, so you don't have a slash. Sometimes it can cause problems. I think you also need a ; after that PHP you have in the value attribute.

CODE

<input type="image" name="delete" src="images/delete.jpg" value="<?php echo $row_products['manufacturer_id']; ?>">


Tell us if that helps.

Reply



Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

(Maximum characters: 10,000)
You have characters left.

Similar Topics

Keywords : script, deletes, row, mysql, database, usin

  1. Need Help With Javascript Drag And Drop Script
    Having trouble with javascript drag and drop script. (2)
  2. Mysql Hacks
    (1)
    There are MySQL hacks out there, They can travel from your website to your computers. One of these
    are the MySQL injectors. The injection drops your tables and shuts down the program permanently. Be
    careful of these hacks, as they can destroy your MySQL related websites, programs, etc.....
  3. Java Script To Hide The Url In Address Bar
    Does any one know about this ? (6)
    Hello friends , just now i came accross a particular type of script which is capable of masking the
    URL which is seen in the Address bar of the webpage , that is by implementing the particular Java
    Script when the user visits a page eg. www.mysite.com , then it is possible for the admin of
    www.mysite.com to mask this site and display some other website in the viewers address bar. I came
    to know that such a script can be written using Java Scripts , Can any one get me the Script ??....
  4. Database Normalization
    (0)
    For those of you... who really reall Ok... I am sharing to trap17 an easy to use image file to
    brush up your understanding of database normalization. Everytime I have to understand the concepts,
    I have to go through the complete text and its a little hard to do that... Had some requirement
    recently, and I thought I will prepare something like this and refer to, when there are future
    requirements. This is not exhaustive and very detailed. Helps to get some basic understanding. Prior
    knowledge about the databases, structure will help in understanding the complete concepts....
  5. [request] Avatar For Trap17 Users
    Nice one... for my avatar rotator script (0)
    As per the description above, I would like to challenge the GFX people here on the Trap17 to design
    a nice, bright, clear, professional looking 'avatar' for me and other members to use. I
    plan on including it in my Rotator Script, which I think can be found in the Tutorial Section here
    on the Trap17. (If not, I must write that one soon). /laugh.gif" style="vertical-align:middle"
    emoid=":lol:" border="0" alt="laugh.gif" /> I'm thinking that we need to open this up as a
    Competition so all Members can contribute and then the Admins can start a new section in ....
  6. How To Use A Database For Chess Results?
    How to set-up, configure, and utilize a database to store chess result (0)
    Hi, I'm running a website for our chess club. Recently we decided to add a feature for members
    to simply enter their tourney results there but I do not exactly know how to do it. The first
    problem is how to create form for people to enter their game results. I just have an idea that
    working with drop down menus is faster, esaier and more precise than typing the information. The
    second problem is how to make these results search-able? Let me tell you the final problem which is
    the worst of all that is I do not know how to build a member area. Because Qupis does no....
  7. Creating A Php Login System Using Mysql
    I need help in creating a login system, what I want is a login system (10)
    Hey everyone! I am helping someone make a login system using MySQL databases and a PHP login
    form. I have a fair bit of experiance in HTML and some javascript too. I have virtually no
    experiance in MySQL or PHP. Anybody know of any good PHP login systems that allow you to creat a
    personalised page for each user and when they login the system transfers the user to their page.
    Another thing that the system MUST have is a way of stopping unwanted users entering someones page.
    CODE For example lets say I register and my UN is jesse123 and my personalised pages a....
  8. Mysql Database Not Working
    (3)
    well i'm getting an error message(a databass connection warning) for all of the parts of my site
    that connects to a mysql database i check my database users pertmissions and i try to do the repair
    database thing and it's still not woeking. am i the only person having this or is it an overall
    trap17 issue and how do i fix it.....
  9. Ips Installer Database Details [resolved]
    It wont accept localhost... (6)
    CODE Access denied for user 'skyed211_central'@'localhost' to database
    'skyed211_centralgaming' I get this error message when trying to install my IPB. It will
    not accept localhost, nor mysql. Can I get any help please? I've tried many times to get past
    this part, but it's not happening /sad.gif" style="vertical-align:middle" emoid=":(" border="0"
    alt="sad.gif" />....
  10. The Only Reason I Choose Ms Sql Server Rather Than Mysql
    (0)
    The only reason i choose ms sql server rather than mysql is, MS SQL has more security
    features!! MySQL is lacking a lot in my opinions - Lack in wide char, like nvarchar, I
    developed some application to support chinese letter, and dont know how to build one in mysql - Lack
    in t-sql syntax, like query in query is not fully supported - Does not have today SQL features like
    BI support (today really required) And compare MS SQL to MySQL, the only reason why mysql is
    favourable is - it is free! Dont u guys agree?....
  11. Need Advice On Setting Up Mysql Database.
    I have a huge amount of daily data updates to be inserted. (4)
    First of all, to get the idea of what I am trying to achieve here, please have a look at my
    idea thread, entitled Idea For Using A Cron Job To Grab Daily Travian Map.sql Updates . This gives
    a prelude to the project, what it is for, what it is supposed to do, etc. Now, what I need is
    specific advice on setting up the mySQL database(s) to implement this idea. There is a useful FAQ
    file for how to make use of the map.sql data located on the help.travian.com website, which also
    gives an example of the CREATE TABLE instruction that matches the data in the map.sql fi....
  12. Mysql Db Is Down Getting Following Error
    (2)
    My Mysql is Down can I get some help please? Appreciate it. Patrick Domain: patrickcurl.com Error:
    phpMyAdmin - Error #2002 - The server is not responding (or the local MySQL server's socket is
    not correctly configured)....
  13. Seeking Help With Javascript
    Need help with drag and drop type script (1)
    What i want to make is a script that has a table, which is a menu for my site, and when you click
    the top of the table you can drag it to another place in the page. This is the code: Test
    run - Right click menu - ©Jack McCrea 2008 <script type="text/javascript"> function
    coordinates(event) { if (event.button==2) { var x=event.x; var y=event.y;
    document.getElementById("element").style.left=x; document.getElementById("element").style.top=y;
    document.getElementById("element").style.visibility="visible"; var oldx=x; var oldy=y; } }
    <script type="....
  14. Browser Compatibility Problem With Firefox - Javascript + Css
    Having trouble making a script work right - any suggestions? (3)
    Hi, Im working on a website, and im trying to make a right-click menu, which opens on right click,
    wherever the cursor is, and closes on mouse out. I wrote the code below, and when i ran it in IE it
    ran fine, just how i wanted it to work. However in firefox, the menu just opened in the top left. im
    presuming this is because it doesnt like my style changing in the javascript. Any ideas, and
    suggestions? If i cant make this work, i will just make it so it works slightly differently when
    viewev in firefox so that it can just open in one place. All ideas appreciated. ....
  15. It Went Well For A While
    MySQL problem back in all its glory. (5)
    Some time ago I had a stubborn problem when trying to access one of the interactive pages on my
    website and getting the following error: QUOTE Warning: fopen() : open_basedir restriction in
    effect. File(include/errors.xml) is not within the allowed path(s):
    (/home/mrdee:/usr/lib/php:/usr/local/lib/php:/tmp) in
    /home/mrdee/public_html/admin/include/commonfunctions.php on line 682 Warning:
    fopen(include/errors.xml) : failed to open stream: Operation not permitted in
    /home/mrdee/public_html/admin/include/commonfunctions.php on line 682 Cannot open XML data file:
    incl....
  16. Phpmyadmin
    Create new database: No Privileges (7)
    i can not make a sql for diff srcipt, but the sricpt i have is php, DJ-cpanel.. all tho i can not
    install it the error is like this Creating Database Tables No database selected there a mysql
    database is made, but i can not use it for othere stuff... plz note that this is Free script and not
    for paid.. is there a way that the myqsul can not use sql other scripts? or it maybe not working...
    but i am not sure if the script not working or it can be the server may be down on mysql...? ....
  17. Very Simple Online Now Script
    This is a very simple online now script. (4)
    Hi all, Its Aldo. anyways, I wont be using the method of pagination, i will just tell you how to
    make a basic online now script. When someone logs in, now take into consideration that the name of
    the username input is username ( First ,create a table in your database saying online now and add 2
    fields to it. id and username CODE id type=integer(INT) , auto increment, length =255
    and username = VARCHAR length=the limit a username should be in your site now from there we take
    off : CODE <?php //logged.php //authentication script //connection scri....
  18. Jsp Or Java Chat Script Like Mig33
    (5)
    so most of you guys know mig33. its a wap application,probaly java.most kindly to be java. does
    anyone have java knowlege or knows where i can get a chat script like mig33? i also know this server
    supports jsp so im planing to use it for my application. i was hosted here last year but moved
    because i found a better host. now im back just to use the jsp on this server. Im planing to run
    chat applictions so if any one wants to help me in my project let me know.....
  19. Quick Question
    Is there a limit on the size of the MySQL database? (10)
    Question's in the title!....
  20. Subquery In Mysql
    (5)
    Is there anyway to make subqueries work in MySQL? I'm pretty certain someone out there knows
    how. /smile.gif' border='0' style='vertical-align:middle' alt='smile.gif' /> Can anyone help?
    CODE Select * from ITEMS where ID="Select Max(ID) from ORDERS"; This works
    for MSAccess and SQL Server but why not in MySQL? I'll be writing some reports and I've
    shifted database from MSAccess to MySQL. Help! Thanks.....
  21. Connect To Remote Oracle Database With Toad
    i'm lost (7)
    Hey gang, long time no see, my bad! Anyway, I got me a question. Does anybody know how to
    connect to a remote oracle database using toad? When I read the docs for toad I get the impression
    that I have to have a local oracle installation in order to use toad, but that just seems silly. I
    guess I'm stuck at the point of trying to figure out how to tell toad where to look for all of
    the configuration information it needs for the connection if I don't have any "Oracle Home"
    directories. :crosses fingers: Peace!....
  22. Verifying Email Addresses
    Using a simple PHP script (9)
    This simple script will allow you to run some basic checks to make sure that any email address
    entered is actually an email address. There is no guarantee offered that this will stop every single
    fake email address, but it'll provide some protection. Now, the code! First we need to get
    the email address to verify. Here, I get it using POST from an HTML form. CODE <?php //Load
    email address from web form $email = $_POST['email']; Now, we move on
    to our first check. Does the text that has been entered look like it could b....
  23. Mysql Database Size
    related to the free database space (7)
    hi all! this is my first post /biggrin.gif' border='0' style='vertical-align:middle'
    alt='biggrin.gif' /> and i have a doubt, how much mysql space i am allowed to use... i mean how
    much is available for my free account....
  24. Delay X Seconds In Flash
    how to action script that (1)
    How do i have to do, to tell a frame to wait x seconds after it continues playing? In Macromedia
    Flash, of course... Like: CODE stop(); "wait  x seconds"; play();
    Thanks....
  25. Import From Excel File Into Mysql Database
    (11)
    Has anyone tried using the excel import function that comes with phpmyadmin
    http://www.phpmyadmin.net/home_page/ - it does not require any additional plug-ins or scripts and
    is fairly straightforward to use. In phpmyadmin, if you click on the database table which you wish
    to import the data to , there is a link on the bottom left corner which says "insert data from a
    text file into the table" - although it says text file it still can be used to import an excel file.
    When you click on this link you will be taken to a page where you will be asked for the file name
    (the....
  26. Increment A Mysql Column
    how to increment a MySQL column one unit (7)
    Hi, I have a column in a MySQL table which contains a counter of the views of the object described
    by this table. I would like to increment this value by one everytime the object is viewed. Obviously
    came into my mind the possibility of retrieving the value of this field, store it in a variable
    increment this value by one and perform an UPDATE query again with this new value. My question is if
    there is a MySQL option to update the field with its actual value plus an unit increment. I hope you
    understand the issue.....
  27. Web Surfing- Script Needed
    (2)
    We all know of anonymouse web surfing, Sites like http://anonymouse.ws/cgi-bin/anon-www.cgi Offer
    peope to surf the internet anonymousely, The site has baners and ads showing up and does not support
    all links. Does anyone know what script they use or where i could get one from, What script do they
    use? Also if anyone jnows how to make my own? I really want this as a addon for my site, So all help
    would be appriciated. Thanks, Mbd5882....
  28. [help] Java Script: Window.open
    Works with Firefox, not IE (10)
    CODE <HEAD> var popUpWin=0; function popUpWindow(URLStr) {
     if(popUpWin)  {    if(!popUpWin.closed) popUpWin.close();  }
     popUpWin = open(URLStr, 'GunBound Tactics: Screenshots',
    'width=820,height=550,menubar=no,resizable=yes,scrollbars=yes,toolbar=no,top=90,left=90')
    ;; } </HEAD> <BODY> <a
    href="javascript:popUpWindow('/f11/clipped.php');"><b>Clips&
    #60;/b></a> This is a script for opening a new window. It works ....
  29. Many Php Script Sites
    (16)
    Hi I find many sites has PHP scripts :: http://www.proxy2.de/scripts.php http://www.free-php.net
    http://knubbe.t35.com/ http://www.ngcoders.com/ http://www.oxyscripts.com/
    http://www.phparena.net/ http://www.1phpstreet.com/ http://px.sklar.com/
    http://www.scoznet.com/ http://php.resourceindex.com/ /blink.gif' border='0'
    style='vertical-align:middle' alt='blink.gif' /> ....
  30. Mysql Database Setup : Setting Up Mysql Database
    Guide to use MySQL database in your site (6)
    A SMALL INTRODUCTION TO DATABASE ============================= I have seen that many members have
    problems with Database. Here is a small INFO which should give you the IDEA. mySQL is a DATABASE
    server. You can access it using the link in Cpanel. Cpanel can be accessed by
    "www.YOUR-SITE.com/Cpanel" There you have 4 Main Options :- 1> CREATE A DATABASE 2> CREATE A USER
    3> ADD USER TO DATABASE 4> PHPMYADMIN CREATE : IT ALLOWS YOU TO CREATE A DATABASE CREATE USER
    : IT ALLOWS YOU TO CREATE A USER. USING THIS, YOU CAN ACCESS THE DATABASE. A DATABASE CANNOT BE....

    1. Looking for script, deletes, row, mysql, database, usin

*RANDOM STUFF*





*SIMILAR VIDEOS*
Searching Video's for script, deletes, row, mysql, database, usin

*MORE FROM TRAP17.COM*
Similar
Need Help With Javascript Drag And Drop Script - Having trouble with javascript drag and drop script.
Mysql Hacks
Java Script To Hide The Url In Address Bar - Does any one know about this ?
Database Normalization
[request] Avatar For Trap17 Users - Nice one... for my avatar rotator script
How To Use A Database For Chess Results? - How to set-up, configure, and utilize a database to store chess result
Creating A Php Login System Using Mysql - I need help in creating a login system, what I want is a login system
Mysql Database Not Working
Ips Installer Database Details [resolved] - It wont accept localhost...
The Only Reason I Choose Ms Sql Server Rather Than Mysql
Need Advice On Setting Up Mysql Database. - I have a huge amount of daily data updates to be inserted.
Mysql Db Is Down Getting Following Error
Seeking Help With Javascript - Need help with drag and drop type script
Browser Compatibility Problem With Firefox - Javascript + Css - Having trouble making a script work right - any suggestions?
It Went Well For A While - MySQL problem back in all its glory.
Phpmyadmin - Create new database: No Privileges
Very Simple Online Now Script - This is a very simple online now script.
Jsp Or Java Chat Script Like Mig33
Quick Question - Is there a limit on the size of the MySQL database?
Subquery In Mysql
Connect To Remote Oracle Database With Toad - i'm lost
Verifying Email Addresses - Using a simple PHP script
Mysql Database Size - related to the free database space
Delay X Seconds In Flash - how to action script that
Import From Excel File Into Mysql Database
Increment A Mysql Column - how to increment a MySQL column one unit
Web Surfing- Script Needed
[help] Java Script: Window.open - Works with Firefox, not IE
Many Php Script Sites
Mysql Database Setup : Setting Up Mysql Database - Guide to use MySQL database in your site
advertisement



Script That Deletes A Row In A Mysql Database Usin



 

 

 

 

ADD REPLY / Got an Opinion! a humble request :-) RAPID SEARCH! Free Hosting [X]
Express your Opinions, Thoughts or Contribute your information that might help someone here.
Ask your Doubts & Queries to get answers.. "Together, We enlight each other!"
Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.
500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE