Author Topic: Script BASIC XAMMP  (Read 4166 times)

Offline John

  • Forum Support / SB Dev
  • Posts: 3510
    • ScriptBasic Open Source Project
Script BASIC XAMMP
« on: November 03, 2015, 08:21:43 PM »
I installed XAMMP which provides the following services and languages for Windows 32 bit.



  • Apache 2.4.17
  • MariaDB 10.0.17
  • PHP 5.6.14
  • phpMyAdmin 4.5.0.2
  • OpenSSL 1.0.1
  • XAMPP Control Panel 3.2.1
  • Webalizer 2.23-04
  • Mercury Mail Transport System 4.63
  • FileZilla FTP Server 0.9.41
  • Tomcat 7.0.56 (with mod_proxy_ajp as connector)
  • Strawberry Perl 7.0.56 Portable

Attached is phpmyadmin (DB administrator) showing the table the Script BASIC example will be using.

Code: ScriptBasic
  1. ' MySQL Test Program
  2.  
  3. INCLUDE mysql.bas
  4.  
  5. dbh = mysql::RealConnect("localhost","root","","test")
  6.  
  7. mysql::query(dbh,"SELECT * FROM mytable")
  8.  
  9. WHILE mysql::FetchHash(dbh,column)
  10.  
  11. PRINT "| "
  12. PRINT column{"ID"}," | "
  13. PRINT column{"Name"}," | "
  14. PRINT column{"Address"}," | "
  15. PRINT column{"Phone"}," | "
  16. PRINTNL
  17.  
  18. WEND
  19.  
  20. PRINTNL
  21. PRINT "The database handle is: ",dbh,"\n"
  22. PRINT "Affected rows by SELECT: ",mysql::AffectedRows(dbh),"\n"
  23. PRINT "Character set name is: ",mysql::CharacterSetName(dbh),"\n"
  24. PRINT "Last error is: ",mysql::ErrorMessage(dbh),"\n"
  25. PRINT "Client info is: ",mysql::GetClientInfo(),"\n"
  26. PRINT "Host info is: ",mysql::GetHostInfo(dbh),"\n"
  27. PRINT "Proto info is: ",mysql::GetProtoInfo(dbh),"\n"
  28. PRINT "Server info is: ",mysql::GetServerInfo(dbh),"\n"
  29. PRINT "PING result: ",mysql::Ping(dbh),"\n"
  30. PRINT "Thread ID: ",mysql::ThreadId(dbh),"\n"
  31. PRINT "Status is: ",mysql::Stat(dbh),"\n"
  32.  
  33. mysql::Close(dbh)
  34.  
  35. END
  36.  


