Real Time Form Update
i have a script that i wrote for my clan/guild/linkshell in this online game i play that keeps track of members, the points they receive from events, items etc. in the admin panel of the script where you can update peoples points i want to know if i can add a button or something similar that if you push it updates the points which is currently in another text box in the same form in real time.
I'm sorry if i'm not being clear, what i'm trying to do it make it quicker to update a members points because usually after each event they receive either 10 or 20 so i want to add a button where if you push it then it will put 10 or 20 in the 'add' box in real time. right now when you edit a member it shows their current points in a text box and under that two text boxes, one if you want to add points and another if you want to subtract points.
if this isnt possible then i assume that i'd have to make it update the points in the box and keep all the values from before and just reload the page with the new value inside the box. wow, i'm sorry if i'm not very clear, please ask questions if you dont understand what i'm trying to say.
View Complete Forum Thread with Replies
Related Forum Messages:
Real Time Listbox Update
I have one listbox that I populate with while($row = mysql_fetch_array($result, MYSQL_ASSOC) I need to in real time populate another listbox from a related table based on what they have currently selected in the first listbox. Is this possible with php and if so.
View Replies !
Db Update And Real Time Update
i wanted to put together my first pages using prototype but i'm kinda stuck. situation: i got a list of pages in the backoffice. in the list you got pagenames, id's, editors and if they're active or not. the active part part is represented by an in/active image. now instead of having to edit the page and change a checkbox to toggle the active status of the page, i was planning to make it able to click on the image in the list itself to toggle the status of the page. thus updating the db when you clicked and refresh the list using ajax. Code:
View Replies !
Real-time Output?
I'm a relative PHP newbie, so I apologize if this is a simple question. Anyway, here's my problem. I'm using a PHP script to pre-render a bunchload of insert files for an HTML page. Right now there's about 1,600, but that number could get much, much higher when the site goes live. I'll only need to re-render the whole batch once or twice a year (if that) but it's still something I'd like to be able to do in case I have to move the site to a different server, or there's a hard drive crash or etc. Basically what the script does is grab a whole bunch of information from a database and write the insert file. It does this for every single one. The problem of course, is that PHP by default does all this server-side, and then sends it to the browser. Because this process takes like ten or twenty minutes to do, the browser times out long before it's finished. Is there a way to get progressive output with PHP? Or do I need to re-do this in another language like Perl?
View Replies !
Real Time Chat
There's anyone out there that can give me a light on real time chat using sockets. I've seen some using push technics but they all hang up after an elapsed amount of time.
View Replies !
Real-time Clock
Where should I start to write a Real-time Clock? I want it be dynamic, not static. I know how to get the time and display it but how do I keep changing it ?
View Replies !
Real-time Chat
I wrote a PHP chat system similar to gChat which simply uses constant ajax calls to update the chat. This system is fine for a few users, but with potentially thousands of users, it is much too hard on the server. I've been considering taking the 'Comet' route, but have heard that PHP can't handle Comet very well. What would be the best language/API to perform real-time chat for a large user-base?
View Replies !
Real Time Sql Query
I am making a web-based chat but to get the msg from the database i need to refresh the page and that will make load and extra bandwidth on the server so i want to make the query in real time ( only the new msg to be received without refresh the whole page ), Any one in here knows how to get data from sql database without having to refresh page.
View Replies !
Real Time Echo'ing Of Var In A Loop
i have a big loop, and rather then waiting until its done for me too see what happened, every time it runs, how can i get the browser to echo the result, and proceed to keep running the loop. basically this loop takes a long time to finish, and i had to set my max runtime past 30 seconds. i guess incorporating a refresh of some sort like this would eliminate the need for the time extension too?
View Replies !
Real-time Action Ala Games??
What would be a proper solution for automated decision making in a PHP script, like a game? That is, without an external application, or any human input. For example, any random event that happens when the player is away from the game. How would one go about implementing that?
View Replies !
Read Data From MS Access Into MySQL In Real-time
I am currently working on a project that involves reading information from a inventory system into Access via ODBC and display the info on the web site using MySQL. I would like to create a live link between the MS Access(local) and MySQL (remote) whenever the inventory system is updated MySQL will be updated as well. I know that MyODBC will let me do the opposite of what I would like to accomplish by reading data in MySQL into Access. Is it possible to do the reverse way.
View Replies !
How Can One Get Real Time Stock Quotes For An Online-community?
For one of our web-communities we plan an offer of real time stock quotes incl. advanced notification services. I have the following questions: - Do you know of any services, that already offers such services in a decent way? And more important: - Does anybody know a provider of such services, that offers a real-time stock quote data stream for such a usage at a decent price? I only know of Deutsche Börse offering it for 1駨 Euro per month. That is too expensive for us.
View Replies !
A Real Challenge For Real PHP Programmers
<?php /* A challenge to every PHP programmer.The one who's gonna solve this problem would be deemed as PSP(PHP Supreme Programmer).The problem is this : You have to write a script that displays a list of categories and subcategorieslike this one: <select name="category"> <option value="1">Main</option> <option value="2">Main > Computers</option> <option value="4">Main > Computers > Hardware </option> <option value="8">Main > Computers > Hardware > PC</option> <option value="7">Main > Computers > Hardware > Mac</option> <option value="9">Main > Computers > Hardware > Atari</option> <option value="11">Main > Computers > Hardware > PC > History of Pc</option> <option value="">etc...</option> </select> The categories and subcategories details are stored in these two tables in a MySQL database. -categories : the categories names and ids. -cat_relations : the relations between categories.It shows which subcategory belongs to which category. The belongings between categories can go very deep and the number of categories is unlimited. This script will create the two tables and fill them with sample data. All you need to do is to change the four variables below. You can send the script back to this email : yasbergy@yahoo.com. */ //Here starts the script. Please change the values of these variables to fit your settings $user = "prospective_PSP"; $database = "db"; $server = "localhost" ; $pwd = "" ; //Connection to the database that you created mysql_connect($server,$user,$pwd) ; mysql_select_db($database); //Creation of the two tables : categories and cat_relations $categories = " CREATE TABLE `categories` (`id` INT not null AUTO_INCREMENT, `name` VARCHAR(100) not null , PRIMARY KEY (`id`), INDEX (`id`), UNIQUE (`id`)) comment = 'The categories details' "; mysql_query($categories) ; $cat_relations = "CREATE TABLE `cat_relations` (`id` INT not null AUTO_INCREMENT, `daughter_id` INT not null, `mother_id` INT not null , PRIMARY KEY (`id`), INDEX (`id`), UNIQUE (`id`)) comment = 'Which category is the daughter of which category'"; mysql_query($cat_relations) ; //Filling the two tables with sample data $cats = array('Main','Computers','Countries','Hardware','S oftware','Programming languages','Mac','PC','Atari','Winamp','History of the PC','IBM','Components','High level','USA','NYC','LA','Manhattan','India','Winzi p'); for ($i=0;$i<count($cats);$i++){ $sql = mysql_query("insert into categories (name) values('".$cats[$i]."')"); } mysql_query("insert into cat_relations (daughter_id,mother_id) values (2,1),(3,1),(4,2),(5,2),(6,2),(7,4),(8,4),(9,4),(1 1,8),(12,8),(13,8),(10,5),(20,5),(14,6),(15,3),(16 ,15),(17,15),(18,16),(19,3)"); //Now you can have a look on them through phpMyAdmin ?>
View Replies !
Update 2 Tables At Same Time?
I have two tables - Categories and Items. The Categories table has 2 fields - id and cat_name (category name). The Items table has several fields one of which is also cat_name (category name). The category name here should match the category name in the Category table. Basically, how it works is I populate the Categories table with category names. When someone enters an item into the Items table they have a drop down menu that is populated with the category names from the Category table that they choose to set the item under. Code:
View Replies !
Update The Time The User Logged In
Im having problems with the following code, it wont update the time the user logged in, can anyone help?. tried changing mysql_num_rows to mysql_affected_rows and it still does not work. I am using a DATE/TIME format to store the login time, PHP Code:
View Replies !
Update Time Of Mysql Table
I want to get the time/date that a table was last updated within my database. I know you can put a new column in with a timestamp, but the data is old and obviuosly already exists. I notice that in my mysql admin it shows me this time and date. Is there anyway I can grab this and display it in my html page with php.
View Replies !
Update All Rows In Some Field At The Same Time, How?
I have a table like this: Table name: page ID | name | status | order 1 | a-name | active | 1 2 | a-name | active | 2 3 | a-name | active | 3 ------------------------------------------------- The "name" is being looped in an menu.....and the "order" field sets the order of the menu links (name). I have a form to udate all "order"-rows at the same time but i cant get it to work....heres my form and db script: Code:
View Replies !
Form To Update Automatically By Using A Form Processed By Php And MySQL.
I have a page that we are trying to database. Its a trade show page has the list of the shows and the dates of them. well we want the form to update automatically by using a form processed by php and MySQL. So I was wondering if there was a way when entering the data into MySQL through the form that the shows would sort by recent dates to long range dates automatically instead of sorting it when you call the table to view the shows?
View Replies !
Update Form Throws "Undefined Index" Error For Unchecked Radio Button Fields On Form
I have display error ON and error reporting to E_ALL. I have a form that opens fine. When you submit it, all the fields that have nothing in them, for example an un-selected radio button, throw the error similar to that below. Notice: Undefined index: fld_ONECHOICE in /usr/..../updateFORMFACT.php on line 29 These fields are not required for the form to be completed. Do I HAVE to default all fields to yes/no or some entry? Surely not. Is this just something that shows with error reporting set to E_ALL and I shouldn't worry about it?
View Replies !
Update From Form
The file below is supposed to bring up a form with the fields for a user inserted into it for editing. "edit.php?id=83" is an example of the link to it. When that link is clicked the page is empty and the is no code in the source view. <? include("dbinfo.inc.php"); mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query="select from todo where id='".$_GET['id']."' LIMIT 1"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); $i=0; while ($i < $num) { $item=mysql_result($result,$i,"item"); $description=mysql_result($result,$i,"description"); $category=mysql_result($result,$i,"category"); $priority=mysql_result($result,$i,"priority"); ?> <form action="updated.php"> <input type="hidden" name="ud_id" value="<? echo "$id";?>"> Item: <input type="text" name="ud_item" value="<? echo "$item"?>"><br> Description: <input type="text" name="ud_description" value="<? echo "$description"?>"><br> Category: <input type="text" name="ud_category" value="<? echo "$category"?>"><br> Priority: <input type="text" name="ud_priority" value="<? echo "$priority"?>"><br> <input type="Submit" value="Update"> </form> <? ++$i; } ?>
View Replies !
Php Form And Update Sql
Im using a php user system from source forge and modifying it. I just want to test updating sql from a submit button. So say when button is clicked the new value either as a actual value or an addition like below can be passed to the database and then the value returned as a print or echo. if ocassionaly managed to get the value to update (i checked the sql database) but it doest work at showing the updated value and now its completely broke. Can anyone who understands what im trying to do either look over what ive got and correct or write a simple version of what I should be doing. Code:
View Replies !
Form Update
I have a form that sends data to mysql, and you get shown the submitted data. But i also want the users to be able to update their sent info, after thay see what they've sent, to make changes if something was incorrect. I want to make an update feature that will let them do that, but their is no user authentication on these pages, so i want to use php session. I don't know where to start. I want the form data to be saved in the session, so when they go to the update page, their info is still there. I want the session to end after they update.
View Replies !
An Update Form
I have about 10 tables, that CANT be combined. Reason is, the tables will include login information for about 500 employees, and I dont want to push that much info into one table incase I need to view from phpmyAdmin because of a site issue. So, I have a profile page, where you will be able to update your login info. Im wanting to setup a way that when there viewing the update profile page, that it will update more then one table. Im using a comman tag, id_agent, that helps everything link. So I need it to go into each table, and other tags like FirstName LastName and so on.
View Replies !
PHP Form Field Update...
I am sure this has been answered here somewhere, but I have searched for a good 2-3 hours and can't seem to locate a solution. Additionally, I really don't want anyone to solve this mystery for me (at least not all the way!) - But I was hoping someone could point me in the right direction here. I am trying to figure out how to update form field information before the end user hits the submit button - for example, if they select that they are from California from the "state" drop down list, only counties from California would show up in the "county" drop down list. BTW, this is only a hypothetical example - I am only using this code to build a photo manager for my website! Anyone able to: 1) tell me what this process is called - it's hard to search for answers when you don't know what you're looking for. 2) point me in the right direction of a solution.
View Replies !
Form -> Array -> Update
I have a form which lifts 20 items at a time out of a db table. Against each record I place a textbox for suggested changes, and the relevant line in the form is: PHP Code:
View Replies !
Dynamic Form Update
I have the following form in which i need to updateitems. The problem is that i do not know how many elements will be in the form (generated dynamically) eg <input type = "hidden" name ="id1" value="1"><input type ="qty1" value ="1"> <input type = "hidden" name ="id2" value="2"><input type ="qty2" value ="1"> <input type = "hidden" name ="id3" value="3"><input type ="qty3" value ="5"> <input type = "hidden" name ="idn" value="n"><input type ="qtyn" value ="1"> how do i generate an array for a foreach loop to update the values in PHP so that i can use it to create a Update query eg ///begin loop $sql = "UPDATE `table` SET `qty` = `$qtyn` WHERE `id` = `$idn`"; // end loop
View Replies !
Update A Table From A Form.
I am trying to update a table from a form. Right now it is not updating. I'm still new to the php mysql world so most of code comes form books I have or searches on the internet. I have been trying to figure this one out for a while. Code:
View Replies !
Update Database Using A Form
i would like to up date i have the following fields; Prod_ID Prod_Desc Date_sent_in_house Used_by_date Supplier Cases_sent Cases_sold Price_p from a form i would like to enter new data into the database table., but unsure on how do do this can you help?
View Replies !
Form Selection & Update
I am working on a form. and I want to allow users to select their payment type from a drop down list (i.e. Credit Card, or PayPal) and have the form automaticly update with the corasponding fields. I don't want The user to have to push a button, or for the entire page to update. Just the form. I know this is doable because I have seen it done. I have an intermediate understanding of php and don't mind working for the knowledge.
View Replies !
Form Update After Search
This is my first attempt and PHP with MySql , I am trying to make an update after searching for a record , the search is fine but I cannot make the update. below is my code , the query is not working as I get this message when it runs "Error performing query: Query was empty" <?php $cn = $_POST['custno']; $fn = $_POST['fname']; $ln = $_POST['lname']; $a = $_POST['address']; $p = $_POST['postcode']; $ci = $_POST['city']; $r = $_POST['region']; $cy = $_POST['country']; require_once('mysql_connect.php'); // Connect to Database $sql_update = "UPDATE athena SET "; $sql_update .= "athena.firstname = '" . $_REQUEST['fname'] . "', ";
View Replies !
Update Database From A Form
I'm still learning PHP while im making a user-account system on a site. So all this is helping me learn. What i need to know is, when a person submits a registration form, how do you make it submit to your database and create a membership for them?
View Replies !
Update Data From Form
update.php Tajuk:<input type="text" name="tajuk" size="55" style="color: Navy; font-family: Verdana;" onKeyUp="javascript:this.value=this.value.toUpperCase();" value="<? echo $row['tajuk']; ?>" /> <textarea name="ringkasan" cols="40" rows="5" style="color: Navy; font-family: Verdana;" id="ringkasan" onKeyUp="javascript:this.value=this.value.toUpperCase();"><? echo $row['ringkasan']; ?></textarea>
View Replies !
Update 2 MySQL Tables In One Form
I have a form with two fields in it. Each field updates its own table. I would like for the user to be able to enter data in either fields and the form update the appropriate tables. If one of the fields is empty then it doesn't update the table. mcat - Updates mcatTable.mcatname mtype - Updates mtypeTable.mtypename PHP Code:
View Replies !
Form Fields To Update A Webpage
I am trying to build this mini "publishing" system and allows the user to use form fields to update a webpage (images and text) then press a button to email that webpage to a list of emails. (spamming own userbase). I will have a webpage with php code in it and the code will pull data from the db. How can I save the file has a static html file so that I can pass it to my mail function? or can I directly pass the php page to the mail function? or what is the best way of doing this? I also have to learn how to do file upload with php aswell.
View Replies !
Update Page Content From A Form
I want to have a web page that uses variables from a text file as some of its content. I want another page with a form that will allow me to updated/change the variables in the text file. I have no need to add variables using the form only change the values of existing variables. Basically I want to make some content on one of my pages update-able using a form; not entire paragraphs just single words that I have laid out in a table. I have been told that I should just use something like mySQL for this. I do not know if it is necessary since I only want to do it to one page.
View Replies !
Update Form, Security Issue
I have to write secure update record php script, here are the complete details of the website, the website has a login system that authenticates the user, writes the session ID for username and goes on. The user can post, read msg he can also update the msgs that he had posted in the past once he is loged in. when user tries to update the msg, the script check MySql DB with select * from Msg where username = session ID suppose recorset returns msg number 1,3,5,7,9 with that perticular username. I pass the user to a page ...update.php?msg_id=1 and the user can update the stuff. Everything is working fine, Problem what if the user changes the url to ...update.php?msg_id=2 he can still update the record, what to do he has not posted msg id 2. what sort of method or code should i use to restrict him to the msg that he posted If you feel that i am using a bad method or my database structure should have a new field please let me know coz I can still make changes in DB structure as well as my scripts we are in the somewhat initial stage of the development of the product.
View Replies !
Displaying Information In A Update Form
I can display the information in a table. But now I need to display it in a form, so I can edit it and then upload it to the database. I have the form from my upload page, But I can not seem to get the information to appear back in it. Code:
View Replies !
Update Form Created Web Page
Is ther a way to update a page based on a text area in a form. I have a form that has two text areas one is for asking question of admin and the other is for public to see (Testimonial). What I need is if the user fills out the form and uses the Testimonial text area then the page is updated. If the question text area is used it doesnt update the page. In other words if the Testimonial text area is left blank the page doenst update. See code below. PHP Code: mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $sql = 'SELECT Testimonial , First_Name , Last_Name , Company , City , State , Date FROM Comments ORDER BY Date DESC LIMIT 0, 30 ' $result=mysql_query($sql); $num=mysql_numrows($result); if ($num==0) { }else{ .......................
View Replies !
Dynamically Generated Form And Update Problems
In brief, in the following 2 portions of code I build a form based on data retrieved from a database. The second bit of code receives the posted data for processing and updating the database. Problem is that the update occurs for the first row of data but none of the rest. I'm using a hidden field, written in dynamically ( name="tfHiddenId<?php echo $j ?>" ) where $j is a counter var in a loop. When I print out the POST_VARS everything is as I want to be, fields all named according ly, as above. Just the update either 1) only does one row and quits or 2) updates same row with the same data over and over ( I suspect the latter ). Apparently my counter variable is not being incremented, but only on one var, "tfHiddenId".$i , on the receiving page. Here's the code for where the form is built from the DB: PHP Code:
View Replies !
Form Data Array - Need To Update Table
I have a form that is dynamically generated by the fields I have in a table. This table generates the navigation for my site, and I want to create a page that will allow me to reorder and hide/show and activate/deactivate the links. The form is working and I have the form generating an array based on the data collected on submit. I need to know how to break this data apart so I can update my site navigation table with the correct values. The table looks like this:
View Replies !
Update A Ststic HTML Form To Dynamic
I have a form which I now want to be more dynamic. The datbase tables are builtbut I cannot get the fields to populate. When a member selects an age group from the first select statement and the dates that age group are scheduled to play a match are displayed in a second select statement. When both select ions have been made the rest of the form is displayed and can be filled in and the database updated. Code:
View Replies !
Add A Conditional Statement To My Update Record Form.
I wish to add a conditional statement to my update record form. Basically the form has an image upload feature and I wish to make it so that only if an image is specified should that field be updated, otherwise it should just ignore updating that field. The update code is below: $updateSQL = sprintf("UPDATE news SET Type=%s, Headline=%s, Poster=%s, Summary=%s, Content=%s, Image=%s, `Date`=%s, Disabled=%s WHERE Id=%s", GetSQLValueString($HTTP_POST_VARS['type'], "int"), GetSQLValueString($HTTP_POST_VARS['headline'], "text"), GetSQLValueString($HTTP_POST_VARS['poster'], "text"), GetSQLValueString($HTTP_POST_VARS['summary'], "text"), GetSQLValueString($HTTP_POST_VARS['content'], "text"), GetSQLValueString($HTTP_POST_VARS['image'], "text"), GetSQLValueString($HTTP_POST_VARS['date'], "date"), GetSQLValueString(isset($HTTP_POST_VARS['disabled' ]) ? "true" : "", "defined","'Y'","'N'"), GetSQLValueString($HTTP_POST_VARS['Id'], "int")); I have tried inserting an if statement around the particular field but this caused the page to flip out and generate errors all over the place.
View Replies !
Update Data From Form To MYSQL In While Loop
Here are a couple of data type in mySQL: // YYYY-MM-DD HH:MM:SS id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), status VARCHAR(1), dateModify TIMESTAMP, dateCreate TIMESTAMP, solution TEXT Here is the code to show the query from mySQL: Code:
View Replies !
|
TRACKER
