Facebook Style Hashtag System with PHP, MYSQL & jQuery

22 Responses

  1. Web design company says:

    can’t download after I subscribe , it’s said Email does not exist in our database. Please use below form to subscribe

  2. etenzy says:

    sorry, but the database has a large fault…
    you will need 3 tables, if you want to follow the normal forms…

    1. `messages`
    2. `hashtags`
    3. `message_hashtags`

    CREATE TABLE IF NOT EXISTS `messages` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `message` text COLLATE utf8_unicode_ci NOT NULL,
    `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

    CREATE TABLE IF NOT EXISTS `hashtags` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `hashtag` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

    CREATE TABLE IF NOT EXISTS `message_hashtags` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `messageId` int(11) NOT NULL,
    `hashtagId` int(11) NOT NULL,
    PRIMARY KEY (`id`),
    INDEX (`messageId`),
    CONSTRAINT
    FOREIGN KEY (`messageId`)
    REFERENCES `messages` (`id`)
    ON UPDATE CASCADE
    ON DELETE CASCADE,
    INDEX (`hashtagId`),
    CONSTRAINT
    FOREIGN KEY (`hashtagId`)
    REFERENCES `hashtags` (`id`)
    ON UPDATE CASCADE
    ON DELETE CASCADE,
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

  3. sailesh says:

    can’t download after I subscribe , it’s said Email does not exist in our database. Please use below form to subscribe

  4. syed says:

    Cannot download

  5. utsavgupta says:

    Cannot Download even after Subscribing…Can you please update the subscribers database

  6. Lucas FERRARI says:

    Wow, an incredible easy to use PHP code, thanks 🙂
    It will help me to create my little social network 😉

  7. Ali says:

    hi please update email database .

    i can’t download .

  8. MICKIE says:

    Function is “convert_clickable_links” but U R using convert_links in index.php & update.php
    LINE 18 :

  9. Bobi Ohrid says:

    I need to get this script more faster than 10 hours. Can you please send it to my mail:
    avramoski123@gmail.com
    Thanks

  10. bac vu says:

    please support update my email vubactest1@gmail.com. I just submit subscribed. Thank you so much.

  11. BButter says:

    I can’t download it. I have been subscribe for 2 days ago.

  12. India India says:

    I can’t download it.
    Please accept my subscription, i am still waiting.

  13. Awadhesh Kumar says:

    livemail.awadhesh@gmail.com unable to download, plz update ur db

  14. Bob Mars says:

    mysqli? its ridiculous stop using mysql its PDO OR MYSQLI GET TO 2017 WE ARE NO LONGER IN 2015

  15. Jan Molendijk says:

    I registered as new users subscribe but now 24h later I getting this: Email does not exist in our database.
    I would like to download the script ????

Leave a Reply

Your email address will not be published. Required fields are marked *