[PHP-DB] Re: Help: Two dimensional array from table
Mark Fellowes wrote: I created an array to pull data out of one column in database. //Code for registered $usrregid = array(); do { $usrregid[] = $row_rs_usr_usr["usr_id"]; } while($row_rs_usr_usr = mysql_fetch_assoc($rs_usr_usr)); //end of registered ?> However I now need a second column from the table and think a two dimensional array is the right way to go. Having a problem though in defining. Most of the examples I found don't seem to apply to pulling the values from a db. I tried this and while it returns no errors, it also returns no value. //Code for registered $usrreg = array("id", "date"); do { $usrreg[] = $row_rs_usr_usr["usr_id"]["usr_date]; } while($row_rs_usr_usr = mysql_fetch_assoc($rs_usr_usr)); //end of registered ?> Am I defining wrong or pulling the values wrong ? TIA Mark __ Organize. Communicate. Share. @ http://www.goowy.com Maybe try it this way: -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: stripslashes etc.
Andrew Darby wrote: Hello, all. I'm getting a bit confused figuring out the best way to insert data into a db via web forms and then pull it out again safely. I know there's lots of information out there, but I was hoping someone could suggest a current, [easy!] best practice. Specifically, I have the following surely common set of situations: 1. user submits info to db --how best to screen out html / escape special characters on insert 2. info is publicly displayed -- how best to unescape special characters for display 3. user edits their submission in form populated with their existing data --again, to screen, but not have the escape characters multiply crazily 4. user updates db --again, without additional of exciting new escape characters I'm getting a bit mixed up through all the stages, and if someone would take pity and walk me through this, I, um, would thank you sincerely. TIA, Andrew When inserting, use this: When extracting, use this: htmlspecialchars does this: '&' (ampersand) becomes '&' '"' (double quote) becomes '"' when ENT_NOQUOTES is not set. ''' (single quote) becomes ''' only when ENT_QUOTES is set. '<' (less than) becomes '<' '>' (greater than) becomes '>' addslashes does this: Returns a string with backslashes before characters that need to be quoted in database queries etc. These characters are single quote ('), double quote ("), backslash (\) and NUL (the NULL byte). stripslashes strips all slashes added by addslashes. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Help Needed with malfunctioning query
Chris Payne wrote: Hi there everyone, This line of code USED TO WORK but now it gives me a Coudln't Execute Query error: $query2 = "SELECT word,def,photo MATCH(word,def) AGAINST ('$txtsearchword' IN BOOLEAN MODE) AS m FROM dictionary WHERE MATCH(word,def) AGAINST ('$txtsearchword' IN BOOLEAN MODE) LIMIT $offset, $item_perpage"; I tried it with a basic $query2 = "SELECT * FROM dictionary"; to make sure it wasn't something else that was broke and this is the problem above, it used to work great and now it's on a live site after working great for 6 months and it suddenly doesn't work and I haven't touched anything !!! the server hasn't been updated so it's not that as it also does the same on my local dev machine here, the only thing that happened was my co-worker did a global find and replace with dreamweaver but that's all and I can't personally see anything wrong with the above though I could be looking too hard. Any help would REALLY be appreciated as this is on a very popular website and needs fixing ASAP so I don't lose my head !!! Chris I tested your SQL on http://developer.mimer.com/validator/parser200x/index.tml#parser and got this: Result: SELECT word,def,photo MATCH(word,def) AGAINST ('$txtsearchword' ^ ^ syntax error: , correction: JOIN ON ) , syntax error: ) correction: = IN BOOLEAN MODE) AS m FROM dictionary WHERE MATCH(word,def) AGAINST ^--^--- ^ ^-- syntax error: BOOLEAN correction: ( syntax error: FROM correction: ) FROM syntax error: MATCH correction: syntax error: ) AGAINST correction: = AGAINST ('$txtsearchword' IN BOOLEAN MODE) LIMIT $offset, $item_perpage ^-- ^ ^ syntax error: BOOLEAN correction: ( syntax error: LIMIT $ offset , correction: , syntax error: $ item_perpage correction: item_perpage ^ syntax error: expected: ( ) * + , - -> . / :: < <= <> = > >= [ || AND AS AT BETWEEN COLLATE DAY HOUR IN IS LIKE MATCH MEMBER MINUTE MONTH MULTISET NOT OR OVERLAPS SECOND SIMILAR SUBMULTISET YEAR correction: ) ) Hope it helps :) -- Bekko -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: cannot connect to mysql on windows
raj wrote: Hello, I have apache 2 and mysql 4.1 and php5 and am unable to connect to mysql database server, and keep getting the following error: Fatal error: Call to undefined function mysql_connect() in D:\backup\test.php on line 10 I have removed the semicolon before the line: extension=php_mysql.dll I do have the extension at C:/php/ext/ also, I even have the server running but no luck. Please help. Raj Does it include MySQL information when phpinfo(); is called? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Help need please?
JeRRy wrote: Hi, I know this is not PHP/MySQl related but every other board I have posted on I have not got a response, so I'll try here also. I'm missing something basic, surely here so that is another reason I am posting here.. Here goes... I have two lots of code here, one is for a refreshing text code in Javascript and another is a banner refreshing ad system. Using similiar technequies. But I can only get the refreshing text to appear but can't get the ads to work on the one page. :( But if I add a " in any text area of the text refreshing than the ads system works but the text refreshing don't. But if I remove the " from any text area the text refreshing works but the ads don't. I can't seem to find the problem. Here is the code(s) ads code hexinput=255 // Initial color value. var inc=-1 //increment variablefunction fadingad(){ if(hexinput>0) { hexinput-=11; // increase color valuedocument.getElementById("fader1").style.color="rgb("+hexinput+","+hexinput+","+hexinput+")"; // Set color value.setTimeout("fadingad()",20); }else hexinput=255 //reset hex value } function changead(){ if (!document.getElementById) return inc++ if (inc==0) document.getElementById("fader1").innerHTML="" else if (inc==1) document.getElementById("fader1").innerHTML="" else if (inc==2) document.getElementById("fader1").innerHTML="" else if (inc==3) document.getElementById("fader1").innerHTML="" else if (inc==4) document.getElementById("fader1").innerHTML="" else if (inc==5) document.getElementById("fader1").innerHTML="" else if (inc==6) document.getElementById("fader1").innerHTML="" else{ document.getElementById("fader1").innerHTML="" inc=-1 } fadingad() setTimeout("changead()",4000) } window.onload=changead end ads code text refreshinghexinput=255 // Initial color value. var inc=-1 //increment variablefunction fadingtext(){ if(hexinput>0) { hexinput-=11; // increase color valuedocument.getElementById("fader").style.color="rgb("+hexinput+","+hexinput+","+hexinput+")"; // Set color value.setTimeout("fadingtext()",20); }else hexinput=255 //reset hex value } function changetext(){ if (!document.getElementById) return inc++ if (inc==0) document.getElementById("fader").innerHTML="Soon to be Released" else if (inc==1) document.getElementById("fader").innerHTML="What you really need to know about Testing and Tagging" else if (inc==2) document.getElementById("fader").innerHTML="250 Pages of jam-packed reality testing regimes that will maintain a safer working environment for all" else if (inc==3) document.getElementById("fader").innerHTML="Learn what's it all about before they come and do it for you - A must read for all Clients, Employers, Electricians and Competent Persons" else if (inc==4) document.getElementById("fader").innerHTML="Just when you thought you knew what testing and tagging was all about - along comes a book!" else if (inc==5) document.getElementById("fader").innerHTML="Memberships available" else if (inc==6) document.getElementById("fader").innerHTML="Are you really doing it right?" else{ document.getElementById("fader").innerHTML="Pre-order and Save" inc=-1 } fadingtext() setTimeout("changetext()",8000) } window.onload=changetext end of text refreshing Any help would be awsome, or solutions? Jerry - Do you Yahoo!? Messenger 7.0: Free worldwide PC to PC calls This is not at all PHP related. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Formatting a form box
Miguel Guirao wrote: One approach is to ask the user to input a text delimiter, like a "@", for example, in every point where there should be a new line or paragraph. Then, you should parse the text, and at every point you find a "@", tu place a "" or "" or any other HTML tag that best suits your need!! This is just one solution, but I'm pretty sure there others!! Mike Guirao -Original Message- From: Alex Major [mailto:[EMAIL PROTECTED] Sent: Jueves, 12 de Enero de 2006 10:33 a.m. To: php-db@lists.php.net Subject: [PHP-DB] Formatting a form box Hi there, On one of my forms, there is a section where users can put images etc..and then it is displayed on my php pages. My question is how do I make it so that the html formatting is automatically done. For example when someone is typing something, and wants to start a new paragraph although they press return when typing when the data is displayed from the MySQL database on a website it's just continuous text. For it to start a new paragraph they have to put in when they are typing in this box. They do not know all the html formatting codes, and so I need someway of making so that it is easy for them to have formatted text without doing all the html. Also things like changing colours, bold, italic and things would be good. Something like on forums, where when you enter a new post you have all the formatting options. Hope this makes sense, Regards, Alex. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Este mensaje es exclusivamente para el uso de la persona o entidad a quien esta dirigido; contiene informacion estrictamente confidencial y legalmente protegida, cuya divulgacion es sancionada por la ley. Si el lector de este mensaje no es a quien esta dirigido, ni se trata del empleado o agente responsable de esta informacion, se le notifica por medio del presente, que su reproduccion y distribucion, esta estrictamente prohibida. Si Usted recibio este comunicado por error, favor de notificarlo inmediatamente al remitente y destruir el mensaje. Todas las opiniones contenidas en este mail son propias del autor del mensaje y no necesariamente coinciden con las de Radiomovil Dipsa, S.A. de C.V. o alguna de sus empresas controladas, controladoras, afiliadas y subsidiarias. Este mensaje intencionalmente no contiene acentos. This message is for the sole use of the person or entity to whom it is being sent. Therefore, it contains strictly confidential and legally protected material whose disclosure is subject to penalty by law. If the person reading this message is not the one to whom it is being sent and/or is not an employee or the responsible agent for this information, this person is herein notified that any unauthorized dissemination, distribution or copying of the materials included in this facsimile is strictly prohibited. If you received this document by mistake please notify immediately to the subscriber and destroy the message. Any opinions contained in this e-mail are those of the author of the message and do not necessarily coincide with those of Radiomovil Dipsa, S.A. de C.V. or any of its control, controlled, affiliates and subsidiaries companies. No part of this message or attachments may be used or reproduced in any manner whatsoever. The nl2br() function is way better because you don't change email adressess. And for the colours and stuff... just put a small note on the bottom of your post page what HTML tags they are allowed to use. Greets, El Bekko -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Bit(1) datatype from mySQL
Larry Bradley wrote: Greetings: I'm new to PHP, although I've been a programmer all my life. I had been doing a bit of web database work with VB Script and ASP and mySQL, and then decided to try PHP. I've run into a couple of things that bother me. I have boolean fields (i.e. bit(1)) in the mySQL database. When I retrieve data from the mySQL server into an array or an object, it seems as if all the data fields are returned as characters. For most data types this does not matter, since PHP will handle them properly. This an integer 46 being retrieved as a character '46' is OK. However, the boolean is a curse, as it comes back as a character containing hex 00 or hex 01, and I have to use a test such as: if (ord(IsAMember) == 0) ... I can't just treat it as a boolean. I have got around the problem by using a construct such as: select if(IsAMember,1,0) as IsAMember in the SQL select, but this is a bit of a pain. Any thoughts? Thanks Larry Bradley Orleans (Ottawa), Ontario, CANADA Try using a set() field with values true and false -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: retaining and displaying line returns in a text field
Frank Flynn wrote: This is an HTML issue (not PHP or MySQL) that is HTML ignores carriage returns (and most other white spaces). There are two simple solutions: use tags: echo " $rmks"; Or replace the \n with "" $newRmks = str_replace ( "\n", "", $rmks ); echo $newRmks; You can do this going into or coming out of the database but remember to be consistent. And you can do more with paragraphs and changing tabs and other special characters - there are probably some libraries that will all this and much more (including some WISIWYG editors that you can put on your web page) depending on how deep you want to get. Good Luck, Frank On Jan 6, 2006, at 2:45 PM, [EMAIL PROTECTED] wrote: From: "swoll2" <[EMAIL PROTECTED]> Date: January 6, 2006 3:34:52 AM PST To: php-db@lists.php.net Subject: retaining and displaying line returns in a text field Good morning - I'm trying to get a text field with line returns in it to be stored, retrieved, and displayed the way it gets entered. Specifically, my users use a form field (html textarea) to enter some remarksas they enter their remarks, they can hit Enter to insert a hard return, which is reflected in the textarea on their screen. Example entry: this is line1. this is line2. this is line3. Those remarks get uploaded into a mysql db, into a field defined as a text field named rmks. If I use PhpMyAdmin to browse the table, it shows the entry with the lines separated, but there are no /n's or other control characters visible. Later, the field is retrieved from the db using a php script and assigned to a variable $rmkswhen I echo $rmks, it displays on a single line without the line returns, like this: this is line1.this is line2.this is line3. I have tried to work with addslashes and stripslashes, but neither has worked. I think I'm just missing something basic Appreciate any help or points to previous discussions..thanks...Steve When echoing, use this: echo nl2br($rmks); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] isset or ! isset what is my problem?
On Monday 02 January 2006 7:54 pm, Ralph wrote: I'm building a URL based on data extracted from mySQL and I want the text space.gif used as my default value should the variable $picture by NULL. The results of the code below kick back a value for $picture when it is set in the database, but ignores the space.gif if the database result is empty. If I flip the test from ! isset to isset then I get the space.gif for each result. I've had no luck searching out an answer. Thanks in advance. --The Code- Showtime: Location: ---END- Seeing as you're querying, use mysql_num_rows() to check. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Inserting a php file into a mysql database
Thomas Bonham wrote: Hello, I am trying to insert a php page into a database. I need to know if there is something that I need to do when setting up the table, also is there something to do with the code. Thank You for your help Thomas Use file_get_contents() I'd say... but you'll have the problem the file executes :S -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Scrolling News
PHP Superman wrote: Hi, just to tell you scrolling text boxes are javascript, PHP is server side not client side, PHP can only get the data from the table and javascript will display it On 12/22/05, Alex Major <[EMAIL PROTECTED]> wrote: Hi there. I'm trying to make a scrolling news box for my website. Basically I would like this news box to get information from a column in my database called 'news_title' and display it in a scrolling news box. The reason I'd like it to do this is because there is already a news page on my website, which stores 'news_date' , 'news_poster' , 'news_title' , 'news_description' , 'news_content' in a table on my database. I'd just like to increase the functionality of this by having this news box on my front page, which scrolls the 'news_title'. Any suggestions for how to go about doing this? I'm still very new to php. Regards, Alex. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Hi Everyone, I am running PHP 5 on Windosws XP SP2 with MySQL5, Bye Now! If you want an easy way of letting text scroll, use tags -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: CLOSE button or link
Ron Piggott (PHP) wrote: I am building a Christian ministry web site. One of the things we are establishing is an online offering basket to receive donations. One of our disbursements is a benevolent fund to help others. I have a 'how we operate our benevolent fund' web page online at http://www.actsministrieschristianevangelism.org/financial/how_we_operate_our_benevolent_fund.html I also have this file set to load from our online offering basket web page at http://www.actsministrieschristianevangelism.org/financial/online_offering_basket.html as a pop up window by clicking a submit button. What I really want to have happen is for the CLOSE WINDOW button to appear when this is loaded as a pop up window from our online_offering_basket.html file and if the web page is loaded directly then the link to our Online Offering Basket appear for the user to get back into our web site. Do you know how to do this? Ron Close -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: RSS/XML
Henry Ortega wrote: I want to put a website's RSS feed on my website. For example, http://beccary.com/feed/ I want to put all the titles of that blog page on my website. Is there an easy way to do this? I wrote a tutorial on RSS creation in PHP: http://icstrategy.midgetforhire.com/RSS/Tutorial/RSS%20Tutorial.html Have fun with it :) El Bekko -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: RSS/XML
Henry Ortega wrote: I want to put a website's RSS feed on my website. For example, http://beccary.com/feed/ I want to put all the titles of that blog page on my website. Is there an easy way to do this? Because they're all in a DB, yes, very easy :) Just build your RSS feed through PHP. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Date Formatting Question
Bomgardner, Mark A wrote: I am trying to format the month portion of a date that I am trying to pull from MySQL to be placed into a drop down menu to modify the date. I have tried several ways and none seem to be working. I am pulling the date out of MySQL with: $sDate = explode("-", $row_events['Sdate']); And then attempting to insert each portion of the array into a drop down menu with: echo ""; echo "$sDate[1]"; which is where I am running into the problem. I pull out the month as 2 digit numeric 01, 02, 03 etc., but I want it displayed as January, February, March, etc., I have tried the following with no success: Date("F",strtotime($sDate)); Strftime("%B:,$sDate); Date("F",$sDate); I would use MySQL to format the date, but I have three date fields to modify and it would be easier to do it in PHP Any pointers would be appreciated. Mark Bomgardner Technology Specialist KLETC make a function like this: function datenum2str($date) { $newdate = str_replace("01","Jan",$date); $newdate = str_replace("02","Feb",$date); $newdate = str_replace("03","Mar",$date); $newdate = str_replace("04","Apr",$date); $newdate = str_replace("05","May",$date); $newdate = str_replace("06","Jun",$date); $newdate = str_replace("07","Jul",$date); $newdate = str_replace("08","Aug",$date); $newdate = str_replace("09","Sep",$date); $newdate = str_replace("10","Oct",$date); $newdate = str_replace("11","Nov",$date); $newdate = str_replace("12","Dec",$date); return $newdate; } And then use this: echo ""; echo "$newdate"; Hope it helps, El Bekko -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Character encoding issues: Pound- sign "£" becomes a "ú" - why?
Alex Gemmell wrote: Hello, I'm experiencing some odd character encoding issues. My PHP webpage is displaying test from a MySQL database. What happens is that I export data from an SQL Server database to a MySQL (4.0) database. Somewhere along the line the British currency pound-sign "£" becomes a "ú" (u with somesort of accent on it!). I cannot figure out why this is happening and what to do about it. I could use a PHP routine to find-and-replace the chars but surely there is a way to tackle the root problem? Any ideas gang? Alex Try using the £ charachter. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: formatting a date from mysql
Eternity Records Webmaster wrote: I need to figure out how to format the date format: year-month-day (2005-12-06). It is a date(8) field in a mysql table that i pulled out of the table with php 5.0.5. I need it in the format: Tue December 6, 2005 (or in mysql's formatting: 6-12-2005). I am using the reformatting for display only. So it would be something like this: echo $journal['Date']; //with whatever formatting needed If possible I need php to do the formatting for me. Thanks... An easy way to do it: -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: ftp_put
Chris Payne wrote: Hi there everyone, I'm using FTP to upload a file from a form, the information is stored in a MySQL DB and then FTP'd to the server. Is it possible - without altering the php.ini file as I don't have access to this on my clients server - to be able to upload large files rather than small ones? I know with POST there are limits, but we're talking about megabytes rather than KB's needing to be uploaded. They HAVE to be uploaded via some kind of form as it sends the data to a database such as the file name and location so that it can easily be found by the system otherwise I'd just tell them to use normal FTP software. What's the best way of achieving this? I'm talking file 5-20megs in size. Thanks everyone. Chris Max size defined in PHP.ini is 2MB, and I don't think you can change that without having access to the file... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: SQL Insert INTO question
geekgirl1 wrote: First time poster. This is the problem. I want to add the value of $_POST[review] to the reviews table where the unique id from the reviews table equals the review id on my form. The statement below does not work. Should I use UPDATE instead? "INSERT INTO reviews (review_txt) VALUES ('$_POST[review]') WHERE review_id = $id"; Marian "INSERT INTO reviews (review_txt) VALUES ('$_POST[\'review\']') WHERE review_id = '$id'"; There, now it should work :) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: SELECT & html
Ron Piggott (PHP) wrote: I would like to display the contents of my table with the first row being grey in background and the next row being white and the third row being grey, fourth being white, etc. I am not sure how to do this. Well, that's pretty easy to do actually :P You have your while() statement to execute your displaying part. In there, you add some if()'s I'll use an example for 20 posts. An example: $array1 = array(1,3,5,7,9,11,13,15,17,19) all the rest"; } else { --some code-- echo "all the rest"; } --more code-- } ?> This is a really easy way to do it, and I guess it works :) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: problem of transmitting variable from page to another page.
Mohamed Yusuf wrote: I am transmitting variable from one of my pages and I would like to match that variable into mysql data. it won't return data. my code is this. $j |"; if ($j == Z) { break; } } ?> this code in my index page prints alphabetical letters from A-Z. and I woul like to transmit that variable into my alpha.php page and select mysql database what ever the value of $j is, but i have problem I can't figured out what is wrong. can somebody help me. Try $j |"; if ($j == Z) { break; } } ?> I'm using a similar thing, except my data comes from a database and then refers to a page. And it works fine (check http://icstrategy.midgetforhire.com/Strategies.php). If this doesn't work, it's odd :P -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: IS_NUMERIC ?
http://php.belnet.be/manual/en/function.is-numeric.php Apparently there is :) Dwight Altman wrote: Hello List, Is there an IS_NUMERIC(aCandidateString) function in MySQL that I can run in a query, similar to the various PHP "is_*" functions? I can't seem to find it in the docs (other than a C API IS_NUM macro). I have a field in a database with serial numbers like: ...1234 ...1235 ...1236-A ...1237B and I want to get the last 4 characters of the numeric substring like so: 1234 1235 1236 1237 I should be able to do it in 1 SQL query if there is an IS_NUMERIC equivalent, or else I will probably write a PHP script. Regards, Dwight -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php