0

hi i am new to php and mysql, i am experimenting with a script for saving data to mysql database. and fetch the data on other page, i managed to get both of them without any trouble.
But Here is the one problem. I added a additional input function to save the input data, but other input functions are working except the one i modified.!!
i added the value through phpmyadmin and it works for fetching that data, but can not added value through this script.(see below, i have put down the code)

i am using the latest wampserver.and the modified input is "$compny_name". i wanted to add a field to add company names, but it just dont save the value.
This script is a little big, maybe too big but any help would be appreciate. :(

<?php
   session_start();
   error_reporting(0);
   define('ADMIN_PASS', 'password');
   define('MAIN_SCRIPT', basename(__FILE__));
   $session_timeout = 3600*24*30;
   $mysql_server = 'localhost';
   $mysql_username = 'test@localhost';
   $mysql_password = '';
   $mysql_database = 'test';
   $username = 'admin';

   $labelHome = 'Home';
   $labelName = 'Product Name';
   $labelCompanyName = 'Company Name';
   $labelCreatedBy = 'Created by';
   $labelLastUpdate = 'Last update';
   $labelVisible = 'Visible';
   $labelHomePage = 'Home page';
   $labelViews = 'Views';
   $labelOrder = 'Order';
   $labelContent = 'Product Description';
   $labelURL = 'External URL';
   $labelExtraData = 'Supported OS';
   $labelTitle = 'Title';
   $labelDescription = 'Description';
   $labelKeywords = 'Keywords';
   $labelAction = 'Action';
   $labelNewPage = 'Add a Download';
   $labelCaption = 'Content Management System';
   $labelLogin = 'Login';
   $labelLogout = 'Logout';
   $labelEdit = 'Edit';
   $labelCopy = 'Copy';
   $labelDelete = 'Delete';
   $labelYes = 'Yes';
   $labelNo = 'No';
   $labelSave = 'Save';
   $labelCancel = 'Cancel';
   $labelUp = 'Up';
   $labelDown = 'Down';
   $labelOwner = 'Owner';
   $labelPlugins = 'Plugins';
   $labelUserName = 'Username:';
   $labelPassword = 'Password:';
   $admin_password = isset($_COOKIE['cmsadmin_pwd']) ? $_COOKIE['cmsadmin_pwd'] : '';


   if (empty($admin_password))

   {

      if (isset($_POST['admin_password']))

      {

         $admin_password = md5($_POST['admin_password']);

         if ($admin_password == md5(ADMIN_PASS))

         {

            setcookie('cmsadmin_pwd', $admin_password, time() + $session_timeout);

         }

      }

   }

   else

   if ($admin_password == md5(ADMIN_PASS))

   {

      setcookie('cmsadmin_pwd', $admin_password, time() + $session_timeout);

   }

   $authorized = ($admin_password == md5(ADMIN_PASS));

   if (!$authorized)

   {

      if (isset($_SESSION['cms_user']))

      {

         $authorized = true;

         $username = $_SESSION['cms_user'];

      }

   }

   $id = isset($_REQUEST['id']) ? $_REQUEST['id'] : '';

   $action = isset($_REQUEST['action']) ? $_REQUEST['action'] : '';

   $name = isset($_POST['name']) ? $_POST['name'] : '';

   $compny_name = isset($_POST['compny_name']) ? $_POST['compny_name'] : '';

   $content = isset($_POST['content']) ? $_POST['content'] : '';

   $url = isset($_POST['url']) ? $_POST['url'] : '';

   $extra_data = isset($_POST['extra_data']) ? $_POST['extra_data'] : '';

   $title = isset($_POST['title']) ? $_POST['title'] : '';

   $description = isset($_POST['description']) ? $_POST['description'] : '';

   $keywords = isset($_POST['keywords']) ? $_POST['keywords'] : '';

   $created_by = isset($_POST['created_by']) ? $_POST['created_by'] : '';

   $visible = isset($_POST['visible']) ? $_POST['visible'] : 0;

   $timestamp = date("y-m-d H:i:s", time());



   $plugins = array();

   if (file_exists('./plugins/'))

   {

      $handle = opendir('./plugins/');

      while ($item = readdir($handle))

      {

         if ($item != "." && $item != ".." && is_dir('./plugins/'.$item) && substr($item, 0, 1) != '_')

         {

            require_once('./plugins/'.$item.'/plugin.php');

            $plugins[$item] = $plugin;

         }

      }

      closedir($handle);

   }

   $db = mysql_connect($mysql_server, $mysql_username, $mysql_password);

   if (!$db)

   {

      die('Failed to connect to database server!<br>'.mysql_error());

   }

   mysql_select_db($mysql_database, $db) or die('Failed to select database<br>'.mysql_error());

   if ($action == 'login')

   {

      if (!$authorized && function_exists('usermanager_login'))

      {

         usermanager_login();

      }

      $action = '';

   }

   if ($authorized)

   {

      if (get_magic_quotes_gpc())

      {

         $content = stripslashes($content);

         $url = stripslashes($url);

         $name = stripslashes($name);

         $cname = stripslashes($cname);

         $extra_data = stripslashes($extra_data);

         $title = stripslashes($title);

         $description = stripslashes($description);

         $keywords = stripslashes($keywords);

         $created_by = stripslashes($created_by);

      }

      $content = mysql_real_escape_string($content);

      $url = mysql_real_escape_string($url);

      $name = mysql_real_escape_string($name);

      $cname = mysql_real_escape_string($cname);

      $extra_data = mysql_real_escape_string($extra_data);

      $title = mysql_real_escape_string($title);

      $description = mysql_real_escape_string($description);

      $keywords = mysql_real_escape_string($keywords);

      $created_by = mysql_real_escape_string($created_by);

      $sql = "CREATE TABLE IF NOT EXISTS CMS_PAGES (id INT UNSIGNED NOT NULL AUTO_INCREMENT,

              category_id INT NOT NULL, 

              name VARCHAR(255) NOT NULL, 

              content TEXT NOT NULL, 

              home tinyint(1) NOT NULL, 

              visible tinyint(1) NOT NULL, 

              create_date TIMESTAMP NOT NULL, 

              created_by VARCHAR(255) NOT NULL, 

              last_update_date TIMESTAMP NOT NULL, 

              last_update_by VARCHAR(255) NOT NULL, 

              views INT NOT NULL, 

              menu_index INT NOT NULL, 

              url VARCHAR(255), 

              cname VARCHAR(255),

              extra_data VARCHAR(255), 

              title VARCHAR(100), 

              description VARCHAR(255), 

              keywords VARCHAR(255), 

              seo_friendly_url VARCHAR(100), 

              PRIMARY KEY(id));";

      $result = mysql_query($sql, $db);

      if (!$result)

      {

         die('Invalid query: ' . mysql_error());

      }

      $sql = "CREATE TABLE IF NOT EXISTS CMS_SEARCH_WORDS (id INT UNSIGNED NOT NULL AUTO_INCREMENT,

              word VARCHAR(50) NOT NULL,

              PRIMARY KEY (id));";

      $result = mysql_query($sql, $db);

      if (!$result)

      {

         die('Invalid query: ' . mysql_error());

      }

      $sql = "CREATE TABLE IF NOT EXISTS CMS_SEARCH_WORDMATCH (page_id INT UNSIGNED NOT NULL,

              word_id INT UNSIGNED NOT NULL,

              PRIMARY KEY(page_id, word_id));";

      $result = mysql_query($sql, $db);

      if (!$result)

      {

         die('Invalid query: ' . mysql_error());

      }

      $upgrade = true;

      $result = mysql_query("show columns from CMS_PAGES");

      while ($data = mysql_fetch_assoc($result))

      {

         if ($data['Field'] == 'keywords')

         {

            $upgrade = false;

            break;

         }

      }

      if ($upgrade)

      {

         $sql = "ALTER TABLE CMS_PAGES ADD (title varchar(100),

                                            description varchar(255),

                                            keywords varchar(255),

                                            seo_friendly_url varchar(100));";

         $result = mysql_query($sql, $db);

         if (!$result)

         {

            die('Invalid query: ' . mysql_error());

         }

      }

      foreach($plugins as $pluginname=>$p)

      {

         if (isset($p['admin']['init']))

         {

            $fn_init = $p['admin']['init']['function'];

            $fn_init();

         }

      }

      if (!empty($action))

      {

         if ($action == 'delete')

         {

            $menu_index = 0;

            $sql = "SELECT * FROM CMS_PAGES WHERE `id` = '$id'";

            $result = mysql_query($sql, $db);

            if ($data = mysql_fetch_array($result))

            {

               $menu_index = $data['menu_index'];

            }

            $sql = "DELETE FROM CMS_PAGES WHERE `id` = '$id'";

            mysql_query($sql, $db);

            $sql = "DELETE FROM CMS_SEARCH_WORDMATCH WHERE `page_id` = '$id'";

            mysql_query($sql, $db);

            $sql = "UPDATE CMS_PAGES SET menu_index=menu_index-1 WHERE menu_index > '$menu_index'";

            mysql_query($sql, $db);

            mysql_close($db);

            header('Location: '.basename(__FILE__));

            exit;

         }

         else

         if ($action == 'update')

         {

            $seo_friendly_url = strtolower($title);

            $seo_friendly_url = preg_replace("/[^a-z0-9_\s-]/", "", $seo_friendly_url);

            $seo_friendly_url = preg_replace("/[\s-]+/", " ", $seo_friendly_url);

            $seo_friendly_url = preg_replace("/[\s_]/", "-", $seo_friendly_url);

            $sql = "UPDATE CMS_PAGES SET `name` = '$name', `cname` = '$cname', `content` = '$content', `url` = '$url', `extra_data` = '$extra_data', `title` = '$title', `description` = '$description', `keywords` = '$keywords', `seo_friendly_url` = '$seo_friendly_url', `visible` = $visible, `last_update_date` = '$timestamp', ";

            if ($username == 'admin' && $created_by != '')

            {

               $sql .= "`created_by` = '$created_by', ";

            }

            $sql .= "`last_update_by` = '$username' WHERE `id` = '$id'";

            mysql_query($sql, $db);

            addToSearchIndex($id, $content);

            foreach($plugins as $pluginname=>$p)

            {

               if (isset($p['admin']['update']))

               {

                  $fn_update = $p['admin']['update']['function'];

                  $fn_update($id);

               }

            }

            mysql_close($db);

            header('Location: '.basename(__FILE__));

            exit;

         }

         else

         if ($action == 'create')

         {

            if ($username != 'admin' || $created_by == '')

            {

               $created_by = $username;

            }

            $sql = "SELECT * FROM CMS_PAGES";

            $result = mysql_query($sql, $db);

            $menu_index = mysql_num_rows($result);

            $menu_index = $menu_index + 1;

            $sql = "INSERT CMS_PAGES (`category_id`, `name`, `cname`, `content`, `url`, `extra_data`, `title`, `description`, `keywords`, `visible`, `create_date`, `created_by`, `last_update_date`, `last_update_by`, `menu_index`) VALUES (0, '$name', '$cname', '$content', '$url', '$extra_data', '$title', '$description', '$keywords', $visible, '$timestamp', '$created_by', '$timestamp', '$username', $menu_index)";

            mysql_query($sql, $db);

            $id = mysql_insert_id();

            addToSearchIndex($id, $content);

            foreach($plugins as $pluginname=>$p)

            {

               if (isset($p['admin']['update']))

               {

                  $fn_update = $p['admin']['update']['function'];

                  $fn_update($id);

               }

            }

            mysql_close($db);

            header('Location: '.basename(__FILE__));

            exit;

         }

         else

         if ($action == 'home')

         {

            $sql = "UPDATE CMS_PAGES SET `home` = 0";

            mysql_query($sql, $db);

            $sql = "UPDATE CMS_PAGES SET `home` = 1 WHERE `id` = '$id'";

            mysql_query($sql, $db);

            mysql_close($db);

            header('Location: '.basename(__FILE__));

            exit;

         }

         else

         if ($action == 'moveup' || $action == 'movedown')

         {

            $sql = "SELECT * FROM CMS_PAGES WHERE `id` = '$id'";

            $result = mysql_query($sql, $db);

            $menu_index = 0;

            if ($data = mysql_fetch_array($result))

            {

               $menu_index = $data['menu_index'];

            }

            if ($action == 'moveup')

               $new_index = $menu_index - 1;

            else

               $new_index = $menu_index + 1;

            $sql = "UPDATE CMS_PAGES SET menu_index = $menu_index WHERE menu_index = '$new_index'";

            mysql_query($sql, $db);

            $sql = "UPDATE CMS_PAGES SET menu_index = $new_index WHERE id = '$id'";

            mysql_query($sql, $db);

            mysql_close($db);

            header('Location: '.basename(__FILE__));

            exit;

         }

         else

         if ($action == 'logout')

         {

            session_unset();

            session_destroy();

            setcookie('cmsadmin_pwd', '', time() - 3600);

            header('Location: '.basename(__FILE__));

            exit;

         }

         else

         {

            if (isset($_REQUEST['plugin']))

            {

               require('./plugins/'.$_REQUEST['plugin'].'/'.$action.'.php');

               exit;

            }

         }

      }

   }

   function addToSearchIndex($page_id, $content)

   {

      $sql = "DELETE FROM CMS_SEARCH_WORDMATCH WHERE page_id = '$page_id'";

      mysql_query($sql);

      $content = strtolower(html_entity_decode($content));

      $content = preg_replace('/&#?\w+;/', ' ', $content);

      if (!get_magic_quotes_runtime())

         $content = addslashes($content);

      $content = preg_replace('/\s+/', ' ', $content);

      $content = strip_tags($content);

      $content = preg_replace('/\W+/', ' ', $content);

      $words = preg_split('/\s+/', trim($content));

      $id_array = array();

      $index = 0;

      foreach ($words as $word)

      {

         if (strlen($word) < 2) continue;

         if (is_numeric($word)) continue;

         $sql = "SELECT id FROM CMS_SEARCH_WORDS WHERE word = '$word';";

         $result = mysql_query($sql);

         if (!$result)

         {

            die('Invalid query: ' . mysql_error());

         }

         $record = mysql_fetch_object($result);

         if (!$record || !$word_id = $record->id)

         {

            $sql = "INSERT INTO CMS_SEARCH_WORDS (word) VALUES ('$word');";

            mysql_query($sql);

            $word_id = mysql_insert_id();

         }

         $id_array[$index] = $word_id;

         $index++;

      }

      foreach ($id_array as $word_id)

      {

         $sql = "INSERT INTO CMS_SEARCH_WORDMATCH (`word_id`, `page_id`) VALUES ('$word_id', '$page_id');";

         mysql_query($sql);

      }

   }

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">

