hi all,
i am manoj i have a problem with my project ,i need a code to update a mysql query when the browser is automatically closed (in php).kindly suggest me its important for me
thank u ..manoj
3 2658 ronnil 134
Recognized Expert New Member
autmatically closed, as in some function you created forces the window to close?
in that case you would probably want to use AJAX to connect to a php file and execute the query.
bear in mind that PHP is a serverside language, meaning php has no knowledge of what you might do with/in your browser.
autmatically closed, as in some function you created forces the window to close?
in that case you would probably want to use AJAX to connect to a php file and execute the query.
bear in mind that PHP is a serverside language, meaning php has no knowledge of what you might do with/in your browser.
hi ronnil thanks for the reply ,i need to know weather is it possible using java script or not & need a small help from u that i have no knowledge about ajax so if possible can u send me the code to be used in php...
thank u ..
ronnil 134
Recognized Expert New Member
the php code would merely be:
<?php
$sql = "UPDATE sometable set somerow=someval ue";
//your sql query
?>
check out the link in the prior post, it gives you enough knowledge to use AJAX, if you're afraid of learning a new language... don't worry, it's just a way to use implemented functions of javascript :)
I don't think you can make up a proper working solution with javascript. You would need to use an event called onclose event, which ain't there as far as i know.
If this window is opened by another window you control, you can in the opener however make a loop checking if the window is open, when it's not no more, perform the query (using AJAX ;))
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Jonathan |
last post by:
I am trying to upload a new version of a file that already exists on my web
site. It asks me to overwrite and I choose yes. But when I go to the web
page, even a half hour after the upload, the orginal content of the page is
still there. I have tried uplaoding several times in IE and FTP voyager.
There are no errors reported during the upload. FTP voyer is using binary
upload for sure.
Also, I deleted the file I am trying to update on...
|
by: Spark |
last post by:
Hi,
Situation:
Need a query to return number of ticket records by month of open in a
log table where the ticket open record is older than 24 hours then the
ticket pending or ticket closed record. Tickets can also only have a
closed record with no open record.
Sample data table:
ticket_id date_log status_name status_id
|
by: ced |
last post by:
Hallo,
I have some JS which creates a new 2-frame window.
The new window (via onLoad) backfills a variable
in the parent window so I'll know when it's safe
to load the target frame.
The problem is that no matter what kind of delay
I set (1 or more seconds), trying to update the
new frame always generates a 'newwin no properties'
|
by: Dave Hitt |
last post by:
I'm trying to put a function into a query. I want to check the
logical field "closed." If it's true, I want to return a text value
of "Closed". If false, I want to return a text value of "Not Yet."
Here's the value in the query:
Expr1: IF(,"Closed","Not Yet")
It accepts it without an error message, but when I try to display it I
get the error message "Undefined Function IF in expression." I've
|
by: Haydnw |
last post by:
Hi,
I have the code below as code-behind for a page which displays two images.
My problem is with the second bit of code, commented as " 'Portfolio image
section". Basically, the SQL query gets details of a random image from an
access database. I know this works because when I run the query in access,
it picks a different image each time (or close enough). However, when I view
the .aspx page that this code-behind is for, it always picks...
| |
by: stuart.medlin |
last post by:
I have an Access 97 application that has a basic form (Transcript) and
subform. The subform has a query as a recordsource that returns
records from a table:
SELECT DISTINCTROW Transcript.NCID, Transcript.TransCode,
Transcript.TransMM, Transcript.TransYY, Transcript.DateKeyed,
Transcript.UserID
FROM Transcript
WHERE datekeyed >= begindate() and datekeyed < enddate()
ORDER BY datekeyed;
|
by: rdemyan via AccessMonster.com |
last post by:
I have a need to add another field to all of my tables (over 150). Not data,
but an actual field.
Can I code this somehow. So the code presumabley would loop through all the
tables, open each table in design mode and then add the new field and set its
properties.
Thanks.
--
|
by: Gouri.Mahajan7 |
last post by:
Hello,
I am new to asp.net. Can anybody please tell me which event
is fired when we close the browser. I want to
remove some resources when the browser close button is pressed.
Thanks in advance.
Regards,
Gouri.
|
by: webster5u |
last post by:
Miss/Mr. Programmer,
I have a idea to remove the cookie value from a website after all browser closed. It is like session kept in server and eliminate after all browser closed. My purpose is reducing browsing security issue through minimize the data resident in the cookie.
The reason i using the cookie instead of session because I used cookie in applying SSO (Single Sign On) for different web application server instead of single server.
...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| |
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |