How To Create A Custom Web Development Environment

Promodrone Level 1

February 1, 2015, 7:16 am

Write the reason you're deleting this FAQ

How To Create A Custom Web Development Environment

If you haven't realized it already, you're going to have to have a dedicated web development environment if you hope to grow into a top-flight coding freelancer. A mandatory practice is to employ a local machine web server to host, view and tweak your site/app creation projects. My tool of choice is Uniform Server - is a lightweight solution under the Windows OS.

At only 24MB, its' design model includes the latest versions of Apache2, Perl5, PHP (with the option to switch between PHP53, PHP54, PHP55 or PHP56!), MySQL5 or MariaDB5, phpMyAdmin or Adminer4. It's been my favorite tool since I discovered it. I also recently stepped up to the plate to become a donor and community forum member to contribute to their future development (so, NO, no affiliate promotional here). As there's no installation required, this fact makes for ultra-portability. I have a copy on not only my local machine, but also a few installs to multiple USB memory sticks. Makes it handy to switch between differing projects with no space overlaps.

As an Open-Source project (GNU-licensed), you're able to have access to the full source code to effect your own changes (but, for some of you, that's a LOT further down the road). As a user, you'll always have access to all updates by going to the project download home;

Grab yourself the latest version, unpack to your USB stick of choice and FIRE IT UP!

Comments

Please login or sign up to leave a comment

Join

loulou

Nice tutorial that you have provided for us here.

11 years ago

Are you sure you want to delete this post?

nayandatta

Wow! It's very nice and informative tutorial.

11 years ago

Are you sure you want to delete this post?

Promodrone

Sorry for the lamo poll, but I'm kinda flyin' by the seat of the pants today. PLEASE make your favorite web server known here by reply to this thread. I KNOW there are tons of good ones out there (I started with the ABYSS Web Server a looooonnnng time ago), but it just didn't even occur to me to check for any others (lol!).

11 years ago

Are you sure you want to delete this post?

Promodrone

@loulou, thank you for voicing your appreciation. If I help just one person everyday, I'm good.

11 years ago

Are you sure you want to delete this post?

Avg Time	Count	SQL	Max	Min
0.214384	1	SELECT count(A.PID) as total from posts A , seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND A.USERID=C.USERID AND category IN (50) AND gtags like'%Sport%' AND type !=99	0.214384	0.214384

SEOClerks

How To Create A Custom Web Development Environment

How To Create A Custom Web Development Environment

Comments

Please login or sign up to leave a comment

loulou

nayandatta

Promodrone

Promodrone

Invalid SQL

Expensive SQL

Suspicious SQL

Match	Count	SQL	Script
SELECT * FROM seoclerks.banned_bot_ip WHERE ip='216.73.216.180'	1	SELECT count(id) as total FROM seoclerks.banned_bot_ip WHERE ip='216.73.216.180'	/opt/clerks-staging/docroot/include/functions/includes/security.php 1090 IsIPBannedBot() include_once()
SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400	1	SELECT querystring, added FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400	/opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()
SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='12105'	1	SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='12105'	/opt/clerks-staging/docroot/viewfaq.php 496 () ()
SELECT * FROM seoclerks.members WHERE USERID='287837'	1	SELECT * FROM seoclerks.members WHERE USERID='287837'	/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
SELECT * FROM seoclerks.members WHERE USERID=287837	1	SELECT googleplus_profile FROM seoclerks.members WHERE USERID=287837	/opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() ()
SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=12105 LIMIT 5	1	SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=12105 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='12105' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc	1	SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered, b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b WHERE a.quesid='12105' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc	/opt/clerks-staging/docroot/viewfaq.php 1245 () ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=56159 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=56159 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=56161 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=56161 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=56158 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=56158 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=56160 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=56160 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='12105'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='12105'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='12105' AND status='1' AND (question like '%How Create Custom Web Development Environment%' OR question like '%Create%' OR question like '%Custom%' OR question like '%Development%' OR question like '%Environment%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='12105' AND status='1' AND (question like '%How Create Custom Web Development Environment%' OR question like '%Create%' OR question like '%Custom%' OR question like '%Development%' OR question like '%Environment%') -- ORDER BY RAND() LIMIT 15	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM seoclerks.members WHERE USERID='7' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='7' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='632' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='632' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='2875' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='2875' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='4277' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='4277' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='3302' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='3302' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=12105%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID	1	SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=12105%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM categories	1	SELECT * FROM categories	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()
select * from categories_software order by name asc	1	select * from categories_software order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories()
select * from categories_wanttobuy order by name asc	1	select * from categories_wanttobuy order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories()
select * from categories_wanttotrade order by name asc	1	select * from categories_wanttotrade order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories()
SELECT * FROM seoclerks.members WHERE USERID='287837.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='287837.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
select * from categories_faq order by name asc	1	select * from categories_faq order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()