Skip to content

Instantly share code, notes, and snippets.

@hcmn
Created September 24, 2012 00:38

Revisions

  1. hcmn revised this gist Sep 24, 2012. 1 changed file with 19 additions and 5 deletions.
    24 changes: 19 additions & 5 deletions todo.php
    Original file line number Diff line number Diff line change
    @@ -1,9 +1,9 @@
    <?php
    // Database Constants to set
    // Database Constants
    define("DB_SERVER", "127.0.0.1");
    define("DB_USER", "");
    define("DB_PASS", "");
    define("DB_NAME", "");
    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";
    $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();
    ?>
  2. hcmn revised this gist Sep 24, 2012. 1 changed file with 2 additions and 0 deletions.
    2 changes: 2 additions & 0 deletions todo.php
    Original 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 ) {
  3. hcmn created this gist Sep 24, 2012.
    90 changes: 90 additions & 0 deletions todo.php
    Original 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();
    ?>