<title>Aro Download manager</title>
<link href="../aro.ico" rel="shortcut icon">
<link rel="stylesheet" href="../cmsadmin.css" type="text/css">

<script type="text/javascript" src="../jquery-1.7.2.min.js"></script>

<script type="text/javascript" src="../ckeditor/ckeditor.js"></script>

<script type="text/javascript" src="../ckeditor/adapters/jquery.js"></script>

<script type="text/javascript">

$(document).ready(function()

{

   $('#editor').ckeditor({});

   $('ul.tabs').each(function()

   {

      var $active, $content, $links = $(this).find('a');

      $active = $($links.filter('[href="'+location.hash+'"]')[0] || $links[0]);

      $active.addClass('active');

      $content = $($active.attr('href'));

      $links.not($active).each(function ()

      {

         $($(this).attr('href')).hide();

      });

      $(this).on('click', 'a', function(e)

      {

         $active.removeClass('active');

         $content.hide();

         $active = $(this);

         $content = $($(this).attr('href'));

         $active.addClass('active');

         $content.show();

         e.preventDefault();

      });

   });

});

</script>
<style>
p

{

   font-size: 11px;

   font-family: Verdana;

   font-weight: bold;

   text-decoration: none;

   color: #666666;

}

th

{

   font-size: 11px;

   font-family: Verdana;

   font-weight: bold;

   text-decoration: none;

   background-color: #21211E;

   color: #FFFFFF;

   text-align: left;
   height:20px;
   padding-left:15px;
   padding-top:5px;
   padding-bottom:5px;
   padding-right:5px;

}
a
{

   text-decoration:none;
}
a:hover
{

   text-decoration: none;
}
body
{

   margin: 0;
   background-color: black;
   background-image: url(../images/welcome_bkgrnd.png);
   background-repeat: repeat-x;
   color: #000000;
}
</style>

