Dave Chenell

So after realizing I had been searching for the same answers over and over on StackOverflow, I decided to make a cheat sheet with some super basic references and useful scripts. I now use this file every time I start a new project and its pretty helpful to have it all in once place. I thought I would post the code to my blog incase its helpful to anyone else. Note that I didn’t take the time to generalize all the variables and make it easy for learning. So just pretend all those variables are whatever you want them to be. Also feel free to let me know if any of this code is bad practice. Hope this helps.

You can download the file here http://dl.dropbox.com/u/255297/masterCode.php

<?php
session_start();
include('php/config.php');


// config.php usually has something like this to connect to your DB
$connect=mysql_connect("localhost","your_db_username","password");
mysql_select_db("your_db_name",$connect) or die (mysql_errno().":<b> ".mysql_error()."</b>");

//if you want the page to be private or some combination of public and private
if (isset($_SESSION['username'])) {
include 'header_private.php';
$loggedIn = true;
}
else {
include 'header_public.php';
$loggedIn = false;
//or you can redirect them to a different page here
header ("Location: failpage.php");
}


//if you arent using ajax all the time, it can bee useful (not sure if this is good practice) to keep the current page in a session variable, that way you can easily redirect back to it
//this finds the current URL and stores it in a session variable
$siteURL = "http://" . $_SERVER['HTTP_HOST']  . $_SERVER['REQUEST_URI'];
$_SESSION['siteURL']= $siteURL;

//how I name my sessions for pretty much everything, sesh____
$seshThumb = $_SESSION['image'];
$seshID = $_SESSION['id'];


//this turns a raw UNIX timestamp into a readable date
$TimeStamp = date("F j, g:i a", strtotime($TimeStamp));

// if you have a string that needs modifying. This removes ../ from the string.
$remove_this  = "../";
$correctedString = str_replace($remove_this, "", $String);


//make links clickable
$texts = trim($texts);
while ($texts != stripslashes($texts)) { $texts = stripslashes($texts); }    
$texts = strip_tags($texts,"<b><i><u>");
$texts = preg_replace("/(?<!http://)www./","http://www.",$texts);
$texts = preg_replace( "/((http|ftp)+(s)?://[^<>s]+)/i", "<a href="\0" target="_blank">\0</a>",$texts);


// this very useful function displays line breaks in your displyed text, the same way it was typed in the text area
echo nl2br($text);

// get hold old something is (using a post timestamp) in raw hours (goood for algorithm usage)
$date1 = date('m/d/Y h:i:s a', time());
$date2 = date("m/d/Y h:i:s a", strtotime($TimeStamp));
$diff = abs(strtotime($date2) - strtotime($date1));
$hoursOld = $diff / ( 60 * 60 );
print "    | $hoursOld";


///// FOR SECURITY
$actID = stripslashes($actID);
$comContent = mysql_real_escape_string($comContent);


// Json Array for sending things back to javascript
$response_array = array();
$response_array['status'] = 'success';
$response_array['var'] = 'some varaibles probably';  
echo json_encode($response_array);


// send an email
 $to = "$user";
 $subject = "hey dude";
 $body = "whats cracking?nThis is a new line.nndouble new line";
 $headers = "From: [email protected]" .
     "X-Mailer: php";
 if (mail($to, $subject, $body, $headers)) {
   echo("Message successfully sent!");
  } else {
   echo("Message delivery failed...");
  }
?>
									

<?php
/////////////////////// SQL//////////////////////

//These are from all different projects and none of the variables are standardized, but its useful to see the syntax of each for reference.

// Intense Select Query
"SELECT STARTUPS.stupID, STARTUPS.stupName, STARTUPS.stupThumb, COUNT(ACTIVITY.stupID) AS activity_count
FROM STARTUPS
LEFT JOIN ACTIVITY ON STARTUPS.stupID = ACTIVITY.stupID
WHERE stupClass='stup'
GROUP BY STARTUPS.stupID
ORDER BY activity_count DESC
LIMIT 25";

//Insert
"INSERT INTO COMMENTS (stupID,actID,comContent,comTimeStamp) VALUES ('$seshID','$actID','$comContent', NOW())";


//Delete
"DELETE FROM LIKES WHERE actID='$actID' and stupID='$seshID'";

//Update
"UPDATE posts SET algoScore='$algoScore' WHERE postID='$postID'";


// query format
$query = "query";
$result = mysql_query($query) or die (mysql_error()."We got problems");
$numRows = mysql_num_rows($result); // get the num of rows returned if you need that
while($row = mysql_fetch_array($result)){
  // do stuff
  
}
?>
									

<!--////// JAVASCRIPT /////// -->

<script src="http://code.jquery.com/jquery-1.5.js"></script>



<!-- this script auti resizes a text area when typing -->
<script type="text/javascript"src="js/autoresize.js"></script>
<script type="text/javascript">
    $('textarea#textareaName').autoResize({
        // On resize:
        onResize : function() {
            $(this).css({opacity:0.8});
        },
        // After resize:
        animateCallback : function() {
            $(this).css({opacity:1});
        },
        // Quite slow animation:
        animateDuration : 300,
        // More extra space:
        extraSpace : 20
    });
</script>


<!-- this script toggles the visibility of a DIV whne you press the button with ID of toggle -->
<a id="toggle"href="javascript:void(0);"> Toggle Button </a> 
<script>    
$("#toggle").live("click", function () {
  if( $("#a_comment").is(":visible") ) {
    $("#a_comment").hide();
  } else {
    $("#a_comment").show();
    $("#a_comment textarea#comContent").focus();
  }
});
</script>



<!-- background color change on rollover-->
<script>
$(document).ready(function(){  ;
  //this function brings up the thumbs up and thumbs down on rollover
  $('.div').live('mouseenter',function() {
    $(this).css("background-color","#f5f5f5");
  });
  //this clears it on rollout
  $('.div').live('mouseleave',function() {
    $(this).css("background-color","transparent");
  });
});
</script>




<!-- this is a super condensed AJAX function -->
<script>
$(document).ready(function() {
  //the LIVE is very important if you want it to work more than once
  $(".form").live("submit", function(){
    var comContent = $(this).find("textarea[id^=comContent]").val();
    var actID = $(this).attr("id");
    
   //emptyness validation 
  if (comContent == "") {
      $("label#comContent_error").show();
      $("textarea#comContent").focus();
      return false;
    }
    
  //what we send to the php file
  var dataString = 'comContent='+ comContent + '&actID=' + actID;  
    
  $.ajax({
      type: "POST",
      url: "php/addComment.php",
      data: dataString,
    dataType: "json",
    success: function(msg){ 
          //if it worked
        $("#other-comments" + actID).load("/secrets/index.php #other-comments"+ actID);
        $('textarea#comContent').val("");
            },  
            error: function(){  
        //if it didnt work 
                $("#commentForm").addClass('error');  
                $("#commentForm").html("There was an error submitting the form. Please try again.");  
            }
       });
    return false;
  });
});
</script>
									

You can download the file here http://dl.dropbox.com/u/255297/masterCode.php