PHP SQLite Link Redirection And Counter Script
saudiqbal/PHP-SQLite-Link-Redirection-And-Counter-Script
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
Thank you for trying the PHP SQLite Link Redirection script. You can have a Microsoft looking link redirection service with counter. Now you can post links in different places and if the target link changes you dont have to go back to edit the whole link, just go to linkmanagement folder and edit the link there. To use upload the directory structure to your server. yourdomain.com/goto.php yourdomain.com/linkerror.php yourdomain.com/linkmanagement Change the variables in config.inc.php in linkmanagement folder. Change the username "admin" and password "adminpassword" in index.php file located here if($username == "admin" && $password == "adminpassword") to whatever you want. Change the name of database in $dbname = "LinksRedirect.db"; to some random name to keep it secret. chmod /db folder 777 chmod /db/LinksRedirect.db or whatever name you choose. Run setup.php and then delete the file setup.php To display the count use this code. <?php // Example to show counter from link ID 73, change it to whatever ID counter you want to show. $link = "73"; // Change the below path accordingly. include "linkmanagement/config.inc.php"; $db = new PDO("sqlite:linkmanagement/db/$dbname"); $result = $db->prepare("SELECT Counter FROM Links WHERE rowid = '$link' LIMIT 1"); $result->execute(); $row = $result->fetch(); echo $row['Counter']; ?>
About
PHP SQLite Link Redirection And Counter Script
Resources
Stars
Watchers
Forks
Packages 0
No packages published