2014-10-07 - Re: CSV from Mysql Database ??? example

Header Data

From: bartosz <ba***z@miklaszewski.com>
Message Hash: 56a497f801a87f46c9ec88eedff7d428d3472698298fbae58ad74fc0723fd835
Message ID: <6a9757a3-3a54-4ee3-bc12-8c5dd80ee95e@grasehotspot.org>
Reply To: <9f92baa2-d4ad-4104-826a-ee7975da07ed@grasehotspot.org>
UTC Datetime: 2014-10-07 16:36:41 UTC
Raw Date: Tue, 07 Oct 2014 16:36:41 -0700

Raw message 

Ive mess up the title, suppost to be SCV to MySQL to HTML :) Sorry :)






On Wednesday, 8 October 2014 00:35:29 UTC+1, bartosz wrote:
>
> hi guys just been messing around, after Tim mention about CSS and HTML 
> tickets, looks it will be very good idea :)
> tried my self. For example, in batch list, to add option to print to html, 
> (and html will get batch from mysql and print in html formated with css, 
> this is what i did to test it: (no CSS yet)
>
> database imported from csv to mysql:
>
>
> <https://lh4.googleusercontent.com/-nC9p9JC99Ew/VDR389hEvHI/AAAAAAAAKqU/pSxLtuCegjY/s1600/Screenshot%2Bfrom%2B2014-10-08%2B00%3A27%3A09.png>
>
> then:
>
> <?php
> $dbhost = 'localhost:3036';
> $dbuser = 'root';
> $dbpass = 'password';
> $conn = mysql_connect($dbhost, $dbuser, $dbpass);
> if(! $conn )
> {
>   die('Could not connect: ' . mysql_error());
> }
> $sql = 'SELECT username, password, expiry, type FROM barttable';
>
> mysql_select_db('bart');
> $retval = mysql_query( $sql, $conn );
> if(! $retval )
> {
>   die('Could not get data: ' . mysql_error());
> }
> while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
> {
>     echo "Username:{$row['username']}  <br> ".
>          "Password: {$row['password']} <br> ".
>          "Expiry: {$row['expiry']} <br> ".
>          "Type: {$row['type']} <br> ".
>          "--------------------------------<br>";
> } 
> echo "Fetched data successfully\n";
>
> mysql_close($conn);
> ?>
>
> as a resault html file:
>
> Username:Username 
> Password: Password 
> Expiry: Expiry 
> Type: Voucher Type 
> --------------------------------
> Username:6fe6leud 
> Password: tunbad333 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:un89heuf 
> Password: fac898low 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:9te8novi 
> Password: givhek355 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:og49buaw 
> Password: bej148lil 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:as9ab2ga 
> Password: daknub488 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:uf8og4ro 
> Password: tuwcar795 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:ek1ap2ep 
> Password: ticsek284 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:5ti2keak 
> Password: wacpam438 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:1lo5zoor 
> Password: hac667mad 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:1coug5bu 
> Password: mak684wiz 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:5riad7ob 
> Password: nup595gun 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:3cu6vame 
> Password: nid513nas 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:2maov6en 
> Password: vajtoj659 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:1ni6cois 
> Password: natgim934 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:ak2un3jo 
> Password: votkaf845 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:5di9hoaj 
> Password: hop196nas 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:6beet2wo 
> Password: roctan497 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:in8iz1up 
> Password: dimpit883 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:6se6heje 
> Password: lus768mom 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:uk24fooz 
> Password: firroz295 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:ev57wawi 
> Password: mop342bih 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:ej6er7pi 
> Password: kam216car 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:8soer9ub 
> Password: ridzev463 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:ak8ol6ok 
> Password: kot168cid 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:ud7ir1uk 
> Password: duhvol958 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:ir3ol1uc 
> Password: jenref625 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:an5og5nu 
> Password: hippek985 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:if77gate 
> Password: den211fir 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:2te1buod 
> Password: salcad749 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:4dauf9fo 
> Password: vic341mow 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:or67juec 
> Password: jalsuh783 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:3mu9moiz 
> Password: zam836fur 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:3riiv3uw 
> Password: zut162sug 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:of15boad 
> Password: degbok574 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:el2id8al 
> Password: zim358jep 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:6mu5jait 
> Password: tok513zot 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:od49situ 
> Password: lan627bob 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:im6af1ew 
> Password: buzzez417 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:ut79maik 
> Password: topfav469 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:3keup5id 
> Password: cow667muc 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:6bo4nuwu 
> Password: moz751vaj 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:aj67fuih 
> Password: fad159gen 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:iz71veko 
> Password: cij589wek 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:4no1jewa 
> Password: bis936nej 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:8vaez8ke 
> Password: zofked267 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:is6ip7is 
> Password: mit914sim 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:1ca5jolo 
> Password: doh365tim 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:an6af8af 
> Password: cobdut136 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:4puac5pu 
> Password: tor527hub 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Username:5ma3pead 
> Password: nuc552moc 
> Expiry: Apr 7 2015 01:49:51 
> Type: Ministry 
> --------------------------------
> Fetched data successfully 
>
>
> will try to play with css now will see what happen :)
>
> what you think ? :)
>
>
>
>
>
>
>
>
>
>
>
>

Thread