C:\scriptbasic\examples>scriba testmysql.sb
| aBB-5345 | Mckinney, Alika T. | P.O. Box 153, 5242 Augue, Road | (355) 527-2815 |
| Axz-1367 | Norman, Melvin W. | Ap #200-8145 Risus. Rd. | (534) 909-5062 |
| bce-5299 | Schultz, Reese H. | 1800 Sed, St. | (660) 514-5022 |
| BeS-6986 | Duncan, Quentin N. | P.O. Box 479, 794 Est, Rd. | (530) 609-4637 |
| BhN-6392 | Paul, Addison U. | P.O. Box 446, 6048 Semper Avenue | (502) 398-2610 |
| BHt-5673 | Gould, Christine Y. | Ap #820-7464 Mi St. | (754) 751-6295 |
| Bir-5332 | Lee, Renee G. | 7365 Ligula. Avenue | (388) 414-6554 |
| BIZ-3146 | Cline, Demetrius P. | 700-3761 Auctor, Ave | (774) 705-9299 |
| bto-9775 | Navarro, Len N. | Ap #317-5030 Nunc Rd. | (622) 251-3440 |
| cmm-8273 | Wilder, Casey N. | 7766 Sed, Ave | (176) 612-8960 |
| cTR-8352 | Russo, Amena M. | 491-4584 Fermentum Rd. | (859) 227-4645 |
| cxA-1547 | Hays, April O. | Ap #266-6507 Et St. | (473) 533-2351 |
| daA-6624 | Armstrong, Mikayla H. | P.O. Box 201, 8595 Cras Road | (223) 829-2665 |
| DJi-1444 | Anthony, Chaney R. | P.O. Box 567, 4087 Non, St. | (664) 333-0515 |
| dMG-2544 | Delgado, Erica D. | Ap #532-8883 Quam St. | (638) 614-3131 |
| Dqf-7174 | Pate, Jillian G. | 929 Et Av. | (336) 461-2712 |
| DQx-7923 | Osborn, Francis J. | 513-117 Mi Ave | (397) 672-5287 |
| eBq-4118 | Preston, Ezekiel D. | P.O. Box 739, 9388 Orci. St. | (293) 248-9345 |
| efd-9641 | Glass, Kareem U. | P.O. Box 262, 4258 Mauris Street | (708) 994-0276 |
| eik-7173 | Heath, Deirdre T. | P.O. Box 177, 9950 Nec Rd. | (746) 545-1861 |
| eQz-2825 | Alford, Joshua S. | 3011 Tortor. Road | (978) 495-8171 |
| EXg-7319 | Jarvis, Aladdin H. | 5051 Libero St. | (713) 327-8407 |
| GJW-6893 | Browning, Breanna A. | 514-4209 Donec St. | (865) 384-2335 |
| HeD-2592 | Summers, Kathleen O. | P.O. Box 441, 8268 Eros St. | (401) 844-4737 |
| HkQ-5512 | Valenzuela, Katelyn T. | P.O. Box 464, 8705 Augue Avenue | (524) 181-8501 |
| Hmw-9957 | Day, Jin C. | Ap #399-2940 Convallis St. | (260) 439-6634 |
| HOC-1442 | Rios, Deanna U. | 7685 A, Rd. | (284) 498-1713 |
| hsc-6319 | David, Upton X. | Ap #494-6475 Libero Ave | (432) 406-5078 |
| HSY-1691 | Robbins, Cullen C. | 716-267 Adipiscing St. | (507) 298-5044 |
| HTi-6983 | Henson, Yoshi C. | P.O. Box 980, 4147 Cras Ave | (339) 179-4819 |
| Htq-5819 | Koch, Wade U. | 4963 Ut, Road | (112) 651-6285 |
| iHP-9213 | Mann, Jeremy N. | Ap #425-537 Et, Avenue | (401) 529-4170 |
| ImK-3216 | Moon, Derek V. | P.O. Box 203, 7658 Dui. Rd. | (140) 114-7032 |
| Ina-7736 | Brennan, Stacy Z. | P.O. Box 433, 3299 Sagittis Av. | (177) 199-7355 |
| IUV-3476 | Pruitt, Bevis H. | 265-5344 Pede Rd. | (136) 280-9380 |
| Ivd-5997 | Powell, Michelle S. | Ap #145-9570 Ridiculus Av. | (666) 485-6357 |
| iwO-5749 | Adkins, Roth M. | Ap #659-7026 Lobortis St. | (696) 504-1685 |
| Izl-2763 | Dorsey, Jessica A. | Ap #507-5472 Mauris St. | (969) 754-1169 |
| jjZ-2772 | Vance, Madaline N. | 299-9982 Augue Street | (464) 116-6541 |
| jZR-5824 | Washington, Ryan I. | Ap #260-6735 Libero Av. | (765) 332-4435 |
| KCm-5557 | Davidson, Samson J. | 9123 Etiam St. | (452) 195-3682 |
| kjS-3579 | Mcclain, Camden G. | P.O. Box 922, 5345 Litora Av. | (649) 791-2679 |
| KnS-3237 | Cleveland, Solomon V. | 297-9998 Eu Rd. | (507) 200-3835 |
| KQg-6313 | Fletcher, Fay P. | P.O. Box 745, 6184 Mattis Road | (156) 697-3707 |
| kzh-8267 | Hester, Valentine X. | P.O. Box 559, 8575 Nibh Road | (137) 257-0085 |
| lAP-5276 | Mueller, Keiko U. | 171-6397 Consequat Avenue | (796) 158-7229 |
| Lbc-9965 | Bernard, Matthew C. | Ap #289-9113 Nisl. St. | (509) 477-7440 |
| LOa-1329 | Vega, Nasim X. | P.O. Box 634, 9604 Turpis. St. | (657) 540-1634 |
| lOS-4415 | Hobbs, Nigel R. | Ap #569-5483 Libero. Avenue | (489) 585-2468 |
| mFa-8364 | Lester, Lester E. | Ap #993-7151 Ut, Rd. | (656) 628-4093 |
| MfJ-5921 | Cooley, Benedict A. | Ap #412-9145 Felis Street | (124) 712-3662 |
| MSI-3135 | Park, Brenden Z. | 858-8944 Sed St. | (135) 844-9775 |
| msW-2589 | Whitney, Josiah Z. | P.O. Box 695, 8240 In Ave | (792) 856-2484 |
| mzD-9558 | Malone, Anika L. | 7344 Gravida Rd. | (857) 240-8712 |
| ocm-7474 | Mcdaniel, Vincent N. | 552-2251 Sociis Rd. | (484) 224-8496 |
| ODR-2261 | Moore, Reese Y. | 425-6886 Tellus Rd. | (959) 616-7742 |
| Ofi-1649 | Mckay, McKenzie H. | Ap #979-3520 Eu, Ave | (723) 578-7493 |
| oko-6488 | Osborn, Lael R. | 7904 Eget St. | (899) 912-5008 |
| Oot-4624 | Calhoun, Wendy U. | Ap #406-9386 Cursus. Ave | (389) 651-6265 |
| OPU-8973 | Murphy, Silas X. | Ap #765-7804 Neque Avenue | (252) 834-5382 |
| pAM-3573 | Harrison, Simon E. | P.O. Box 487, 9468 Blandit Av. | (520) 272-0010 |
| pcI-3437 | Sharp, Flynn K. | P.O. Box 594, 7598 Mi Street | (813) 805-3046 |
| PeC-4255 | Tillman, Rylee P. | 157-5173 Accumsan St. | (492) 595-7093 |
| PKi-4521 | Brooks, Calista W. | 816-3095 Auctor Av. | (465) 623-7075 |
| pNz-1742 | Mullins, Vladimir L. | 5173 Mi St. | (333) 214-4899 |
| PrH-9372 | Fuller, Hedwig X. | P.O. Box 963, 8679 Eu, St. | (944) 193-0983 |
| pUF-1688 | Burks, Samuel W. | Ap #145-8025 Elit Rd. | (449) 601-1412 |
| Qaw-2493 | Buckner, Norman M. | Ap #707-5695 Donec St. | (215) 513-9805 |
| QFE-6433 | Howell, Karly Q. | P.O. Box 461, 8057 Vivamus Av. | (475) 268-0194 |
| QuJ-9572 | Chan, Cleo S. | Ap #294-9403 Urna. Rd. | (542) 289-2256 |
| QwO-9641 | Nolan, Kiayada U. | 1019 Justo Road | (398) 415-2093 |
| QzW-2678 | Manning, Myra J. | 185-5166 Felis Road | (681) 647-9701 |
| Rfy-1432 | Gray, Imani O. | P.O. Box 258, 514 Vivamus Road | (740) 694-8049 |
| rLT-7576 | Roth, Giacomo K. | Ap #955-690 Proin Avenue | (215) 155-3657 |
| rRV-3796 | Emerson, Warren Q. | P.O. Box 189, 4131 Cras St. | (404) 992-3510 |
| RWh-7535 | Raymond, Idola A. | 5563 In Rd. | (528) 582-7696 |
| SaH-1253 | Wilder, Nora C. | 6709 Auctor Avenue | (561) 210-1884 |
| SjE-2287 | Carter, Tatiana N. | Ap #577-7367 Non, Avenue | (546) 988-1032 |
| smK-1756 | Hale, Castor K. | 826-442 Id Street | (321) 492-9783 |
| smy-3334 | Bass, Eden D. | 555-3464 Eros St. | (386) 234-4708 |
| STR-6819 | Pate, Sloane H. | 781-266 Vel Av. | (552) 319-7270 |
| SUR-8421 | Holloway, Yvette W. | 407 A, St. | (798) 487-0931 |
| SXC-5683 | Mcknight, Daryl Q. | Ap #290-346 Lobortis Rd. | (438) 302-8779 |
| TSE-6895 | Blackburn, Declan F. | 285-4704 Libero Road | (833) 231-3740 |
| tZN-3754 | Young, Scott M. | Ap #674-6038 Nunc, Rd. | (866) 895-4537 |
| uac-8347 | Clarke, Noah U. | P.O. Box 894, 8126 Parturient St. | (836) 981-4830 |
| uUi-1685 | Rice, Regan I. | Ap #560-8751 Ultrices Road | (881) 298-8867 |
| Uwp-7266 | Weaver, Tanya Z. | P.O. Box 499, 1479 Tincidunt Street | (926) 545-0725 |
| VCQ-7963 | Meadows, Medge R. | 944-8179 Sociosqu St. | (213) 609-8486 |
| vep-6727 | Crawford, Felix V. | Ap #788-5925 Suspendisse St. | (726) 263-4285 |
| VME-2567 | Taylor, Kitra W. | Ap #439-3786 Condimentum. Street | (678) 191-9662 |
| vvl-2783 | Salas, Lavinia X. | Ap #907-7442 Nec, Rd. | (697) 932-2335 |
| WTD-1788 | Barber, Kylynn M. | Ap #881-4528 Mauris. St. | (975) 253-0335 |
| Wun-5286 | Simmons, Robert G. | P.O. Box 504, 5785 A, Rd. | (693) 847-2453 |
| xav-3727 | Cole, Rebecca G. | P.O. Box 660, 5395 Phasellus Avenue | (124) 732-1133 |
| xfA-3391 | Mcneil, Ray E. | Ap #419-8870 Non, St. | (527) 402-7106 |
| xlp-1869 | Baker, James U. | 363-1421 Nam Av. | (947) 911-0088 |
| YAg-5658 | Nieves, MacKensie U. | 699-3406 Et Rd. | (753) 611-1883 |
| YnW-8732 | Matthews, Aurora T. | P.O. Box 361, 5767 Arcu Avenue | (567) 496-4540 |
| ZKj-7236 | Whitley, Madeline V. | 1410 Sit Road | (873) 161-1943 |

The database handle is: 1
Affected rows by SELECT: 100
Character set name is: latin1
Last error is:
Client info is: 5.5.39
Host info is: localhost via TCP/IP
Proto info is: 10
Server info is: 5.5.39
PING result: -1
Thread ID: 0
Status is: Uptime: 330  Threads: 1  Questions: 147  Slow queries: 0  Opens: 60  Flush tables: 1  Open tables: 43  Queries per second
 avg: 0.445

C:\scriptbasic\examples>