</head>

<body>


<?php



   if (!$authorized)

   {



            echo "<center><div style='position:relative; top:20px; width:700px; padding:10px; height:300px; background:#333; box-shadow:1px 1px 2px #333; text-align:left;'><font color='#939393' face='calibri' size='3em'>Note: enter password and username</font>\n";

      echo "<center><div style='position:relative; width:300px; height:150px; top:50px;'><form method=\"post\" action=\"" .basename(__FILE__) . "\" >\n";

      echo "<font color='white' face='calibri'><span style='position:absolute; left:0px;'>$labelUserName&nbsp;&nbsp;</span><input type=\"text\" class='signupform_text' style='position:absolute; right:0px;' name=\"admin_username\" size=\"20\"><br><br>\n";

      echo "<span style='position:absolute; left:0px;'>$labelPassword&nbsp;&nbsp;</span><input type=\"password\" class='signupform_text' name=\"admin_password\" style='position:absolute; right:0px;' size=\"20\"></font><br><br>\n";

      echo "<input type=\"submit\" class='g-button g-button-submit' value=\"$labelLogin\" style='width:100px;position:absolute; right:0px;' name=\"submit\">\n";

      echo "<input type=\"hidden\" name=\"action\" value=\"login\" >\n";

      echo "</form>\n";

      echo "</div></center></div></center>\n";

   }

   else

   {

      echo "<div id=\"nav\" style='position:relative; top:0px; left:0px; height:30px;margin:0px; background:#333;'>\n";
      echo "<div style='position:relative; left:0px top:0px; padding10px; margin:0px;'>\n";

      echo "   <li><a href=\"" . basename(__FILE__) . "\">$labelHome</a></li>\n";

      echo "   <li><a href=\"" . basename(__FILE__) . "?action=new\">$labelNewPage</a></li>\n";

      if (sizeof($plugins) > 0)

      {

         echo "   <li><a>$labelPlugins</a>\n";

         echo "   <ul>\n";

         foreach($plugins as $pluginname=>$p)

         {

            if (isset($p['admin']['menu']))

            {

               foreach ($p['admin']['menu'] as $text=>$page)

               {

                  echo "      <li><a href=\"cmsadmin_plugin.php?_plugin=".$pluginname."&amp;_page=".$page."\">".$text."</a></li>\n";

               }

            }

         }

         echo "   </ul>\n";

         echo "   </li>\n";

      }

      echo "   <li style='position:absolute; right:0px; '><a href=\"" . basename(__FILE__) . "?action=logout\">$labelLogout from download manager</a></li>\n";

      echo "</div></div>\n";

      if (!empty($action))

      {

         if ($action == 'edit' || $action == 'new' || $action == 'copy')

         {

            $sql = "SELECT * FROM CMS_PAGES WHERE id = '".$id."'";

            $result = mysql_query($sql, $db);

            $name_value = '';

            $cname_value = '';

            $content_value = '';

            $visible_value = '';

            $url_value = '';

            $extra_data_value = '';

            $title_value = '';

            $description_value = '';

            $keywords_value = '';

            $created_by_value = '';

            if ($data = mysql_fetch_array($result))

            {

               $name_value = htmlspecialchars($data['name']);

               $cname_value = htmlspecialchars($data['cname']);

               $content_value = $data['content'];

               $visible_value = $data['visible'];

               $url_value = htmlspecialchars($data['url']);

               $extra_data_value = htmlspecialchars($data['extra_data']);

               $title_value = htmlspecialchars($data['title']);

               $description_value = htmlspecialchars($data['description']);

               $keywords_value = htmlspecialchars($data['keywords']);

               $created_by_value = htmlspecialchars($data['created_by']);

            }

            $extra_tabs = array();

            foreach($plugins as $pluginname=>$p)

            {

               if (isset($p['admin']['tab']))

               {

                  $extra_tabs[$p['admin']['tab']['name']] = $p['admin']['tab']['function'];

               }

            }



            echo "<form action=\"" . basename(__FILE__) . "\" method=\"post\">\n";

            echo "<div class=\"tab\" id=\"tab-general\">\n";

            if ($action == 'new' || $action == 'copy')

            {

               echo "<input type=\"hidden\" name=\"action\" value=\"create\">\n";

            }

            else

            {

               echo "<input type=\"hidden\" name=\"action\" value=\"update\">\n";

            }

           echo "<input type=\"hidden\" name=\"id\" value=\"". $id . "\">\n";

            echo "<table width=\"100%\" border=\"0\">\n";

            echo "<tr><td style=\"width:10%;white-space:nowrap;\">$labelName:</td>\n";

            echo "<td><input type=\"text\" style=\"width:80%;\" class='signupform_text' name=\"name\" value=\"" . $name_value . "\"></td></tr>\n";

            echo "<tr><td style=\"width:10%;white-space:nowrap;\">$labelCompanyName:</td>\n";

            echo "<td><input type=\"text\" style=\"width:80%;\" class='signupform_text' name=\"cname\" value=\"" . $cname_value . "\"></td></tr>\n";

            echo "<tr><td>$labelContent:</td>\n";

            echo "<td><textarea id=\"editor\" style=\"width:100%;height:500px\" name=\"content\">" . $content_value . "</textarea></td></tr>\n";

            echo "<tr><td>$labelURL:</td>\n";

            echo "<td><input type=\"text\" style=\"width:80%;\" class='signupform_text' name=\"url\" value=\"" . $url_value . "\"></td></tr>\n";

            echo "<tr><td>$labelExtraData:</td>\n";

            echo "<td><input type=\"text\" style=\"width:80%;\" class='signupform_text' name=\"extra_data\" value=\"" . $extra_data_value . "\"></td></tr>\n";

            echo "<tr><td>$labelTitle:</td>\n";

            echo "<td><input type=\"text\" style=\"width:80%;\" class='signupform_text' name=\"title\" value=\"" . $title_value . "\"></td></tr>\n";

            echo "<tr><td>$labelDescription:</td>\n";

            echo "<td><input type=\"text\" style=\"width:80%;\" class='signupform_text' name=\"description\" value=\"" . $description_value . "\"></td></tr>\n";

            echo "<tr><td>$labelKeywords:</td>\n";

            echo "<td><input type=\"text\" style=\"width:80%;\" class='signupform_text' name=\"keywords\" value=\"" . $keywords_value . "\"></td></tr>\n";

            echo "<tr><td>$labelVisible:</td>\n";

            echo "<td><select name=\"visible\" size=\"1\"><option " . ($visible_value == "0" ? "selected " : "") . "value=\"0\">Hidden</option><option " . ($visible_value != "0" ? "selected " : "") . "value=\"1\">Visible</option></select></td></tr>\n";

            if ($username == 'admin')

            {

               echo "<tr><td>$labelOwner:</td><td><input type=\"text\" style=\"width:80%;\" class='signupform_text' name=\"created_by\" value=\"" . $created_by_value . "\"></td></tr>\n";

            }

            echo "</table>\n";

            echo "</div>\n";

            foreach($extra_tabs as $name=>$fn)

            {

               echo "<div class=\"tab\" id=\"tab-".preg_replace('/[^a-z0-9A-Z]/', '', $name)."\">\n";

               echo $fn();

               echo "</div>\n";

            }

            echo "<br><br><input style=\"position:absolute; right:10px;margin-bottom:50px;width:100px;\" type=\"submit\" class='g-button g-button-submit' name=\"save\" value=\"$labelSave\"><br><br>\n";

            echo "</form>\n";

         }

      }

      else

      {

         echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"2\">\n";

         echo "<tr><th>$labelName</th>\n";

         echo "<th>$labelCreatedBy</th>\n";

         echo "<th>$labelLastUpdate</th>\n";

         echo "<th>$labelVisible</th>\n";

         echo "<th>$labelHomePage</th>\n";

         echo "<th>$labelViews</th>\n";

         echo "<th>$labelOrder</th>\n";

         echo "<th>$labelAction</th></tr>\n";



         $sql = "SELECT * FROM CMS_PAGES";

         if ($username != 'admin')

         {

            $sql = $sql . " WHERE created_by = '".$username."'";

         }

         $sql = $sql . " ORDER BY menu_index ASC";

         $result = mysql_query($sql, $db);

         $num_rows = mysql_num_rows($result);

         while ($data = mysql_fetch_array($result))

         {

            echo "<tr class='infoadmin'>\n";

            echo "<td><a href=\"store.php" . "?page=" . $data['seo_friendly_url'] . "\" id=\"" . $data['id'] . "\"  target='new'>" . $data['name'] . "</a></td>\n";

            echo "<td>" . $data['created_by'] . "</td>\n";

            echo "<td>" . $data['last_update_date'] . "</td>\n";

            echo "<td>" . ($data['visible'] == "0" ? $labelNo : $labelYes) . "</td>\n";

            echo "<td>";

            if ($data['home'] == "1")

               echo $labelYes;

            else

               echo "   <a href=\"" . basename(__FILE__) . "?action=home&id=" . $data['id'] . "\">$labelNo</a>";

            echo "</td>\n";

            echo "<td>" . $data['views'] . "</td>\n";

            echo "<td>";

            if ($data['menu_index'] <= 1)

            {

               echo "   <a href=\"" . basename(__FILE__) . "?action=movedown&id=" . $data['id'] . "\">$labelDown</a>";

            }

            elseif ($data['menu_index'] >= $num_rows)

            {

               echo "   <a href=\"" . basename(__FILE__) . "?action=moveup&id=" . $data['id'] . "\">$labelUp</a>";

            }

            else

            {

               echo "   <a href=\"" . basename(__FILE__) . "?action=moveup&id=" . $data['id'] . "\">$labelUp</a> &nbsp; ";

               echo "   <a href=\"" . basename(__FILE__) . "?action=movedown&id=" . $data['id'] . "\">$labelDown</a>";

            }

            echo "</td>\n";

            echo "<td>\n";

            echo "   <a href=\"" . basename(__FILE__) . "?action=edit&id=" . $data['id'] . "\">$labelEdit</a> | \n";

            echo "   <a href=\"" . basename(__FILE__) . "?action=copy&id=" . $data['id'] . "\">$labelCopy</a> | \n";

            echo "   <a href=\"" . basename(__FILE__) . "?action=delete&id=" . $data['id'] . "\">$labelDelete</a>\n";

            echo "</td>\n";

            echo "</tr>\n";

         }

         echo "</table>\n";

      }

   }



?>

</body>

</html>
2
Contributors
2
Replies
26
Views
4 Years
Discussion Span
Last Post by Eagle.Avik
0

Waw.... nice php essay...

Have you tried Web Developer Tools for inpecting networks traffic(to check wheather the data was send or not) ?
It may help you..
From my understanding, you are trying to save $compny_name into database right ?
But in SQL INSERT function, I didn't see any $compny_name variable in the VALUES.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.