Persistent Form Info
I have some forms that have different parts, and it decides which parts to display through the url ie form.php?showpart=1, showpart=2, etc. If I want to show another part and change the url all the form info goes away. I'm a self taught PHP guy, I'm decent but not amazing. My current solution is to use AJAX to write/modify a cookie everytime the user writes something and bring that in when they change the page. Is there an easier way?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Persistent Form Data?
I've set up a form with captcha and if someone enters the wrong captcha info and returns to the form to fix it, the previously filled in data is wiped out. What do I need to add so that the information persists? Would it be a session or cookie or ?
Php Form Info...
have a form, with a text input "fieldname". method POST $var = $_POST["fieldname"] $var is then used to search in mysql select * from table where jobtype like '$var%' OR jobtype like '%$var%' OR jobtype like '%$var' OR jobtype like '$var' order by date asc; basically i'm doing a search for any string that matches the searched input, being at the beginning, middle or end of the jobtype column. query works great, except when the string contains the 4-letter word 'info' such as information or informative then the mysql query breaks down and give the usual: Error performing query: 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 'ORDER BY date ASC' at line 1 Now after much debugging, i found out that the php _POST variable treats anything with info as a numner of 0 value. inf is treated as text, nformation is treated as text, but anything with info gets a 0 value. Searched php.net and couldn't find anything related to this feature, looked under security to see if it was related to that, but nothing.
Php Form Info...
have a form, with a text input "fieldname". method POST $var = $_POST["fieldname"] $var is then used to search in mysql select * from table where jobtype like '$var%' OR jobtype like '%$var%' OR jobtype like '%$var' OR jobtype like '$var' order by date asc; basically i'm doing a search for any string that matches the searched input, being at the beginning, middle or end of the jobtype column. query works great, except when the string contains the 4-letter word 'info' such as information or informative then the mysql query breaks down and give the usual: Error performing query: 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 'ORDER BY date ASC' at line 1 Now after much debugging, i found out that the php _POST variable treats anything with info as a numner of 0 value. inf is treated as text, nformation is treated as text, but anything with info gets a 0 value. Searched php.net and couldn't find anything related to this feature, looked under security to see if it was related to that, but nothing. Can anyone look into it and elaborate? create a form, then echo the value of the $_POST variable and try words that contain info in them.
Getting Info Out Of Dynamic Form
I am using the following code to produce a dynamic form. $result = mysql_query("SELECT id,weight,date FROM weekly_data WHERE weight IS NULL AND subscr_id = '$toss' AND date <= now()"); if (!$result) { die('Invalid query: ' . mysql_error()); } print"<table width=ď`%' id='catchup' border=Ɔ' cellspacing=Ɔ' cellpadding=Ɔ'>"; print "<form name='form1' id='form1' method='post' action='catchupprocess.php'>"; print"<tr>"; print"<td></td>"; print"<td>Weight</td>"; print"<td>Date</td>"; print"<td>Waist</td>"; print"<td>Measure</td>"; print"<td></td>"; print"</tr>"; while ($row = mysql_fetch_array ($result)){ //echo $result; print"<tr>"; print"<td>"; print"<input name='".$row['id']."' size=Ɗ' type='text' value='".$row['id']."'/>"; print"</td><td>"; print"<input type='text' size=ƌ' name='weight".$row['id']."' value=''/>"; print"</td><td>"; print"<input type='text' size=ཆ' value='".$row['date']."'/>"; print"</td><td>"; print"<input type='text' size=Ɖ' name='waist".$row['id']."' value=''/>"; print"</td><td>"; print"<input type='text' size=ƌ' value='$measure'/>"; print"</td><td>"; print"<input type='hidden' size=ཆ' value=''/>"; print"</td>"; print"</tr>"; } print"<tr>"; print"<td> </td>"; print"<td><input name='Reset' type='reset' value='Reset'></td>"; print"<td> </td>"; print"<td><input name='submitcatchup' type='submit' value='Submit'></td>"; print"<td> </td>"; print"</tr>"; print"</form>"; print"</table>"; ?>
Printing Out Info From A Form
I have this php function that reads a text file for input to create a form. I am trying to get the form to print out the data on a separate page, but all I get is a blank page. Am I calling the page correctly, or is this even possible to do? Code:
Referer And Keyword Info Sent Via Form?
I've learned that HTTP_REFERRER, at least in my tests, returns the page visted on the current domain before the form page, not the domain visited before the current domain, so that hasn't been useful. I don't know how I would get keywords in this case. I've searched around for scripts or tutorials and have been surprised to find nothing helpful The site in question has a separate stats package, but it doesn't track converting keywords and that's really what I'm after. There isn't high volume traffic, so getting them individually via a form (rather than input into a database) isn't a problem. My question is really whether what I'm trying to do is possible with a few lines of code, or have I underestimated the complexity of the task?
Populating A Form Wth Database Info
I've coded a piece of code which populates a form with data read from the database: $connection=mysql_connec ("localhost", "f2821842", "f2821842"); $result=mysql_select_db("QUERIES"); $query=mysql_query("Select * from Emp_Details where emp_num = '$employnum'"); while($row=mysql_fetch_array($query)) {$empname=$row['emp_name'];} <form name="webregform" action="webadmin2.php" method="post"> <input name="requiredname" type="text" size="30" value="<?php echo "$empname"; ?>"> </form> When I echo the $requiredname, I get spaces and no data, and I know that $empname is not a space-it does read a value in a database. 1. How can I get $requiredname to print a value?
Insert Form Info Into Database
i am trying to enter info from a form into a mysql database. when i submit the form, a new row is created, but the information isn't contained in it? any thoughts? PHP Code:
Filling Form With Database Info
I have a table with 5 fields for a tour business activity list : (1) id -table key (2) name (3)description (4)picture -text link not binary(5) country. I would like to create a form that takes all the activitys an puts it neatly down on site in checkboxes so user can select activtys.this will be linked to form mail.i would like the activitys to be seperated by the country they r in?
Validating Form Info Before Inserting It Into Database
I have been trying to create a PHP application where you can add customer contacts to a MySQL database. Now, my problem began when I created a form where the user can add in a customer's name and info to the database. In an effort to alert the user that they may be adding a customer that is already setup in the database, knowing that some of the customers may have the same names, e.g. there is more than one Bobby Ray Brown, I decided to add a script that queries the "customers" table in the database and searches for all results that match the input from the user. Code:
PHP Displaying Info Input On HTML Form
I'm in an exercise where I've created an order form in HTML. The form displays properly and allows me to input certain test order info just fine. The relevant lines in the HTML form are: Code:
Getting Form Info Into A Mysql Select Statement
I'd like to get user input from an html form into a mysql select statement. Here's where I'm stumped: $result = mysql_query("SELECT * FROM dept WHERE notes LIKE '%search-string%'",$db); I need to get the user's input into the '%search-string%' section, but I do not understand how to do this. I can hard-code a specific search string and it will work, but I want the users to be able to dynamically define the search-string. So, I created a basic html form and used the post method to grab their input, but now I can't insert that input into the mysql select statement. Any ideas? I think it should be easy, I just don't know how to do it. I've tried this: $result = mysql_query("SELECT * FROM dept WHERE notes LIKE '%$_POST["search"]%'",$db); But it doesn't work. Below is the form in html and the php file: <html> <title>Search Test</title> <head> </head> <body> <form action="search-db.php" method="POST"> <p>Enter Your Search: <input type=text name=search></p> <input type="submit"> </form> </body> </html> ----------------------------------------------------------- <html> <body> <?php $db = mysql_connect("localhost", "Anonymous"); mysql_select_db("computers",$db); $result = mysql_query("SELECT * FROM dept WHERE notes LIKE '%surplus%'",$db); echo "<table border=1> "; while ($myrow = mysql_fetch_array($result)) { printf("<tr><td><b>%s</b></td></tr> ", $myrow[notes]); } echo "</table> "; ?> </body> </html>
Upload And Email Form Info At The Same Time
I need to upload something and also have an email sent at the same time after filling out a form. So they will fill out a form, decide what they want to upload and then hit the submit button and it will upload the file to my directory, where I can get to it, and then it will also email me the information I had them fill out in the form at the same time. Is that possible? What code would I use?
Using Form To Post Info And Pic's (Warning: Unable To Fork)
I have created an admin form which allows the admin to update info and pic's to his site but I am having trouble with the update_pic script. When I pass along the form to the php script it gives me the following error message: "Warning: Unable to fork [C:WINDOWSTEMPphp30.tmp /full/path/to/joesauto/images/anime_dvd_icongif.gif] in c:inetpubwwwrootadd_data.php on line 39" This is line 39: exec("cp $picture /full/path/to/joesauto/images/$picture_name"); This is the form I used which was taken from this site. Code:
Putting Info Into A DB / Passing Info Between Pages
I have run into an issue...I have posted previously, but my scenario has changed. Here is the situation... If a user clicks on a link ('abc123' for example) I want to insert into my database some predefined information about 'abc123' - I have assigned a value that is echoed in future pages for 'abc123'. So, what I need is some mechanism to, when a user clicks 'abc123', have a pre-defined username and password be entered into the database. I need this so future pages can utilize the session values.
Persistent Connections
I just started coding with PHP a few days ago. My code interfaces with a simple database of the books I own. MySQL is running on my computer, and Apache/PHP is running on another. I tried using persistent connections to lessen the overhead of opening the TCP connection etc, but when I reload the page multiple times, PHP seems to make a new connection for each reload. I checked the processlist in MySQL and I had a whole bunch of sleeping connections from the webserver. So my question is... did I do something wrong? I basically just changed from connect to pconnect... and to test it I was just reloading the page, so it was using the same username and password for the database. Also, another question... how do I turn on compression when connecting to MySQL from a .php file? I don't have root access to the Apache machine.
Persistent Connection
For each page on my site I have to open a database connection to retrieve data. I have only one database. For this specific situation do you think is better to use a persitent connection (mysql_pconnect) instead of mysql_connect?
Persistent Variables
I have this variable that is passed in the the $_GET, which I then assign it to a $_SESSION variable to ensure persistency, however every time i reload the page the $_SESSION variable gets lost. Hence unusable. $_SESSION ['very'] = $_GET['pery']; How can I ensure persistency beyond page reloads?
Persistent Logins With Cookies
I am trying to make a persistent login like you find at yahoo and livejournal. i have basic knowledge about cookies. i am thinking to store the username and password as a cookie, with setcookie(). the problem is that there is an expiration date on the cookie. what is a way that i can work around the expiration date so that it is forever? i know some sites do something with ip's? what if the ip is not static?
Persistent Object Sessions
I have a that page opens an imap connection; I need to refer to the connection across various pages. I don't want to reopen that connection on every page (vast waste of resources). I have tried using sessions but they do not persist objects across pages the php manual says that too. I have searched all websites/forums and nobody seems to bring up/encounter this type of problem.(refer it, if i missed) I am used to asp where we could share a connection/object across pages in the same website or even across websites on the same server. I know the work around's:- 1) Reopen the connection on eve page --waste of resources 2) Save it to a database or file -- to much/complex maintenance work for something simple. Am I missing/not understood a feature in PHP4 or is it missing this?
Persistent Global Variable?
Are there something like a `Persistent global variable` in PHP? It is something like `Application` in the classic ASP, all the request share the same variable, and the die after a timeout.
Mysql_pconnect() Do Persistent Connections Ever Die?
I currently connect to my db with PHP code that uses non-persistent connections. I've read that persistent connections can help performance since a connection to the db will use an existing unused connection. If my system was to go through a busy period whereby I seen an extra 50% or more activity for ten minutes or so, would the extra connections stay alive for ever or is there a time limit of inactivity? Would the unused connections just sleep if they don't die? Is there any negative effect of having these connections waiting around? -- A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing? A: Top-posting. Q: What is the most annoying thing on usenet?
Persistent Postgres Connections In PHP
Hello all! I'm working on a PHP site using Postgres as a back-end. I have an include at the top of each page that runs the pg_connect function. I'm implementing some temporary tables, which I understand are destroyed automatically at the end of the session. It seems to me that when I navigate to a new page, or re-load my existing page, I lose my temporary tables. Is this because I am creating a new session at the beginning of each page with my pg_connect include? Also, are temporary tables globally visible, or only within that session? I mean, can one user see another user's temporary tables?
Connection Pooling And Persistent Connections
http://php.net/function.mysql-pconnect http://php.net/manual/en/featur...connections.php Can one seriously see persistent connections as a form of db connection pooling? Is it really similar?
[pear] Persistent Parameter With HTML_QuickForm_Page
I am learning HTML_QuickForm_Controller pear extension. situation: In my project the pages are called by a op get parameter (index.php?op=foobar) and this needs to remain there even when forms are submitted. the problem: Unfortunately the attribute "action" of the html tag "form" is always "index.php", instead of "index.php?op=foobar". I have tried to pass "index.php?op=foobar" to the constructor of HTML_QuickForm_Page, with no results. It is still "index.php" (_self). When I worked only with QuickForm (with no controller) i used to set a hidden parameter "op" in the form and then handling it with a $_REQUEST instead of a $_GET. But now, with HTML_QuickForm_Controller, after the form data have been submitted the page refreshes (via http headers) and preserves no informations about the "op" parameter, so I get allways in the home page. Do you have any suggestion about modifying the action attribute of QuickForm_Page in a clean way (or even a working workaround)?
Persistent Connections And Temporary Tables?
I'm having a heck of time understanding the way a few things work, or at least, the proper way to do them. To start off, I have a mysql 5 database that's loaded up with lots of stored procedures I've written for handling a firewall log table. When I started on my project, I didn't worry about things like multiuser ability, or pagination. Now that I've got a lot of the backend work done, I'm trying to improve the front end. My stored procs return their results in the form of a temporary table (engine=memory); as I understand the mysql documentation, a temporary table stored in memory exists only while the database connection is open, and is discarded once the connection closes. So that started me on a quest to maintain my connection to the database persistently across multiple page loads. This is were I start pulling my hair out. First I find that some group of developers in their infinite wisdom have decided to not support persistent connections in the mysqli (mysql improved) functions, to that end, there is no mysqli_pconnect function. I've tried mysql_pconnect, but the (old fashioned) mysql functions don't understand stored procedures, and I get an error back from mysql that the result cannot be represented (or something like that). So I started searching for alternatives. At first, I considered switching to postgres instead of mysql; pg offers sprocs and the php functions for it offer persistent connections. Rather than go the route of reconfiguring everything, I kept searching. I then came across the php odbc functions. They seemed pretty straight forward, and functionally similar to the mysqli functions. So, I installed an odbc connector on my server, and changed my code to use odbc instead of mysqli. Now I have odbc working correctly, the same way mysqli did previously. So now, I want to try to maintain a persistent connection. According to the php docs, I need to call odbc_pconnect first to setup the connection, and then when I want to re-use that connection, I can call it again with the same dsn, username and password. So lets say I visit index.php, which asks for a username and password, and then opens a connection to the database via odbc. I store the username and password in a session variable, which is subsequently checked by an include in all my other pages. The include grabs the u/p from the session array, and fires off another odbc_pconnect, presumably to reopen the db connection. So far so good; its all working. Now I decide to test if my db connection is actually being maintained, or just recreated. I fire off a stored proc using odbc_exec($link_id,"CALL mydb.myproc()") , followed by a query to grab results from the temporary table using odbc_exec again. This works as expected. However, in my code, I also set a session variable to indicate the sp has been run, so when I refresh the page, the sp will not be called, just the query on the temp table. This is where it breaks down. QuoteWarning: odbc_exec() [function.odbc-exec]: SQL error: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.0.22]Table 'ulogdb.summary_results' doesn't exist, SQL state S0002 in SQLExecDirect in /var/www/html/db/new_summary2.php on line 29 The table summary_results should still be there if my db connection had been preserved, however, it seems the db connection was closed somewhere along the way, and mysql destroyed the table. On a side note, odbc_pconnect causes apache to segfault if it passes an incorrect username or password to the odbc connector. Code:
Temporary Tables (MySQL) With Persistent Databasse Con
I'm having this odd odd problem with temporary tables with a persistent database connection. I'm making this multi-page form/wizard type thing that store interim user data in an temporary table as follows: PHP Code:
Storing Huge Structure Persistent Or Alternative
I've got the following problem: I have a huge xml-file that represents a street map of a city. Each street is stored as a couple of coordinates (start, end and all the turns). When I set a marker in a google map, I want to find all streets that are near this marker position. I now parse the whole file as a simpleXML object, and calculate the distances to each street segment (using linear algebra algorithms, that is, constructing the vector from two points and computing the distance from the given point to this vector). Up to now it works like this: I set a marker and the gmaps method "gdownload()" calls a server side php script, which 1. reads the xml file into an simplexml object 2. for every two coordinates that belong to the same street, it calculates the vector and computes its distance to the point 3. returns the nearest x streets (as polylines) back to the client It repeats this, when I set the next marker. Problems/need for ideas: 1) It always reads the XML file anew, when I set another marker. Is there some way to cache this or a more intelligent approach? I tried saving the whole Simplexml-object in a session variable, but it was too huge. I guess I could create some tables in mysql, but I'm not sure thats the best solution yet. 2) Not php-specific: Do you have any ideas how to speed up the process of finding the nearest lane(s)? I tried to consider only those streets whose endpoints are within a certain range from the given marker- point, but it was not considerably faster and if there was a street thats very long and straight the endpoints may be far away, but the street itself is quite near.
Sessions And Persistent Connections To MySQL Database
PHP/MySQL and I've heard about maintaining a persistent connection to the database. To save overhead, I'd like to maintain the connection in a session variable, but I have a few questions first. I'm able to establish session variables and test them with isset() to avoid re-defining them with each new web-page load. So is this really as simple as if (!isset($_SESSION['connection'])) { $connection = mysql_connect("SomeServer","UserName","password"); $_SESSION['connection'] = $connection; }; Will this work? and is there a better way to do it--or a more conventional way? What should I be thinking about vis a vis security regarding this connection. Is there a recommended way to make the session's connection variable "expire"? I suppose I could store the time the connection was established and then check the elapsed time with each web-page re-load, dumping the session if it's been too long. Is there a preferred way to store $connection without using $_SESSION[]?
Warning: Unknown Persistent List Entry Type In Module Shutdown (11)
I am getting this wanrning: Warning: Unknown persistent list entry type in module shutdown (11) in Unknown on line 0 I have never seen it before or know what it means and line 0 is hard to find especially when no document is specified Everything works as it should at this point just getting that warning on my personal apache server any ideas?
Persistent, "keep-alive" Connections (or Such)
I'm looking for a way to create a PHP page that "stays alive" and updates (lines are added to the end) when other scripts make requests. I know this can be done, I've seen it work on some "on-line chat" sites, but can't figure out how to do it.
I Need Info...
I want to write a very simple PHP script that just picks random images from a directory, you know what i mean. So I'd like to know where I could find information about this in the PHP manual maybe?
PHP - SSL Info
How do i know if ssl has been enabled in a WAMP configuration using PHP ?
Looking In $var For Certain Info
I pulled certain collums from my database. The value of the collums is either Y or N. I want to figure out on each $var how many Y's there are. I don't care how many N's. At the end I'm going to add up all the Y's of all the VARs for stats. Whats the best way of counting Y's in a $var?
Server-Side Form Submission - Form Submits To Form, Which Autosubmits. BAD!
I have a php form from which the user fills out their name and address and clicks "Submit". The form goes to a page that stores the data in a mySQL database, then, using hidden fields, populates another form and actives with a javascript onLoad=submit() to send the information on to the final destination. I cannot control or edit the final destinations web page, which is why the interim page is needed. What I would like is for the user to fill out the form, and upon submission have the data recorded into the database and have the data passed on in a "form like way" on to the final destination BY THE SERVER, not by the use of a hidden form page that auto submits. Any suggestions? Here is the interim page's code below: <? $link = @mysql_connect($db_host_name, $db_name, $the_decoded_password) or die; @mysql_select_db($db_name) or die; $query = "INSERT INTO web_link VALUES ('', '$a', '$b', '$c','$d', '$e', '$f', '$g', '$h')"; $result = @mysql_query($query) or die; ?> <html> <head> </head> <body onLoad="document.contactme.submit();"> <form name="contactme" method="post" action="http://www.test.com/cgi/storethisdata" > print "<input type="hidden" name="first_name" value="$first_name"><br>"; print "<input type="hidden" name="last_name" value="$last_name"><br>"; print "<input type="hidden" name="email" value="$email"><p>"; print "<input type="hidden" name="phone" value="$phone"><p>"; ?> </form> </body> </html>
Getting Users Info
I need to get the following information, User's IP User's Browser User's Screensize What is the code for any of these as I can't find it in the PHP manual.
How To Get Header Info
I've been trying to extract the status codes from http header information to find whether a page is 200 ok or 404 not found by using an fsock() connection which works. To actually extract the data what do you use? i've seen fputs() and fgets() listed on the documentation page but how do these function actually work?
Info From MySql DB
Problem : I have a table in mysql with titles as such : ShipIDNameMcostCcostBuildETA(there are more) I run the query : for($i=1;$i<=9;$i++){ $query = "select Name, Mcost, Ccost, BuildETA from ships where ShipID=$i"; $result = mysql_query($query) or die("Query failed"); I want to refer to "Name", "Mcost", "Ccost" and "BuildETA" so i can use them to build a table. So i need to assign them to variables in an array so i can loop to make a table with as many rows as there are "ShipID"'s. The thing is that all the ways i have tried of refering to individual column names have failed.
PEAR/Info.php
I tried to use Example 49-1. Using PEAR_Info This is not showing PEAR installation information on local/remote server. What I see local, I've no file Info.php in package PEAR in PEAR directory. I've installed PEAR, why this file is missing? My Web host say, they've installed PEAR, and I can use PEAR.
Getting Info Into A Object..
I'm sitting and trying to understand this OOP - and need to create a class wich can do the following.. ShowBlocks() - Displays the data wich is inside it - If empty creates a form wich sends the info back to the Object, wich show the stuff.. AddBlock( $type ) - Creates an empty blok - wich is addet to a blocks area object...( Or somethin like it ) Store() - safes the info into a file, and updates mySQL... I have figured out most of the stuff but the way to get the empty block -> creating form with some different strings/textbloks and a file -> putting stuff into object -> now showing what its looks like and aking if i want to add a extra block....... now showing x blocks then asking if i want an extra block - i haven´t got a clue of how to do it ! Does anyone of you have an example with an object thats goes : See im a empty object -> here you can put an line into me -> see im not empty now ( showing the string) do you want to add an extra line ? - ect ect..
Help Need Php Security Info
I need to put on a demo of a php security flaw and how to fix it. Can anyone point me in the direction of a good doc and fix example ...
Getting Caller Id Info
I am developing an application where I need to read the caller id from an incoming call. The only info (for now) I need is the caller id info, so that I can display the propper caller info on screen if so desired. I was thinking on using asterisk (asterisk.org) for this with appropriate 2FXO/2FXS card but I do not know if this is just overkill (asterisk for this). Do you know of any other solution/way of getting the caller id and passing it to PHP?.
Getting Info From A Website.
I have been doing PHP for over a year now but when I came round to writing a script I discovered that there was a reasonably sizeable gap in my knowledge that I didn't even know where to start finding out about. Anyway this is a reasonably nooby question: If I have a script on http://url-a.com/script.php and I want to get some dynamic information of my friend's site at http://url-b.com/info.php , How can I get it? I need to use get variables in getting it and it must also be server side.
|
TRACKER
