catalog/site made with jslinb http://catalog.goodfil.com

[sedrok (jslinb.ru)]

http://catalog.goodfil.com

code is readable now, but will be obfuscated on xx/04/2011

if you have some question how i did it, so-
   write on forum or
   mail me korolev@jslinb.ru

[khagans]

Nice work!  Thanks for sharing it with all of us.

[cgetty]

Hi Sedrok1

Thank you very much for sharing your knowledge with US.

Things that I especially appreciate
- You allowed you code to be readable.
I like the way you put the front end together.
I look forward to emulating many of your programing tricks and programing style.
Also this is a comprehensive application (for sure from my prospective). It will
take me some time to really rap my head around this, looking forward to it.

One of the problems I've had is connection up a database. Just want to start out
with something simple link viewing, adding editing deleting a record. I glanced at
your code and see this "SPA" thing and I'm sure Json is somewhere in the mix,
sooner or later I'll get it.

BTW what is the database that you are using?

- The running local feature
I installed on a virtual XP PC (I use Linux) It worked with out a hitch!!
I like the idea of running a mini web server with every configured just so.
This will be another tool I will ad to my bag if tricks.

I look forward to seeing you future endeavors.
Clark

[sedrok (jslinb.ru)]

SPA is a global variable referencing to this object

OS running: win XP
server: Access driver (*.mdb) (maybe will be rewriten to support mysql)

connection made through ODBC

php source like:

<? Con(); $sql="SELECT * FROM ..."; SetRs($sql);   $i = 0; $Data = '['; while (GetNext())   {   if ($i > 0) {      $Data = $Data . ',';   }                                                     $Data = $Data . '{"cells" : [{"value":"' . Field("1") . '"},';      $Data = $Data . '{"value":"' . Field("2") . '"},';      $Data = $Data . '{"value":"' . Field("3") . '"}],"id":"' . Field("4") . '"}';      $i = $i + 1; } $Data = $Data . ']'; echo $Data; Dis(); ?>

[sedrok (jslinb.ru)]

my db.php

<? $conn = 0; $rs = 0; function Con() {    global $conn;    $conn = odbc_connect('tttsss','','');    if (!$conn) {       die("Connection Failed: " . $conn);    } } function Dis() {    global $conn;    odbc_close($conn); } function SetRs($sql) {    global $conn, $rs;    $rs = odbc_exec($conn, stripslashes($sql));    if (!$rs) {       die("Failed: " . $conn);    } } function GetNext() {    global $rs;    $eof = odbc_fetch_row($rs);    return $eof; } function Field($fn) {    global $rs;    $res = iconv("windows-1251","utf-8", odbc_result($rs, $fn));    return $res; } function sutf($txt) {    $res = iconv("utf-8","windows-1251", $txt);    return $res; } function win($txt) {    $res = iconv("windows-1251","utf-8", $txt);    return $res; } ?>