SitePoint Sponsor

User Tag List

Results 1 to 7 of 7

Thread: event_update php page

  1. Oct 20, 2011 21:46 #1
    begeiste
    begeiste is offline
    SitePoint Addict
    Join Date
    Jun 2004
    Location
    U.S.
    Posts
    257
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    event_update php page

    Hi,

    I knew how to make insert into in sql statement as well as delete. But never learned how to update the record on mysql database and php page. Could anyone please give some tips to make the update.php page? Can I tweak this event_add.php page to be event_update.php page? Any tips would be much appreciated!
    This is my event_add.php page
    PHP Code:
    <?
    require_once("includes/config.php");

    session_start();

    $db_connection = mysql_connect ($DBHost, $DBUser, $DBPass) OR die (mysql_error());  
    $db_select = mysql_select_db ($DBName) or die (mysql_error());

    if(    $use_auth)
    {
        if(!isset(    $_SESSION['admin_id']))
        {
            if ((!isset(    $_POST['USER'])) AND (!isset($_POST['PASS']))) {
                ?>
            <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
            <html>
            <head>
            <title><?php include("titles.php"); ?> - Add Event</title>
            <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
            <link href="images/cal.css" rel="stylesheet" type="text/css">
            </head>
            
            <body>
            <br><br>
            <form name="form1" method="post" action="event_add.php">
              
                <div class=""><span class="">Username:</span><input name="USER" type="text" id="USER"></div>
                <div class=""><span class="">Password:</span><input name="PASS" type="password" id="PASS"></div>
                <div class=""><span class=""></span><input type="submit" name="Submit" value=" login"></div>
                
            <input type="hidden" name="day" id="day" value="<? echo $_GET['day']; ?>">
            <input type="hidden" name="month" id="month" value="<? echo $_GET['month']; ?>">
            <input type="hidden" name="year" id="year" value="<? echo $_GET['year']; ?>">
            <input type="hidden" name="id" id="id" value="<? echo $_GET['id']; ?>">
            </form>
            </body>
            </html>
            <?
                    exit;
            } 
            ELSE
            {
                    $query = "SELECT admin_id FROM ".$TBL_PR."admins WHERE admin_username='".addslashes($_POST['USER'])."' AND admin_password='".addslashes(md5($_POST['PASS']))."' LIMIT 1";
                    $query_result = mysql_query ($query);
                while (    $info = mysql_fetch_array($query_result))
                {
                        $admin_id = $info['admin_id'];
                }
            
                IF(isset(    $admin_id))
                {
                        $_SESSION['admin_id'] = $admin_id;
                }
                ELSE
                {
                        header("Location: event_add.php?day=".$_POST['day']."&month=".$_POST['month']."&year=".$_POST['year']."&id=" . $_POST['id']);
                    exit;
                }
            }
        }
    }

    IF(isset(    $_POST['submit']))
    {
            $db_table = $TBL_PR . "events";
        
            $_POST['description'] = substr($_POST['description'],0,1500);
            $_POST['title'] = substr($_POST['title'],0,100);
            $_POST['pic'] = substr($_POST['pic'],0,255);
            $_POST['purl'] = substr($_POST['purl'],0,255);
            $_POST['vurl'] = substr($_POST['vurl'],0,255);

            mysql_query("INSERT INTO $db_table ( `event_id` , `event_day` , `event_month` , `event_year` , `event_time` , `event_title` , `event_desc`, `event_pic`,`event_purl`,`event_vurl` ) VALUES ('', '".addslashes($_POST['day'])."', '".addslashes($_POST['month'])."', '".addslashes($_POST['year'])."', '".addslashes($_POST['hour'].":".$_POST['minute'])."', '".addslashes($_POST['title'])."', '".addslashes($_POST['description'])."','".addslashes($_POST['pic'])."','".addslashes($_POST['purl'])."','".addslashes($_POST['vurl'])."')");
            $_POST['month'] = $_POST['month'] + 1;
    ?>
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html>
    <head>
    <title><?php include("titles.php");?></title>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <script language='javascript' type="text/javascript">
    <!--
     function redirect_to(where, closewin)
     {
         opener.location= 'index.php?' + where;
         
         if (closewin == 1)
         {
             self.close();
         }
     }
      //-->
     </script>
    </head>
    <body onLoad="javascript:redirect_to('month=<? echo $_POST['month'].'&year='.$_POST['year']; ?>',1);">
    </body>
    </html>
    <?
    }
    ELSE 
    {
    ?>
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html>
    <head>
    <title><?php include("titles.php");?></title>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <link href="images/cal.css" rel="stylesheet" type="text/css">
    </head>
    <body>
    <div class="eventFormControl">
    <form name="form1" method="post" action="">
          <div class="eventDateControl"><span class="addevent">Event Date</span><br> 
            <span class="addeventextrainfo">(MM/DD/YY)</span></div>
          <div class="formMenuControl"> 
            <select name="month" id="month">
               <option value="12" <? IF($_GET['month'] == "12"){ echo "selected"; } ?>>12</option>
            </select> <select name="day" id="day">
              <option value="1" <? IF($_GET['day'] == "1"){ echo "selected"; } ?>>01</option>
              <option value="2" <? IF($_GET['day'] == "2"){ echo "selected"; } ?>>02</option>
              <option value="3" <? IF($_GET['day'] == "3"){ echo "selected"; } ?>>03</option>
              <option value="4" <? IF($_GET['day'] == "4"){ echo "selected"; } ?>>04</option>
              <option value="5" <? IF($_GET['day'] == "5"){ echo "selected"; } ?>>05</option>
              <option value="6" <? IF($_GET['day'] == "6"){ echo "selected"; } ?>>06</option>
              <option value="7" <? IF($_GET['day'] == "7"){ echo "selected"; } ?>>07</option>
              <option value="8" <? IF($_GET['day'] == "8"){ echo "selected"; } ?>>08</option>
              <option value="9" <? IF($_GET['day'] == "9"){ echo "selected"; } ?>>09</option>
              <option value="10" <? IF($_GET['day'] == "10"){ echo "selected"; } ?>>10</option>
              <option value="11" <? IF($_GET['day'] == "11"){ echo "selected"; } ?>>11</option>
              <option value="12" <? IF($_GET['day'] == "12"){ echo "selected"; } ?>>12</option>
              <option value="13" <? IF($_GET['day'] == "13"){ echo "selected"; } ?>>13</option>
              <option value="14" <? IF($_GET['day'] == "14"){ echo "selected"; } ?>>14</option>
              <option value="15" <? IF($_GET['day'] == "15"){ echo "selected"; } ?>>15</option>
              <option value="16" <? IF($_GET['day'] == "16"){ echo "selected"; } ?>>16</option>
              <option value="17" <? IF($_GET['day'] == "17"){ echo "selected"; } ?>>17</option>
              <option value="18" <? IF($_GET['day'] == "18"){ echo "selected"; } ?>>18</option>
              <option value="19" <? IF($_GET['day'] == "19"){ echo "selected"; } ?>>19</option>
              <option value="20" <? IF($_GET['day'] == "20"){ echo "selected"; } ?>>20</option>
              <option value="21" <? IF($_GET['day'] == "21"){ echo "selected"; } ?>>21</option>
              <option value="22" <? IF($_GET['day'] == "22"){ echo "selected"; } ?>>22</option>
              <option value="23" <? IF($_GET['day'] == "23"){ echo "selected"; } ?>>23</option>
              <option value="24" <? IF($_GET['day'] == "24"){ echo "selected"; } ?>>24</option>
              <option value="25" <? IF($_GET['day'] == "25"){ echo "selected"; } ?>>25</option>
             </select>
             <select name="year" id="year">
              <option value="2011" <? IF($_GET['year'] == "2011"){ echo "selected"; } ?>>2011</option>
            </select>
        </div>
        <div class="dataEntryControl"> 
          <div class="tCtrl"><div class="addevent">Event Title:</div><input name="title" type="text" id="title" size="60"></div>
          <div class="dCtrl"><div class="addevent">Event Description:</div><textarea name="description" cols="52" rows="18" id="description"></textarea></div>
          <div class="pCtrl"><div class="addevent">Event Photo:</div><input name="pic" type="text" id="pic" size="60"></div>
          <div class="plCtrl"><div class="addevent">Photo:</div><input name="purl" type="text" id="purl" size="60"></div>
          <div class="vlCtrl"><div class="addevent">Video:</div><input name="vurl" type="text" id="vurl" size="60"></div><br>
          <div class=""><input name="submit" type="submit" id="submit" value="Add Event"></div>
        </div>
    </form>
    </div>
    </body>
    </html>
    <? 
    } 
    ?>
    Reply With Quote Reply With Quote
  2. Oct 22, 2011 15:12 #2
    programthis
    programthis is offline
    SitePoint Enthusiast
    Join Date
    Jul 2006
    Posts
    36
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Use the MySQL UPDATE function. Your SQL statement would look something like this:

    UPDATE $db_table SET `<column_name_1>` = <new_data_1> [, `<column_name_2>` = <new_data_2>, ... `<column_name_n>` = <new_data_n>] WHERE `event_id`= xxx
    web development &
    Search Engine Optimization for small businesses
    Reply With Quote Reply With Quote
  3. Oct 24, 2011 10:37 #3
    begeiste
    begeiste is offline
    SitePoint Addict
    Join Date
    Jun 2004
    Location
    U.S.
    Posts
    257
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for this simple concept. Would you please give me a specific sample like: should I get the $id=$_GET['id'] first? or where should I put the $id=$_GET['id']? and What should I deal with `<column_name_1>` = <new_data_1>...?

    Much appreciated!!!!
    Reply With Quote Reply With Quote
  4. Oct 24, 2011 11:52 #4
    Cups
    Cups is offline
    SitePoint Wizard silver trophybronze trophy Cups's Avatar
    Join Date
    Oct 2006
    Location
    France, deep rural.
    Posts
    6,849
    Mentioned
    16 Post(s)
    Tagged
    1 Thread(s)
    If the form that allows the user to UPDATE records uses the POST method, you access $_POST variables, if it uses GET its $_GET variables.

    essentially:
    PHP Code:
    $event_year = mysql_real_escape_string($_POST['event_year']);
    // and so on

    $sql = "UPDATE yourtable set 
    event_year = '    $event_year'
    // and so on
    WHERE event_id = "     . (int) $_POST['event_id']; 
    You should be able to work it out from that.

    First though, create a concrete working UPDATE example that puts test data to make sure you understand what is going on and the kind of error messages you can expect ... paste it directly into PhpMyAdmin or whatever you use to manage your database.

    eg

    UPDATE yourtable set event_year = 1900 where event_id = 1;

    mysql_real_escape_string
    Reply With Quote Reply With Quote
  5. Oct 24, 2011 13:42 #5
    begeiste
    begeiste is offline
    SitePoint Addict
    Join Date
    Jun 2004
    Location
    U.S.
    Posts
    257
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi Cups,

    I must thank you for your suggestion. I am a newbie here, I changed the update sql statement ..., it is still not working.I appreciated your time and your effort.

    <?
    require_once("includes/config.php");

    session_start();

    $db_connection = mysql_connect ($DBHost, $DBUser, $DBPass) OR die (mysql_error());
    $db_select = mysql_select_db ($DBName) or die (mysql_error());

    if($use_auth)
    {
    if(!isset($_SESSION['admin_id']))
    {
    if ((!isset($_POST['USER'])) AND (!isset($_POST['PASS']))) {
    ?>
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html>
    <head>
    <title><?php include("titles.php"); ?> - Add Event</title>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <link href="images/cal.css" rel="stylesheet" type="text/css">
    </head>

    <body>
    <br><br>
    <form name="form1" method="post" action="event_add.php">

    <div class=""><span class="">Username/span><input name="USER" type="text" id="USER"></div>
    <div class=""><span class="">Password/span><input name="PASS" type="password" id="PASS"></div>
    <div class=""><span class=""></span><input type="submit" name="Submit" value=" login"></div>

    <input type="hidden" name="day" id="day" value="<? echo $_GET['day']; ?>">
    <input type="hidden" name="month" id="month" value="<? echo $_GET['month']; ?>">
    <input type="hidden" name="year" id="year" value="<? echo $_GET['year']; ?>">
    <input type="hidden" name="id" id="id" value="<? echo $_GET['id']; ?>">
    </form>
    </body>
    </html>
    <?
    exit;
    }
    ELSE
    {
    $query = "SELECT admin_id FROM ".$TBL_PR."admins WHERE admin_username='".addslashes($_POST['USER'])."' AND admin_password='".addslashes(md5($_POST['PASS']))."' LIMIT 1";
    $query_result = mysql_query ($query);
    while ($info = mysql_fetch_array($query_result))
    {
    $admin_id = $info['admin_id'];
    }

    IF(isset($admin_id))
    {
    $_SESSION['admin_id'] = $admin_id;
    }
    ELSE
    {
    header("Location: event_update.php?day=".$_POST['day']."&month=".$_POST['month']."&year=".$_POST['year']."&id=" . $_POST['id']);
    exit;
    }
    }
    }
    }

    IF(isset($_POST['submit']))
    {
    $db_table = $TBL_PR . "events";
    $event_id = $_GET['event_id'];
    $_POST['description'] = substr($_POST['description'],0,1500);
    $_POST['title'] = substr($_POST['title'],0,100);
    $_POST['pic'] = substr($_POST['pic'],0,255);
    $_POST['purl'] = substr($_POST['purl'],0,255);
    $_POST['vurl'] = substr($_POST['vurl'],0,255);

    mysql_query("UPDATE $db_table SET `event_id`,`event_day` = '".addslashes($_POST['day'])."',`event_month` = '".addslashes($_POST['month'])."',`event_year` = '".addslashes($_POST['year'])."',`event_time` = '".addslashes($_POST['hour'].":".$_POST['minute'])."',`event_title` ='".addslashes($_POST['title'])."',`event_desc` = '".addslashes($_POST['description'])."', `event_pic` = '".addslashes($_POST['pic'])."', `event_purl` = '".addslashes($_POST['purl'])."', `event_vurl` = '".addslashes($_POST['vurl'])."' WHERE `event_id` = '".addslashes($_POST['event_id'])."'");

    $_POST['month'] = $_POST['month'] + 1;
    ?>
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html>
    <head>
    <title><?php include("titles.php");?></title>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <script language='javascript' type="text/javascript">
    <!--
    function redirect_to(where, closewin)
    {
    opener.location= 'index.php?' + where;

    if (closewin == 1)
    {
    self.close();
    }
    }
    //-->
    </script>
    </head>
    <body onLoad="javascript:redirect_to('month=<? echo $_POST['month'].'&year='.$_POST['year']; ?>',1);">
    </body>
    </html>
    <?
    }
    ELSE
    {
    ?>
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html>
    <head>
    <title><?php include("titles.php");?></title>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <link href="images/cal.css" rel="stylesheet" type="text/css">
    </head>
    <body>
    <div class="eventFormControl">
    <form name="form1" method="post" action="">
    <div class="eventDateControl"><span class="addevent">Event Date</span><br>
    <span class="addeventextrainfo">(MM/DD/YY)</span></div>
    <div class="formMenuControl">
    <select name="month" id="month">
    <option value="12" <? IF($_GET['month'] == "12"){ echo "selected"; } ?>>12</option>
    </select> <select name="day" id="day">
    <option value="1" <? IF($_GET['day'] == "1"){ echo "selected"; } ?>>01</option>
    <option value="2" <? IF($_GET['day'] == "2"){ echo "selected"; } ?>>02</option>
    <option value="3" <? IF($_GET['day'] == "3"){ echo "selected"; } ?>>03</option>
    <option value="4" <? IF($_GET['day'] == "4"){ echo "selected"; } ?>>04</option>
    <option value="5" <? IF($_GET['day'] == "5"){ echo "selected"; } ?>>05</option>
    <option value="6" <? IF($_GET['day'] == "6"){ echo "selected"; } ?>>06</option>
    <option value="7" <? IF($_GET['day'] == "7"){ echo "selected"; } ?>>07</option>
    <option value="8" <? IF($_GET['day'] == "8"){ echo "selected"; } ?>>08</option>
    <option value="9" <? IF($_GET['day'] == "9"){ echo "selected"; } ?>>09</option>
    <option value="10" <? IF($_GET['day'] == "10"){ echo "selected"; } ?>>10</option>
    <option value="11" <? IF($_GET['day'] == "11"){ echo "selected"; } ?>>11</option>
    <option value="12" <? IF($_GET['day'] == "12"){ echo "selected"; } ?>>12</option>
    <option value="13" <? IF($_GET['day'] == "13"){ echo "selected"; } ?>>13</option>
    <option value="14" <? IF($_GET['day'] == "14"){ echo "selected"; } ?>>14</option>
    <option value="15" <? IF($_GET['day'] == "15"){ echo "selected"; } ?>>15</option>
    <option value="16" <? IF($_GET['day'] == "16"){ echo "selected"; } ?>>16</option>
    <option value="17" <? IF($_GET['day'] == "17"){ echo "selected"; } ?>>17</option>
    <option value="18" <? IF($_GET['day'] == "18"){ echo "selected"; } ?>>18</option>
    <option value="19" <? IF($_GET['day'] == "19"){ echo "selected"; } ?>>19</option>
    <option value="20" <? IF($_GET['day'] == "20"){ echo "selected"; } ?>>20</option>
    <option value="21" <? IF($_GET['day'] == "21"){ echo "selected"; } ?>>21</option>
    <option value="22" <? IF($_GET['day'] == "22"){ echo "selected"; } ?>>22</option>
    <option value="23" <? IF($_GET['day'] == "23"){ echo "selected"; } ?>>23</option>
    <option value="24" <? IF($_GET['day'] == "24"){ echo "selected"; } ?>>24</option>
    <option value="25" <? IF($_GET['day'] == "25"){ echo "selected"; } ?>>25</option>
    </select>
    <select name="year" id="year">
    <option value="2011" <? IF($_GET['year'] == "2011"){ echo "selected"; } ?>>2011</option>
    </select>
    </div>
    <div class="dataEntryControl">
    <div class="tCtrl"><div class="addevent">Event Title/div><input name="title" type="text" id="title" size="60"></div>
    <div class="dCtrl"><div class="addevent">Event Description/div><textarea name="description" cols="52" rows="18" id="description"></textarea></div>
    <div class="pCtrl"><div class="addevent">Event Photo/div><input name="pic" type="text" id="pic" size="60"></div>
    <div class="plCtrl"><div class="addevent">Photo/div><input name="purl" type="text" id="purl" size="60"></div>
    <div class="vlCtrl"><div class="addevent">Video/div><input name="vurl" type="text" id="vurl" size="60"></div><br>
    <div class=""><input name="submit" type="submit" id="submit" value="Add Event"></div>
    </div>
    </form>
    </div>
    </body>
    </html>
    <?
    }
    ?>
    Reply With Quote Reply With Quote
  6. Oct 24, 2011 14:07 #6
    Cups
    Cups is offline
    SitePoint Wizard silver trophybronze trophy Cups's Avatar
    Join Date
    Oct 2006
    Location
    France, deep rural.
    Posts
    6,849
    Mentioned
    16 Post(s)
    Tagged
    1 Thread(s)
    Forget that lot, have a go at making a simple php script which just runs a mysql UPDATE statement.

    Post your attempt here.
    Reply With Quote Reply With Quote
  7. Oct 24, 2011 17:24 #7
    begeiste
    begeiste is offline
    SitePoint Addict
    Join Date
    Jun 2004
    Location
    U.S.
    Posts
    257
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks a lot.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules