Data Type Change Without Loosing Data
I have a problem in mysql. I stored a date in 08/14/2006 format and choose a datatype longtext now i want to store date in 2006-08-14 form is it possible to do it without loosing data in db when i convert datatype longtext to date the data lost. Any solution?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Change Format Style For Datetime Data Type
I don't know how to change the default format style for datetime data type. When I retrieve data from a table the datetime fields are displayed as "day_number month_name Year" but I need it to be displayed as normal form: "month/day/year". I have been trying to do it using setlocal, but I don't know how to use it.
MySQL Loosing Data?
I am in desperate need of some help, recently data in our mySQL has been removing itself, rows themselves have not been delted buit just edit and row information has been wiped and left blank. We have checked the logs and it does not appear to be anyone doing it as there are no UPDATE/EDIT or DELETES being found in the logs. Any advice has this happened to anyone else before?
Text Data Type
Can somone give me an example of using the text data type with PHP stored into MySQL.
Changing Data Type
I want to change data type of some variable, if it would be C++. following would be the code: int $var; $var=int($str); i have two questions, how to declare $var as int in PHP, secondly how to cast a variable like () in PHP.
Type Of Data Returned By A Function
I've noticed that some code analyzers comment that the type of data returned by my functions is "unknown" in the following syntax: function fnFooBar($aryParameters) { $bRetVal = True; return $bRetVal; } I *think* I can specify that by doing something like this: function fnFooBar($aryParameters) bool { $bRetVal = true; return $bRetVal; } Is this correct? If so, is there a performance gain, or is it just clean coding?
Change Data On The Same Page To Something Else
I'm trying to change data on this line of code using a drop down option box. map.centerAndZoom(new GPoint(-79.89505, 40.85708), 10); When the page opens I want the above data to be used. I want to use a drop down menu to select a different radius. Lets say 30 miles. I want to update the page so that the above line of code will update and look like this. map.centerAndZoom(new GPoint(-79.89505, 40.85708), 30); Here is some sections of code I am using. <form action='<?php echo $_SERVER['PHP_SELF'];?>' method='post'> <select name="radius" class="selectBoxes"> <option value="20">20 miles</option> <option value="30">30 miles</option> <option value="40">40 miles</option> </select> <input type='submit' name='submit' value='Click To Update Map'> </form> <script> map.centerAndZoom(new GPoint(-79.89505, 40.85708), 10); </script>
How To Change Data Dynamically ...
I'm developing a system where user has a previlage to select his/her COUNTRY then STATE then CITY respectively. i've put all the Country names, State names and City name in a Drop-Down combos which is filled dynamically from the MySQL database. Now my problem is that i want it in such a way that if one select USA as COUNTRY then all the STATE(s) of USA should be displayed on the STATE combo not any other. and then when user selects the STATE in the next combo the CITY combo should be populated with cities related to that STATE only and not with any other.
Does Anyone Declare A Different Data Type On Every Input In A Form?
I'm trying to read up on the rfc's that govern form inputs. Much of what I'm reading is stuff I didn't know before and some of it is alarming. This one left with me questions: Is this (below) addressed to me as a web designer, or is this addressed to the makers of web browsers? Identifying the type of file being uploaded seems way outside of my scope as a PHP coder. Am I suppose to make clear the expected type of content when I design a form? Off hand, I can only think of two things that every go into an HTML form: strings and binary data. Should I actually label every INPUT with the expected type (does anyone do this?), or can I assume the makers of web browsers have already done that for me? My PHP form code is fairly concise, so I could add in mime/text rather easily, but is it necessary? Surely the browser knows that everything save binary files is a string? They wrote: 3.3 use of multipart/form-data The definition of multipart/form-data is included in section 7. A boundary is selected that does not occur in any of the data. (This selection is sometimes done probabilisticly.) Each field of the form is sent, in the order in which it occurs in the form, as a part of the multipart stream. Each part identifies the INPUT name within the original HTML form. Each part should be labelled with an appropriate content-type if the media type is known (e.g., inferred from the file extension or operating system typing information) or as application/octet-stream. They give the example below. Am I right to say that I don't need to think about any of this, that the web browser does all this automatically? The browser figures out that file2.gif is a gif image that needs to be sent with a the header Content-type: image/gif, yes? If the user also indicated an image file "file2.gif" for the answer to 'What files are you sending?', the client might client might send back the following data: Content-type: multipart/form-data, boundary=AaB03x --AaB03x content-disposition: form-data; name="field1" Joe Blow --AaB03x content-disposition: form-data; name="pics" Content-type: multipart/mixed, boundary=BbC04y --BbC04y Content-disposition: attachment; filename="file1.txt" Content-Type: text/plain ... contents of file1.txt ... --BbC04y Content-disposition: attachment; filename="file2.gif" Content-type: image/gif Content-Transfer-Encoding: binary ...contents of file2.gif... --BbC04y-- --AaB03x-- If I wanted to send multiple files as part of a form input, how would I use the multipart/mixed header, or the "content-transfer-encoding" header? Can anyone point me to an example, so I might have a better chance of understanding this? As with all multipart MIME types, each part has an optional "Content-Type", which defaults to text/plain. If the contents of a file are returned via filling out a form, then the file input is identified as the appropriate media type, if known, or "application/octet-stream". If multiple files are to be returned as the result of a single form entry, they should be represented as a "multipart/mixed" part embedded within the "multipart/form-data". Each part may be encoded and the "content-transfer-encoding" header supplied if the value of that part does not conform to the default encoding.
Change Data Time Format
when I retrieve my date and time from database and display as follow: 2003-03-14 14:42:18 How can I easily change the format into : Mar 14th, 2003, 2:42pm
Refreshing A Page To Display Change In Data
I have a page that scrolls out information from a database. When one of the records has been completed by the user, they press delete at the end of the row, and it sends the record id to a processing page that deletes that record from the database, then returns to the scrolling page. However, the deleted record still shows on the page until one presses the refresh tab on the browswer. Is there some way I can have the page refresh when the processing is done, so that the changes made will be reflected immidiatly, instead of the user having to press the refresh button themselves?
Losing $_POST Data With Input Type="image"
I am having problems with a php script that I am developing. I have a file called "login.php". It contains an HTML form with a username and password field, and is submitted with an image. Here is a simplified version of my form: <form name="form1" action="<?php echo $_SERVER['PHP_SELF']?>" method="post"> <input type="text" size="20" maxlength="50" class="text" name="uname"> <input type="password" size="20" maxlength="12" class="text" name="passwd"> <input type="image" src="images/b-login.jpg" border="0" name="submit"> </form> As you can see, the script calls itself. However, when I try to access $_POST['uname'] and $_POST['password'], they do not exist. If I replace the line <input type="image" src="images/b-login.jpg" border="0" name="submit"> with <input type="submit" name="submit" value="Login"> everything works fine. I need to use this image to submit my form, not the standard "Submit" button. Any ideas on what the problem is?
Change Website To Php,mysql Data-driven Website
At the moment this site is not completely php. How can I make the content of the pages be from a mysql database? and how do I make the nav buttons work correctly connecting to the mysql database and displaying the correct content, ?
Simulate Send Data With POST And Get Data From A Web Page (whith A Session)
I'd like to get text of a webpageB that I reach by putting a login and a password in a webpageA. I mean: I'd like to get text of a WebPageB with a php script. But before I can see WebPageB I have to autenticate myself in a WebPageA writing my login and my password in a form, the host recognise me and (by session) let me see the WebPageB. The question is: 1)how to simulate send data (login an password) in form with a PHP script? 2)how to navigate in a Web usin the same session?
Problems With Reading Data From A Text File And Inserting The Data Into DB
Ive been having problems getting this to work for 3 days now. Basically what im trying to do is read from a text file and insert the information into mysql. The text file is in this format: "LuCyndi@infiniti.com","carol","kellerhals","109 veeder dr","las vegas","NV","89128","702-254-2061","45" "the_prophet@att.net","a.","cohen","6794 e. bonanza rd","las vegas","NV","89110","702-463-6569","55" I understand how to open files to read but im having problems turning each set of data into an array so i may insert it into mysql. If someone could please help it would be appreciated.
Comparing Form Data To Mysql Data
Im interested in building a script that would take form data, a variable like an address, and compare it with a known address in a mysql table (called addresses), then if there is a match log the address information in a separate table called (addresslog), and return the visitor to a certain page. If there is no match between the address entered in the form and known addresses then the information is still logged into the addresslog database but the visitor will be sent to a different page. I'm still new to this, and am working through the logic and the syntax, but I believe I'm close. It's still not working, I have all of the proper tables, maybe I'm way off with the coding so I thought I would seek out some expert advice. Here's the entire script with as much explanation as I could give. PHP Code:
Showing Data From Data In Specific Interval
i will make a banner system to my website. there is some information in the database i get out with to my site. that is pasteing the data in random way. i have a date with day-month-year and a time .. hour:min. how do i do in my code so its is displayed in ex 1 month from that day it is acceptet. give me an example to how i could do it.
Data Mining / Data/Website Scraping
I'm looking for a piece of software or coding that will let me post a form to another URL, accept the response, search it for a specific "success" string and then let me continue processing the rest of my program. I want to accept queries on behalf of my supplier, forward it to them behind the scenes, accept their response and display it within my website. Has anyone had any experience with this? Is there a simple, basic utility to let me do this? I was kind of hoping I could avoid developing it myself.
Delete Data From The Data Base
Im doing the PHP-MYSQL program to search the data in the database and display on the HTML Page. Everything is working fine till now. Now I want to know that, how to write program to delete the searched and displayed data from the database..... I know the MySQL Syntax to delete data from database...Im not asking about MySQL programming. I want just an idea, how to do the delete process. Here is My full PHP script, Code:
Comparing Database Data And New Data
I am trying to create a PHP script that reads in a file, parses it for the data I want and compares it to the data I have in a database. The data is points and ranking information for a Folding@Home Team. Every week someone creates a news item with points gained by each team member for that week and other info. This is done manually and takes a lot of time. I hope for my script to automate as much of it as possible. The script was to run as follows: Download and parse latest statistics into 2D array Compare usernames in array to usernames held in Database Any new usernames and their respective points/rank to be added to database Compare points in 2D array of each user to those held in database. Output username and points gained I thought I had a working script until I actually tested it on real data, and realised I missed something rather obvious - the order of usernames from the parsed file is not going to be the same order as in my database - due to people moving up and down the ranks. So i can't just get a recordset from the db and run a simple loop to compare it to the parsed data. I am not sure how to go about comparing the database information with the parsed data that works around the fact the data could be in any order. The only thing i can think of is: foreach item in $parsed_data_array query database for $parsed_data_array=>username if(number of results == 0) build new insert query for current username else continue I don't know if this works [haven't tested yet] but I can't help feel it is a little DB intensive. There could be up to 200 queries being sent to the database. This can be minimized by adding extra criteria, like ignoring inactive users of course. Is this a viable solution or is there a much better way of doing this?
Retreiving Data And Maintaining Data
I am trying to add data to a table in oracle but get Warning: ociexecute(): OCIStmtExecute: ORA-00936: missing expression in /homedir/ilex-s02/mrace/public_html/addnewemp.php on line 18 here is the PHP script i am working with, Can anyone see any faults with it? Code:
Get The Data From Those Rows That Have Data
Hi Guys, If i were to have the following php query: $query = "SELECT * FROM alist WHERE list_id = $id"; $result = mysql_query($query); while($row = mysql_fetch_array($result)){ echo "<b>{$row['List_Name']}</b><BR>"; echo "{$row['address']}, {$row['state']}<BR>{$row['post_code']}<BR>Tel: {$row['phone']}<BR><BR>"; echo "{$row['Info']}<BR>"; echo '</blockquote>' ....how can i get the data from those rows that have data. For example, some rows won't have a 'phone' value so i don't want this to display "Tel: " if there is no value associated with 'phone'. What do i need to add to my script inorder to achieve this? Thanx...
Posting Form Data And Also Allow To Download Form Data
i have a client that whats to post form data to a database but he also wants users of the script to download it aswell how will i got about doing this i thought about it that i could make it save it into a txt file then echo the download link is there any ideas? because to post it to a txt file it would be posting 2 places is there a way to do this? Code:
Loosing It
two words from the form below and one simple query after, doesnt work, what to do to make it work <FORM ACTION=search.php METHOD=POST> <INPUT TYPE=TEXT NAME=search size=20> <INPUT TYPE=TEXT NAME=search1 size=20> <INPUT TYPE="submit" VALUE="Proceed query"> </FORM> <? //this one works fine: "select * from table_1 where dane like '%$search%'" //but i wanna the one below to work $query = "select * from table_1 where dane (like '%$search%') or dane (like '%search1%')"; //^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^^^^^^^^^^^ //DOESNT WORK, WHY? $result = mysql_query($query); while($row = mysql_fetch_row($result)){ print_r($row[0]); echo '<br>' ....
Loosing Session ID ?
I am having some problems with my sessions, it works ok with my cookies switched on, but I decided to test my scripts with them disabled and it doesn`t work and I cant figure out why. Here is my code:
Loosing Session
i am trying to implement ssl into my site. My ssl is setup under a different directory on the server (my host set up)So, i moved my three checkout pages and all of their include files to the new directory. I also changed all the links on the include files to the full path of my regular site for images ect. When i changed the link on the view cart page to the https:// address ..... it loses its session? When i leave the normal directory that the site is under and go to the https:// directory I have it will not pull up the $_SESSION['cart'] from the original directory.
Session Loosing Vars
I'm using sessions to store some vars that are needed thruout my shopping-cart. sometimes the one or other var is lost. It doesn't happen often so we did a lot of testing and found that if the session looses a var it's not always the same var. We already downloaded opera and NS7 to see if it was a ie6 related problem. but it does not seam like its a browser related problem. What could it be? what can be done to fix this?
Session ID, 'loosing It' Between Pages?
I heard that there was a chance of 'loosing' a session ID between pages, (when the user clicks from one link to another). Is it really possible? Where could I find a definitive answer to that question? What browsers does that apply to? My database stores some information based on the session id, would there be another, (better), way of doing things? I know I could pass the Session ID from pages to pages but is there a better way?
PHP Not Compiling - I'm Loosing What's Left Of My Hair Over This!
I'm trying to compile PHP 4.4.1 on RH E3 ES. I need to enable zlib support but when I do PHP does not compile without errors. Here's what I did. make clean; ../configure --with-apxs2=/usr/sbin/apxs --with-mysql=/usr --with-config-file-path=/etc --enable-mbstring=all --with-zlib=/usr make; make: *** [libphp4.la] Error 1 If I run configure without --with-zlib=/usr it compiles just fine. So it is definitly zlib that's causing the error. What's weird though is that the error seems to come from mysql! The full error log is included below. I'm using MySQL 4.1 compiled from source. (It works fine.) /usr/lib/mysql/libz.a(adler32.o)(.text+0x0): In function `adler32': : multiple definition of `adler32' /usr/lib/mysql/libz.a(adler32.o)(.text+0x0): first defined here /usr/lib/mysql/libz.a(adler32.o)(.text+0x250): In function `adler32_combine': : multiple definition of `adler32_combine' /usr/lib/mysql/libz.a(adler32.o)(.text+0x250): first defined here /usr/lib/mysql/libz.a(compress.o)(.text+0x0): In function `compress2': : multiple definition of `compress2' /usr/lib/mysql/libz.a(compress.o)(.text+0x0): first defined here /usr/lib/mysql/libz.a(compress.o)(.text+0xb0): In function `compress': : multiple definition of `compress' /usr/lib/mysql/libz.a(compress.o)(.text+0xb0): first defined here /usr/lib/mysql/libz.a(compress.o)(.text+0xf0): In function `compressBound': : multiple definition of `compressBound' /usr/lib/mysql/libz.a(compress.o)(.text+0xf0): first defined here /usr/lib/mysql/libz.a(crc32.o)(.text+0x0): In function `get_crc_table': : multiple definition of `get_crc_table' /usr/lib/mysql/libz.a(crc32.o)(.text+0x0): first defined here /usr/lib/mysql/libz.a(crc32.o)(.text+0x10): In function `crc32': : multiple definition of `crc32' /usr/lib/mysql/libz.a(crc32.o)(.text+0x10): first defined here /usr/lib/mysql/libz.a(crc32.o)(.text+0x690): In function `crc32_combine': : multiple definition of `crc32_combine' /usr/lib/mysql/libz.a(crc32.o)(.text+0x690): first defined here /usr/lib/mysql/libz.a(deflate.o)(.rodata+0x0): multiple definition of `deflate_copyright' /usr/lib/mysql/libz.a(deflate.o)(.rodata+0x0): first defined here /usr/lib/mysql/libz.a(deflate.o)(.text+0x0): In function `deflateInit_': : multiple definition of `deflateInit_' /usr/lib/mysql/libz.a(deflate.o)(.text+0x0): first defined here /usr/lib/mysql/libz.a(deflate.o)(.text+0x50): In function `deflateInit2_': : multiple definition of `deflateInit2_' /usr/lib/mysql/libz.a(deflate.o)(.text+0x50): first defined here /usr/lib/mysql/libz.a(deflate.o)(.text+0x460): In function `deflateReset': : multiple definition of `deflateReset' /usr/lib/mysql/libz.a(deflate.o)(.text+0x460): first defined here /usr/lib/mysql/libz.a(deflate.o)(.text+0x1240): In function `deflateEnd': : multiple definition of `deflateEnd' /usr/lib/mysql/libz.a(deflate.o)(.text+0x1240): first defined here /usr/lib/mysql/libz.a(deflate.o)(.text+0x300): In function `deflateSetDictionary':
Loosing Date In HTML Form
as always i have a problem:-) i'm using HTML form. User is adding some date to this form and after that i'm generating plot. When plot is generated i can see en empty form and a plot. I want to see filled in form and a plot. don't know why i'm loosing all the data. when user adds data to the form i'm doing something like that: ...index.php?operation=added.. if operation=="added" then blablabla.. (of course its pseudocode).
Form Type=submit Vs Type=image
I'm wanting to create a form with quite a few SUBMIT buttons that use an image rather then the stock (plain grey) button. Everything works fine when I use this line: print "<INPUT TYPE="submit" NAME="editaction" VALUE=$id>"; I know which SUBMIT button was pressed by checking the value of $editaction in the receiving page. Now if I replace that line with this one: print "<INPUT TYPE="image" SRC="icon.gif" NAME="editaction" VALUE=$id>"; I no longer get a value in $editaction. I know about $editaction_x and $editaction_y. Is there no way get to the 'VALUE' (from the VALUE=$id part) as well? Am I missing something? Has the variable name been modified to somthing like $editaction_value? TIA for any light you can shed.
Getting Data From The URL.
I´m using php to build dinamyc images. The whole process is done via form. The user enters some data in text fields and them a script retrives this info and builds the image. The next step is to provide the users with a url so they can display that image in their site. But I need that image to be updated ( if needed ) when it is called to be displayed. My question is this, how do I get data from the url and use it on my script. Let me give an example: The url for the image would be something like: http://www.myserver.com/images/fabiop.jpg I need to retrive the username ( fabiop ) and the extension ( .jpg ) and use them in the script to generate the image on the fly to be displayed. How do I acomplished that ? I´ve seen this working on some sites but I didn´t figure out how it was perform. My best guess was that this sites have a webservice running in the background that performs this action.
Getting Data From A Txt File
Get data from a txt file, and say that the first 8 characters are the id, the characteres 9 to 17 are the date.
Sorting Data
Im displaying data from a mysql query that displays a Player, email, id etc.. and I have links that sort the data by player, email, id etc... But Ive seen websites where you click sort and it will sort the data by that and if you click it again it will sort that data this time in descending order. How am I able to have link that will sort the data normally and descending order?
Parse XML Data To PHP
When parsing XML data in a php file the script is told where the data is. For example:
Inserting Data Into A Row
I’ve got a table of three fields (id, name and comments) that contain 30 rows. Each row contains data in the two first fields (an id and a name). The third filed is empty. When a user accesses my page they can select one of 30 names from a drop down menu. After they’ve selected a name the user can write a comment about the person he/she selected. How can I insert the comment from the user into the comment field related to the name selected?
Dynamic Data
I have included a php script into my page as <img src="plot.php">. That script just plot some time changing data. Now I have two questions that I cannot solve myself: (1) When I press the reload button I expected the plot reflected the changed data. Instead of that plot remains unchanged until I directly invoke the php script from the browser... Is there any method to avoid this unwanted caching? (2) That is a bit off topic but is there any easy way to get a web page updating after a certain period of time? Once solve my first question I'd like to offer mi visitors a automatically changing graphic.
Truncating Data
I have a simple form, going to a simple catch page, but it doesn't work perfectly. In the one text field, it truncates the first 4 characters of the text. The rest of the string comes through fine, but it's the first four that get lost. this is the top of the form, and the field that is givng me a problem.
Extracting Data From XML ?
The following is the sample XML file from which I want to extract the data of which availabity ="Available" using php. The XML file will be generated dynamically from the URL http://www.upc.nl/zipcode.php?zipcode=3565BG <UPC-Results> <DateTime>05-12-2005 02:08:26</DateTime> <Errors/> <Products> <Product name="CaTV" availability="NotAvailable"/> <Product name="Chello Starter" availability="NotAvailable"/> <Product name="Chello Easy" availability="NotAvailable"/> <Product name="Chello Light" availability="NotAvailable"/> <Product name="Digitale telefonie FreeTime" availability="NotAvailable"/> <Product name="Chello Classic on DSL" availability="Available"/> <Product name="Chello Plus on DSL" availability="Available"/> <Product name="Chello Extreme on DSL" availability="Available"/> <Product name="Digitale telefonie Basis on DSL" availability="Available"/> <Product name="Digitale telefonie FreeTime on DSL" availability="Available"/> </Products> </UPC-Results> from the above XML, I need to get data of Product name which has the status of "Available"
Excerpts Of Data
I am working on a project that involves PHP and MYSQL. I am currently pulling information from a TEXT field (could be LONGTEXT). I would like to be able to create an excerpt from the data. So...say I run this query: SELECT review FROM bookreview WHERE id=1 That will give me a rather lengthy review. What I would like to do is display only the first X number of words or characters (preferably words), add a ... and then link it to the rest of the story. My question is how to cut short "review" after X words or characters. I presume it can be done in either PHP or MYSQL but I have no idea how. I am uncertain if this is important, but this query is going to loop at least several times so I need to be able to work whatever code you give me into a loop so I can pull multiple reviews.
Sort Data
When I click a title of table, I want to sort data. It same phpMyAdmin.
Select Data From Db?
I have a db that I need to select data out of. In the field it is selecting out of there is data input there from an array and then implode is used to seperate each item with a, When I run a query and wanna select data from this row I need the data from the previous form to = only one of the items in the row, but could be any of the items. how do I tell the page or the query that it could be any of many things in the row, but only has to be equal to one of them?
Printing Data?
why the following code isn't printing any data from the selected database. PHP Code:
Logging Data
i am making a website for off-housing department at my university. the dept. wants to have a daily log so taht they can check on a daily basis, as to how many ppl entered the website on a paricular day. Seperate logs for each day would be preferred.
|
TRACKER
