Click Link To Delete Record
I am trying to add a function to one of my scripts. I would like to be able to click a link and have it delete a particular row from by DB. Links are generated by a PHP script and are based on entries on a DB. In this DB I have a column called 'users'. The table is generated by the following snippet: Code:
View Complete Forum Thread with Replies
Related Forum Messages:
Delete Record - When The Delete Link Is Clicked The Next Page Is Blank And Nothing Is Deleted.
This is my "delete.php" and this "todo/delete.php?id=64" an example of a link to it generated from the index.php page. When the delete link is clicked the next page is blank and nothing is deleted. What have I done wrong? <? include("dbinfo.inc.php"); mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $id="delete from todo where id='$id'"; mysql_query($id); mysql_close(); ?>
View Replies !
Click Counter - How Many People Click That Link?
I have a link on my website and would be very interested to find out how many people click that link. Does anyone know any free click counter scripts? I dont mind if these use a database or not - maybe a simple incremental counter script would be fine. One thing is that I would much prefer it if the number of clicks is not shown on the actual webpage with the link on (not very proffestional). Perhaps on another webpage of my designation.
View Replies !
Find New Record On Click
I want to make a next and a previous link with my data. here is my query: <?php $sql = "SELECT DISTINCT pdp.PackageId, p.PackageType FROM productpackaging pdp, packaging p WHERE pdp.ProductId =2 AND pdp.PackageId = p.PackageId"; $result = mysql_query($sql); How do I write the code to get next or get previous??
View Replies !
Link Click In Php
i have a mysql table which contains client details. fields are as follows 1.name 2.mailid 3.sendmail 4.status 1.abc 2.abc@yahoo.com 3.send 4.not updated 1.xyz 2.xyz@hotmail.com 3.send 4.not updated send' is the link and when i click on it, it opens a email form to send mail to abc@yahoo.com or xyz@hotmail.com.i want to know how i can select the mailid from db when i click on 'send' link and print it on email form.
View Replies !
Link Click Detection?
How might one detect if someone clicked on a hyperkink at your website, so it can be logged in a database? This would have to be done before the browser redirects.
View Replies !
Link Click Count
how to do when anyone click image link, no of click count update to mysql. And prevent update click count twice when anyone press F5. I try to use $_SESSION['hear'] = false but it won't help.
View Replies !
Detecting A Link Click
I am working on an article manager. For that i now need to work on add and view comment part to the article. In case of form system, we have submit button with a value which is checked using [php]isset($_POST['done'] && strlen($_POST['done'])>0)[/php] and so on... Now is there any way i can detect/check if the user has pressed the link (say link to comment.php or showcomment.php). And if he has pressed then i would show the comments or give him a comment box accordingly on the current page.
View Replies !
Simulate Link Click
I'm doing a PHP fopen on a URL link in order to read the contents of the page and "scrape" off the information I need. However, as part of the page,they have a link for the next 20 results as follows: <a href="javascript:__doPostBack('MegaGrid$_ctl24$_ctl1','')">Next 20</a> Is there a way in my PHP code to simulate clicking that link AND getting the results back. I can't just reopen the URL because the URL doesn't change after clicking the link.
View Replies !
Print Each 'value' On Every Click Of A Link.
*hola7even*, i'm new to arrays => anyone who can help with this. <?php $var = array('one', 'two', 'three'); foreach($var as $key => $value){ if($_GET['click']){ print 'value:'.$value; } } ?> # i need to print each 'value' on every click of a link. e.g onfirst click => prints 'one' onsecond click => prints 'two' onthird click => prints 'three'
View Replies !
Outbound Link Click Tracking
Does anyone know of any tutorials on how to write a script that will allow me to track clicks of outbound links on my site? Or any advice on the best way to do this? Ideally I'd like to have a record written into a database each time an outbound link is clicked. I'd like to then be ablt to query the database and pull a report that shows the number of times each link was clicked during a time period.
View Replies !
Unlinking File After Click On Link
I run a script that zips some files, after it's been zipped the client get the link to the file so that he can download it. I want to unlink the zipped file after the client has clicked on the link. This sounds easy but I don't know how to perform an action from a link ie. <a href = ../path_to_zipped_file/zipped_file.zip>download here</a> After they click that link I want to unlink ../path_to_zipped_file/zipped_file.zip any ideas?
View Replies !
Selecting Mail-id After Link Click
i have a mysql table which contains client details. fields are as follows 1.name 2.mailid 3.sendmail 4.status 1.abc 2.abc@yahoo.com 3.send 4.not updated 1.xyz 2.xyz@hotmail.com 3.send 4.not updated here 'send' is the link and when i click on it, it opens a email form to send mail to abc@yahoo.com or xyz@hotmail.com.i want to know how i can select the mailid from db when i click on 'send' link and print it on email form and i should send mail to that mail id.after sending mail to a person here 'status' should be updated.
View Replies !
Redirect Page Click A Link
I have page1.php. Click a link on it and it goes to redirect.php. This uses a redirect to page3.php. If I click the Back button in my browser when on page3.php, will I go back to redirect.php and therefore be sent to page3.php again? Or will I go to page1.php?
View Replies !
Send Mail On Link Click
if a user forgets his password, i want to provide a link from where a dialog box will appear, telling the user that his password has been sent to his mail address and at the same time should sent a mail.
View Replies !
New Window - Click A Link Within A Frame
I want to make it so that when they click a link within a frame, it doesn't open within the frame, but rather in a new window. If you cared to explain to me the how to's of having that new window be a certain size and/or have certain attributes, that would be swell as well.
View Replies !
Changing Variable String Value On A Link Click
Hi... I'm trying to change the value of my $cat variable when someone clicks on a link that consists of an image and some next I'm not sure how to do this... but I think I need some javascript as well so if $cat="Main" and a certain link is clicked I want $cat="Something else"
View Replies !
Click Counter :: How Many Times Link Clicked
Anyone know about a script/code that count how many times a link have been clicked.. I have tried hotscripts.com, phpbank.net and so on.. Only found scripts that costs money or uses a MySQL database. I need one with no needs for MySQL. It should look like something like this: [ Download ] Been downloaded (NUMBER) times.Anyone know about a simple script to do that?
View Replies !
Able To Click On A Link That Will Bring Them To An External Site
I want people to be able to click on a link that will bring them to an external site, and if they hit the Back button in the browser it will bring them to a different site not the one they were previously on. So lets say someone clicks on a sponsor link in my site, and then they hit the back button, it will bring them to a Thank you for visiting my sponsor page, and then it will automaticly redirect to the main page or somthing.
View Replies !
Click Counter - Keeping Link Intact
I’ve searched the net and found various click counters (counts how many times a link has been clicked). I want to use it so that people can see how many times a tutorial has been viewed. But there is one problem: until now, all use a modified link to count the clicks. So instead of the good old: ../tutorials/key_movement.html you get http://mywebsite.com/counter.php?Xrl..._movement.html etc. some even want you to completely change the link. Does anyone know a way to get those clicks counted without changing the links? I don’t mind to use database for this. If there isn’t a way of doing this without changing the links just tell me so. If so, what do you suggest?
View Replies !
A Link In An Email That, On Click, Sends The Headerinfo To A Server
Is it posible to make a link (to a php-file on a server) in an email that, when you click on it, sends info about who the reciver of the email is? Lets say I send out an email thru an alias to a group of people and I want to give them the opportunity to sign up for an event using that link. Those that click the link are added to a post in a database (MySQL), eg. with their email adress, initials, name... whatever. I guess that it would be easy if it just takes the contest of the to-field in the emails headerinfo? If a spammer can do it, so can I :o) And... if you have an answer please assume that I know practicly nothing about php :o) I have made a few sites with php and MySQL, but nothing fancy - just simple guestbooks etc.
View Replies !
Delete Record
i have this code for my site that will connect to my database and grab all my members there id email and ip the problem is that it dont have a button where you can select a member and delete that member can anyone help me with this?i want to add a button and a check box so if i check off a member and click a delete button it will delete that member here is the code:
View Replies !
Delete Record!
I am using PHP5 , MySQL5, Apache 2 My Database was created with phpmyAdmin.Then I inserted with script and phpmyAdmin data into the Database. Now I am Unable to empty or delete or remove any fields out of the Database. Neither a script ot phpmyAdmin can delete.What has blocked the database? I have restarted my pc, Still I am unable to remove anything.
View Replies !
Alphabetizing A List Of Links - Click A Link And It's Not Alphabetized Anymore??
I am editing a site, I didn't make it, and I have a list of links created from a mysql db. I am sending the info from mysql in asc order, but this only works the first time the page comes up. If you click on a link in the list, it appears to revert back to being ordered by the date entered and stays that way through subsequent clicks. A point in the right direction on how to make my list stay alphabetized would be very good.
View Replies !
Set A Cookie That Change The Visitor's File Extension Upon Click On A Link
I'm trying to do this for some days now but still not getting somewhere. I want to set a cookie that change the visitor's file extension upon click on a link, ex. Link1: index.1.php Link2: index.2.php Link3: index.3.php ... Now lets say that you are click on Link1 and the cookie is placed, and then click on a second link, lets say default.php; now i want the default file get the extension .1.php rather than .php, and so on. When a cookie is set all the following files get the specified extension.
View Replies !
Delete Record And Files
I have a code that uploads images along with some info into a directory and database, this all works fine. I can delete the record but the images relevent to that record continue to exsist in my images directory. How would i set up a php code to delete a file in ../images when the record of its name is stored in a column in my database. Here is my delete record code:
View Replies !
Mysql Delete Record
when I run this code below it doesn't delete the record or display any error message $id = $_GET['id']; include("../dbconnect.php"); mysql_query("DELETE FROM promotions WHERE id='$id'") or die(mysql_error()); Such a simple thing to do but I don't no why it doesn't work
View Replies !
Unable To Delete A Record Using Php
I am having a form which displays a couple of values from database and a delete button which is used to delete that particular record. Below is the code that I am using, but I am unable to delete the record. Please help me to get the record deleted. Code:
View Replies !
Confirmation When Delete A Record
I want to add a confirmation before I delete a record. For example if the user wants to delete they press "Yes" otherwise "NO" and go back. <?php //delete user $sSQL = "DELETE FROM user WHERE (`userid` = ".$_GET['record_id'].")"; $result = mysql_query($sSQL) or die(mysql_error()); echo "<h1> User deleted succesfully</h1><br>"; ?>
View Replies !
Delete Record - You Have An Error In Your SQL Syntax;
Im some having trouble with deleting a record, surely it isnt that hard, dont know what im doing wrong. this is the error i am gettin: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '` WHERE id=1' at line 1Here is my delete code:
View Replies !
Delete Record If Older Than 5 Minutes?
Can someone help me in writing a query command, to delete a record, if the last_update field on a record is older than 5 minutes? My table has a last_update field, which holds a value as this for example: 2007-04-08 01:33:12 I need a query that when I access a php file, if a record is older than 5 minutes, it will delete it.
View Replies !
Dreamweaver Generated Code To Delete Record
I use the dreamweaver generated code to delete a record, how would i add some code to it to delete the files (images) stored in my../images folder, that are linked to the record being deleted, there field names are photo1, photo2, ect..... and there image names are stored in the database Code:
View Replies !
Auto Delete Record/Send Email After X Hours
What I have is a MySQL database which stores records that each have a date stamp on them (2 of them - one for record created date and one for record last updated date), what I want to do is try and have it so that records that haven't been updated in say 72 hours are automatically removed from the database, or the record is updated to set a flag as being out of date, or an email is sent to alert a user of the out of date record etc. I can easily write the script with the SQL query to check the records by the datestamp and perform the actions needed if the records are out of date, however that requires someone to physically visit that page to run the script and clean up the out dated records. What I want to try and do is have this happen automatically on its own without someone needing to actually visit the page to run the script. A good example is on eBay how emails are sent to you to let you know when your auctions are about to expire, i wouldnt imagine that eBay would rely on people visiting their website to make those queries run on the database so there must be a way of doing some automated script executio or having a scheduled task run on the server to have a PHP script run each day at midnight or something? Anyone know how to do this?
View Replies !
Mailing A Direct Link To A Record
I have an ordering system. When someone submits an order request it sends an e-mail to the purchasers which contains the item information and a link to manage the order our intranet site. The problem is the link is just a general like such as http://intranet/orders What I would like to do is link directly to the item record itself. Is it possible to include a direct link to the record in the e-mail?
View Replies !
Delete Link Using Product Id
I'm building a site where the I can add and edit the products that are in mysql. I am trying to add a dynamic product id for each "delete" link. So instead of having a hard code of: Code:
View Replies !
Looking For A PHP Script That Will Call A Link By Record Number
I am looking for a script, or at least the logic behind this if anyone can help me. I keep my website records/links in mysql database. Curretly, I display them as is, being if you mouse over the link, the actual link can be seen. What I want to do is, have just the record number included in the link where the link can not been seen when you mouseover. When the link is clicked, a PHP script will go to that record number, extract the link from the record, and open a window to the link. Is there an avaiable script out there to do this? If not what steps are need to accompish this?
View Replies !
Create A Link To Delete An Image?
I'm making a really simple cms, but having problem deleting images. I've managed to create a page to upload the images to a folder. I also have a page that shows all the images and file names. Now I'm trying to add a link to delete images, but I can't get it to work. First of all I don't know what to put in the href tag...? Someone said I should create a new page that deletes the image and then redirects you back to the page displaying the images...? Code:
View Replies !
Script Repeat Updates The Record And Also Inserts Another Record With The Same Information.
I have a form which contains some fields that are populated with data from a table. This same form also has fields that are empty because the data has not been collected yet. The main table is called client with a primary key of client_id. What I need to do with this form is select the client and update the record into a new table with the missing information. If the client doesn't not exist in this second table, I need to insert the row otherwise if the client does exist in this table because of a previous update, update the record. When I run my script, the insert works. When I try to run the script again and try to update the record, the script not only updates the record but also inserts another record with the same information. How can I write my script so it checks whether a client exists in a table and if it does, update the record and if the client does not exist in the table, add the client?
View Replies !
Compare Record With Session Variable And Update Record If Different
I'm trying to figure out how to create a session variable from a recordset field value in a mySQL database and compare this with subsequent values from the same field each time the page reloads. When the value of the field changes (as a result of a user update) I want to trigger an event (redirecting to another page). It's probably a very basic PHP function but I am a newbie with this language.
View Replies !
Mysql Delete - $query = Mysql_query("DELETE
how would i do the following ? $query = mysql_query("DELETE notes, datestamp, abs_value, ID FROM absence_mgt WHERE datestamp='$date' AND ID='$vtc_login' ") or die(mysql_error()); im just getting "Unknown table 'notes' in MULTI DELETE" ?
View Replies !
Using Preg_match_all To Locate HTML Anchor Link BUT Only If The Link Is A .pdf File
The subject line describes what I'm trying to do, (and after thinking about it for a day or so and trying different things; searching around for similar questions on the board,) but I still haven't found a proper regular expression. I am trying to use preg_match_all to locate HTML Anchor link BUT only if the link is a .pdf file within text from a database table. It actually was working just fine until I recently made a change regarding new lines () and (<br />) in the text that is to be searched. But after making changes regarding the new lines and things, my previous regexp doesn't work correctly. Here is the regexp I am trying to use: preg_match_all('/<a href="(.*)">(.*)</a>/U', $entry->Record['e_entry'], $res_output, PREG_PATTERN_ORDER); That regexp does find each occurance of an <a href="">something here</a> link... but I need it to only find occurances of an anchor link if it is a PDF file link (ex: <a href="../something.pdf">something</a>). So I tried changing the regexp to something like this: preg_match_all('/<a href="(.*).pdf">(.*)</a>/U', $entry->Record['e_entry'], $res_output, PREG_PATTERN_ORDER); But in the preg_match_all results array ($res_output) a regular <a href="">something here</a> link is ALSO found as well as the .pdf links... I am trying to only find links that contain .pdf at the end of the file name. Sorry that this is written kind of strangely, if you need more info let me know. Does anyone know what I need to change in the regexp to ONLY find HTML anchor links that contain .pdf at the end of the HREF?
View Replies !
|
TRACKER
