Search the Community
Showing results for tags 'convert'.
-
Say I have this array. $block_io->get_current_price(array()); That array will give me this output. { "status" : "success", "data" : { "network" : "BTC", "prices" : [ { "price" : "1500.01", "price_base" : "AUD", "exchange" : "coinspot", "time" : 1488955012 }, { How can I convert the above output into individual variables? For eg. $status = 'success'; $network = 'BTC'; $price = '1500.01'; ...etc
-
I use PHPMyAdmin. I have to convert an InnoDB table to a MyISAM table. I then have to add a FULLTEXT index to two of the table's columns. Is this how I should proceed? 1) Backup table by exporting its contents. 2) Go to "Relation view" and drop foreign key constraints. 3) ALTER TABLE `table_name` ENGINE = MyISAM; 4) ALTER TABLE `table_name` ADD FULLTEXT index_name (col1,col2); Is that it? Is it safe? Note that the table contains approximately 3,500 rows.
-
I have a php program which accepts the input of the YYYY-MM-DD as the date format and stores it to the database. As soon as the user enters the date with YYYY-MM-DD format (e.g 1990-06-22) how can I convert the 06 (or the MM part) to June as in the 6th month of the year?
-
Hello freaks , I have issue with converting special chars. This is example of string I'm working with: „Quảng Trị” So here we go with bdquo and rdquo quotes and some other stuff with exotic letters (Vietnamese alphabet letters). Of course I'm working with UTF-8 character set. And that's what I need to do with this: 1. I'm using some WYSIWYG script for textarea so that exotic letters should be displayed as Decimal NCRs. I'm saving that field to MySQL database (5.5): [Engine] => InnoDB [Version] => 10 [table_collation] => latin2_general_ci 2. Then I want to retrieve that string from database and display as it is. I was trying with htmlentities(), html_entity_decode(), mb_encode_numericentity() but I'm still confused. I can get these exotic chars with ord() (for example first quote stands for char: 226, 128, 158) then replace to Decimal NCR or name with ampersand, but I have no time and strength to build whole table with conversions, besides re-inventing wheel it's nothing I need here . I found great site to convert strings so this converter for Decimal NCRs working like a charm: http://rishida.net/tools/conversion/ I hope my problem is clearly explained and there's some solution for such things. Thanks for interesting!
-
My brain is currently at it's threshold for processing this sort of thing on it's own, and I've been circling this challenge for hours with no success. Is there a way to take a JSON file (http://us.battle.net/auction-data/6de1a23eb7316db413a62771c8f16b93/auctions.json) And turn it into something I can use with PHP to reorganize and display the data in a way that makes sense? IE: Realm - Player Name - Item ID - Quantity - Bid - Buyout - Timeleft Preferrably in a CSV or MySQL DB so I ca simply foreach() the entire thing I apologise if I am not making a whole lot of sense, I am just at my wit's end.
-
Hey All, I am using a web service and am getting the response formatted like: http://pastebin.com/raw.php?i=AjDXXf66 e.g. [[["test","test","",""]],[["noun",["test","essai","épreuve","examen","contrôle","analyse","interrogation","épreuve pratique","épreuve de force"],[["test",["test"],,0.23752081],["essai",["test","trial","testing","essay","assay","try"],,0.12913783],["épreuve",["test","proof","trial","examination","print","crucible"],,0.028814545],["examen",["review","examination","test","investigation","inspection","testing"],,0.010767208] ... ... ... To my knowledge it is some kind of expression of a multidimentional array however I've never seen a response like this. Is there a way I can convert this format to clean XML?
-
Hello Everyone, I am stuck in a task to change byteArray to Video in php. I am creating a webservice in php. This service will receive video in byteArray format from iphone and need to convert it back to original video. I mean, webservice will receive byte array from POST. I could not find any way of converting byteArray into video. byteArray datatype does not seem to be supported by php. Any help would be appreciated.