Created
September 24, 2012 00:38
Revisions
-
hcmn revised this gist
Sep 24, 2012 . 1 changed file with 19 additions and 5 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -1,9 +1,9 @@ <?php // Database Constants define("DB_SERVER", "127.0.0.1"); define("DB_USER", "root"); define("DB_PASS", "happy"); define("DB_NAME", "folio"); // 1. Create a database connection $connection = mysql_connect(DB_SERVER, DB_USER, DB_PASS); @@ -34,7 +34,7 @@ function deleteRows () { global $connection; $query = "DELETE FROM todo"; $result = mysql_query( $query, $connection ); $query = "ALTER TABLE todo AUTO_INCREMENT = 1"; $result = mysql_query( $query, $connection ); } # Set task completion flag to 1 using Task Number @@ -51,6 +51,7 @@ function completedTask ( $taskNum ) { # Set task visibility to 0 using Task Number function hideTask( $taskNum ) { global $connection; $newText = "Something"; $query = "UPDATE todo SET visible=0 WHERE id={$taskNum}"; $result = mysql_query($query, $connection); } @@ -65,6 +66,16 @@ function getAllTask() { echo "Task #" . $list[0] . ": " . $list[1] . "<br />"; } } # Displays All Visible Tasks function getHiddenTask() { global $connection; $query = "SELECT * FROM todo WHERE visible=0"; $result = mysql_query($query, $connection); while ( $list = mysql_fetch_array($result) ) { echo "Task #" . $list[0] . ": " . $list[1] . "<br />"; } } # Check for task if ( isset( $_POST['taskName'] ) && $_POST['taskName'] !== "" ) { @@ -89,4 +100,7 @@ function getAllTask() { echo "<br/><br/>"; echo "To-Do List: " . "<br/>"; echo getAllTask(); echo "<br/>"; echo "Hidden List: " . "<br/>"; echo getHiddenTask(); ?> -
hcmn revised this gist
Sep 24, 2012 . 1 changed file with 2 additions and 0 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -34,6 +34,8 @@ function deleteRows () { global $connection; $query = "DELETE FROM todo"; $result = mysql_query( $query, $connection ); $query = "ALTER TABLE todo AUTO_INCREMENT = 1"; $result = mysql_query( $query, $connection ); } # Set task completion flag to 1 using Task Number function completedTask ( $taskNum ) { -
hcmn created this gist
Sep 24, 2012 .There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,90 @@ <?php // Database Constants to set define("DB_SERVER", "127.0.0.1"); define("DB_USER", ""); define("DB_PASS", ""); define("DB_NAME", ""); // 1. Create a database connection $connection = mysql_connect(DB_SERVER, DB_USER, DB_PASS); if ( !$connection ) { die("Database connection failed: " . mysql_error()); } // 2. Select a database to use $db_select = mysql_select_db(DB_NAME, $connection); if ( !$db_select ) { die("Database selection failed: " . mysql_error()); } function setTask( $task ) { global $connection; $query = "INSERT INTO todo (task, completed, visible) VALUES (\"{$task}\", 0, 1)"; $result = mysql_query( $query, $connection ); #echo mysql_error(); } function confirm_query( $result_set ) { if ( !$result_set ) { die("Database query failed: " . mysql_error() ); } } # Delete All Rows from table function deleteRows () { global $connection; $query = "DELETE FROM todo"; $result = mysql_query( $query, $connection ); } # Set task completion flag to 1 using Task Number function completedTask ( $taskNum ) { global $connection; $query = "UPDATE todo SET completed = 1 WHERE id={$taskNum}"; $result = mysql_query($query, $connection); #if ( ) { # echo "Change Success, " . mysql_affected_rows() . " rows affected."; #} else { # echo mysql_error(); #} } # Set task visibility to 0 using Task Number function hideTask( $taskNum ) { global $connection; $query = "UPDATE todo SET visible=0 WHERE id={$taskNum}"; $result = mysql_query($query, $connection); } # Displays All Visible Tasks function getAllTask() { global $connection; $query = "SELECT * FROM todo WHERE visible=1"; $result = mysql_query($query, $connection); while ( $list = mysql_fetch_array($result) ) { #echo print_r($list) . "<br/>"; echo "Task #" . $list[0] . ": " . $list[1] . "<br />"; } } # Check for task if ( isset( $_POST['taskName'] ) && $_POST['taskName'] !== "" ) { $taskName = $_POST['taskName']; #echo $taskName; setTask( $taskName ); } # Check for hide task number if ( isset( $_POST['num'] ) ) { $taskNum = $_POST['num']; hideTask( $taskNum ); } echo "<form name=\"input\" action=\"todo.php\" method=\"post\" >"; echo "<input type=\"text\" name=\"taskName\" placeholder=\"enter task here\"/>"; echo "<br/>"; #echo "<label>Enter Task Number to Hide: "; echo "<input type=\"text\" name=\"num\" placeholder=\"enter task number to hide here\"/>"; echo "<input type=\"submit\" name=\"submit\" />"; echo "</form>"; echo "<br/><br/>"; echo "To-Do List: " . "<br/>"; echo getAllTask(); ?>