Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


squiblo last won the day on September 16 2017

squiblo had the most liked content!

About squiblo

  • Birthday 10/06/1992

Profile Information

  • Gender
  • Location
    Rossendale - Lancashire

squiblo's Achievements

Advanced Member

Advanced Member (4/5)



  1. Do you like how my website looks? What would you change? Does something not look right on your browser? For all those who give up their time and provide feedback (either good or bad) I am giving $30 worth of account credits when my website goes live. http://stage.serverdox.com For Phpfreaks: http://stage.serverdox.com/phpfreaks.txt
  2. Hi everyone, I have spent many many months working on this project and now it's time to let others see. I have developed a website monitoring service that always lets know you the current status of your website no matter where you are via email, SMS and Twitter. For all those who give up their time and provide feedback (either good or bad) I am giving $30 worth of account credits when my website goes live. Things to keep in mind: Is it user friendly? Does anything unexpected happen? What would you improve? Could anything be explained better? Things I really need feedback for: API docs FAQ No matter how big or small your suggestion or feedback is I really do appreciate it!!!! If you know anything about sql injection or csrf, I am giving you permission to try and break it. This will allow me to fix anything I have missed. Please give your feedback to support@serverdox.com http://stage.serverdox.com The website will be up for roughly 2/3 weeks to gather an adequate amount of feedback and then will be taken down to make further changes. Thank you in advance. P.S I've never been this scared in my life, this project is like my baby! For phpfreaks: http://stage.serverdox.com/phpfreaks.txt
  3. I have an array that looks like this... Array ( [0] => Array ( [0] => 2 [1] => Dylan Cross ) [1] => Array ( [0] => 5 [1] => Bob Smith ) [2] => Array ( [0] => 1 [1] => Sarah Park ) [3] => Array ( [0] => 7 [1] => Jane Knowles ) [4] => Array ( [0] => 6 [1] => Harry Hill ) [5] => Array ( [0] => 3 [1] => Jack Rock ) ) How do I sort this array so it is ordered alphabetically by the names so the result will be... Array ( [0] => Array ( [0] => 5 [1] => Bob Smith ) [1] => Array ( [0] => 2 [1] => Dylan Cross ) [2] => Array ( [0] => 6 [1] => Harry Hill ) [3] => Array ( [0] => 3 [1] => Jack Rock ) [4] => Array ( [0] => 7 [1] => Jane Knowles ) [5] => Array ( [0] => 1 [1] => Sarah Park ) ) Thanks
  4. Thanks Andy! I was trying to work it with just 2 tables. Much appreciated!
  5. I'm trying to come up with a mysql database design so I can have a messaging system, much like facebook's. I want users to be able to send and reply to messages to more than one user at a time, and to delete whole threads without removing it from other users. Please help! Any questions please ask! Thanks
  6. I want all my URLs to end with a forward slash (/) e.g. www.website.com => www.website.com/ www.website.com/folder => www.webiste.com/folder/ www.website.com/?u=123 =? www.website.com/?u=123/ This is my current .htaccess file... RewriteEngine On RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule .* - [L] RewriteRule ^profile/(.*)$ profile.php?u=$1 [NC] But I don't know how to modify it so the current Rewrite rule will work with the forward slash rule I want. Please help! Thanks
  7. This is what I got from telnet EDIT: After a few more tests "Got packets out of order" does not appear
  8. I'm current running on a windows machine, telnet is not recognized.
  9. All my web pages connect to MySQL before the html tag by including a php file like so... <?php session_start(); require_once "php/connections/dbconnect.php"; ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" id="#top"> <head> All pages connect successfully apart from one, that does not manage to connect about 1 in 5 times. This is the error that I am getting... And this is the contents on the dbconnect.php... <?php //CONNECT TO DATABASE $connect = mysql_connect("*****", "*****", "*****") or die(mysql_error()); $db = mysql_select_db("*****", $connect) or die(mysql_error()); ?> I have no idea where to start looking because it's such a strange problem. Any idea of what I need to check? Any tips will be appreciated! Thanks
  10. Thanks for the input jamesjann, any more suggestions?
  11. Thank you ngreenwood6, I have a reason for this, lets see if I can explain. When a user clicks thumbUp or thumbDown it will insert a row into "StoryLikes" (if they haven't previously) and will also increment the field "totalThumbUp/totalThumbDown" in the Stories table by 1. This will make it faster for selecting how many likes/dislikes a story has, instead of having to do a COUNT every time. I am sacrificing INSERT and UPDATE speeds for SELECTS speeds. I've tried my best to explain sorry if you don't understand. Thanks for the help!
  12. I have managed to figure out how to use MySQL Workbench EER and I have come up with a design. I'm not sure if it is done correctly, if it's not please let me know. If you think is can be optimized in anyway please let me know aswell. Download http://www.squiblo.com/DBModel.mwb **Download file and open with MySQL Workbench** Thanks
  13. Thanks scootstah, I think I'm going to use a mixture of IP addresses, UserID's and cookies for people that are logged in and people that are logged out.
  14. 10,000,000 rows, not 10,000. Thanks for that REPLACE, never seen it before!
  15. Thanks scootstah, that's what I had in mind but I have a little doubt in my mind with this solution. My website will have dynamic pages (like youtube, adding videos). If I have 1000 "pages" and 10,000 users each visit all of these pages (I know these figures are not true, but I'm trying to plan ahead) that will equal 10,000,000 rows. Something tells me that isn't going to be good, but I have no real evidence to back up my thinking. Is this a problem?
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.