Jump to content
The Uniform Server Community

Bill King

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

1 Follower

About Bill King

  • Rank
  1. Hello: Just installed 4.0 and following instructions had both 4.0 and mediawiki up and running in about 15 minutes. Been reading posts etc. but havnt logged in for quite some time. Simply AWESOME! Thanks
  2. Have been investigating alternative method to query a sqlite3 database using tclsh84 ... Initially, I have installed on my PC(s) - tcl/tk( Also, have installed the tclsqlite3 dll. I have multiple (simple) sqlite3 databases which I maintain on my PC(s) and one on the USB stick. The premise was not to rewrite code in PHP (not a PHP guru) and to utilize and modify existing tcl code to query several simple sqlite3 databases... I was not prepared to download more extensions/update PHP etc. at this time. Here is synopsis of this investigation (after various iterations): 1. Created a searchit.html file with a form (action=post) to pass information to searchit.php: note: pass the database name/table/field to query and the search string. 2. With searchit.php I utilized the $_POST[""] (PHP array?) to make the variables that I wanted to pass to the tclsh84 (tcl shell). ie. $searchstring =$_POST["searchstring"]; etc. Built and printed initial HTML code (headers etc.) I then made a call to "tclsh84" and passed (script name: searchit.tcl) and variables to query a database: ie. $output = exec("tclsh84 searchit.tcl $database $table $entry $searchstring"); 3. tclsh84 opens the script (searchit.tcl) and reads in the variables - loads tclsqlite3 and performs the query (as coded in searchit.tcl script). This builds a variable that I called "page" to return to searchit.php. note: variable "page" is 1 string (containing results with HTML code in order to build a table as well as highlight the search string(color red) in textual results etc. ) 4. The searchit.php script then prints the information received ($output) from tclsh84 ie. print $output; The searchit.php script then prints out final HTML code and new html page produced. Lessons learned: 1. PHP - likes 1 string (with no breaks/newlines) returned from calls and remember those ";'s" in PHP. 2. I thought this approach would bog down; but Uniform Server proved to be pretty quick. I am impressed with speed on this old PC. 3. Unfortunately this would limit sqlite3 queries to those systems with tcl/tk installed; however, for my purposes this works well.... 4. Considering using this same approach using Python...... Cheers! wjk
  3. Hello: As a user of FreeMind I decided to try it out with the Uniform Server - this what I did successfully and thought it might be useful information: 1. under www - placed freemindbrowser.jar 2. under www - placed freemindbrowser.html 3. under www - created directory maps - place a FreeMind map there 4. under www/maps - created a directory images - and place an image there (image used by my test map). 5. Edited map and inserted image using browse function of FreeMind to make sure I was getting to image 6. Edited freemindbrowser.html to put in following path to my test map to access test.map .....VALUE="./maps/test.mm"> 7. To access/display map - type in following URL: http://localhost/freemindbrowser.html FreeMind - SourceForge Hope that this may be useful wjk
  • Create New...