Participant

Question

erorr in the result

Forum|Forum|15 years ago
April 4, 2010
1 reply
573 views

i was created one sql database and made control panel for it

the ( update ) button is worked good but the ( delete ) isn't work

the message appeared is ( Incorrect table name '' )

what is the problem , please help me

Thank you

Server side applications

This topic has been closed for replies.

B

bregent

Participating Frequently

What is the code? What scripting language are you using? DBMS?

http://forums.adobe.com/thread/470404

L

liondeveloperAuthor

Participant

the script language is php & mysql database

i created 2 files :

the first : i made in it the following steps :

1- created recordset

2- dragged and dropped one field which i need to delete

3- put ( delete ) word and linked it with the second page by parameter id

and the second page : i made a blank page with one recordset and made it filter by ( id )

next, from insert menu clicked on data objects , insert record and delete record

after that when i preview the the first page in the browser and click in ( delete ) link

the massege appeared is :

Incorrect table name ''

the first page php code :

<?php require_once('../Connections/dwcon.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
}
return $theValue;
}
}

$maxRows_rscomment = 10;
$pageNum_rscomment = 0;
if (isset($_GET['pageNum_rscomment'])) {
$pageNum_rscomment = $_GET['pageNum_rscomment'];
}
$startRow_rscomment = $pageNum_rscomment * $maxRows_rscomment;

mysql_select_db($database_dwcon, $dwcon);
$query_rscomment = "SELECT * FROM `comment`";
$query_limit_rscomment = sprintf("%s LIMIT %d, %d", $query_rscomment, $startRow_rscomment, $maxRows_rscomment);
$rscomment = mysql_query($query_limit_rscomment, $dwcon) or die(mysql_error());
$row_rscomment = mysql_fetch_assoc($rscomment);

if (isset($_GET['totalRows_rscomment'])) {
$totalRows_rscomment = $_GET['totalRows_rscomment'];
} else {
$all_rscomment = mysql_query($query_rscomment);
$totalRows_rscomment = mysql_num_rows($all_rscomment);
}
$totalPages_rscomment = ceil($totalRows_rscomment/$maxRows_rscomment)-1;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>التحكم في التعليقات</title>
<meta name="keywords" content="" />
<meta name="description" content="" />
<link href="../styles.css" rel="stylesheet" type="text/css" />
<style type="text/css">

</style>
</head>
<body>

<div id="contmain">
<div id="menu">
        <ul>
            <li><a href="#"></a></li>
            <li><a href="#"></a></li>
            <li><a href="#"></a></li>
            <li><a href="#"></a></li>
            <li><a href="../index.php"></a></li>
        </ul>
    </div>
<div id="main">
<div id="header">
<div id="logo">
    <h1><a href="../index.php"></a><a href="http://www.metamorphozis.com/" id="metamorph"></a></h1>
    </div>

</div>

<div id="page">
<div align="center">
    
</div>
<div id="sidebar2" class="sidebar">
      <ul>
          <li>
                <h2> </h2>
                <div class="title_back">
                <ul>
                  <table width="130" height="136" border="0">
                    <tr>
                      <td height="47" bgcolor="#99CC66"><h1><a href="cp.php">اللوحة الرئيسية</a></h1></td>
                      <td bgcolor="#99CC66"><img src="../images/icons/Dreamweaver.png" width="36" height="35" alt="" /></td>
                    </tr>
                    <tr>
                      <td height="40" bgcolor="#99CC33"><h1><strong>المقالات</strong></h1></td>
                      <td bgcolor="#99CC33"><img src="../images/icons/Dreamweaver.png" width="36" height="35" alt="" /></td>
                    </tr>
                    <tr>
                      <td height="41" bgcolor="#99CC66"><h1><strong><a href="logout.php">تسجيل الخروج</a></strong></h1></td>
                      <td bgcolor="#99CC66"><img src="../images/icons/Dreamweaver.png" width="36" height="35" alt="" /></td>
                    </tr>
                  </table>
                  <li></li>
                </ul>
            </div>
          </li>
          <li>
                <h2> </h2>
                <div class="title_back">
                  <ul>
                  <li>
    
</li>
                </ul>
                </div>
          </li>
      </ul>
</div>
<div id="content">
            <div class="box">
             <div class="box2">
            <h4 align="right"><a href="#"></a></h4>
            <p> </p>
            <p> </p>
             </div>
            </div>
            <?php do { ?>
              <table width="299" border="0" align="center" cellpadding="5" cellspacing="5">
                <tr>
                  <td colspan="2" bgcolor="#006666"><div align="center"><strong>العمليات</strong></div></td>
                  <td width="154" bgcolor="#006666"><div align="center"><strong>العنوان</strong></div></td>
                </tr>
                <tr>
                  <td width="42" bgcolor="#99CC66"><p><img src="../images/icons/Multiply, delete.png" width="43" height="40" alt="hh" /></p>
                    <p><a href="deletecomment.php?comm_id=<?php echo $row_rscomment['comm_id']; ?>">حذف</a></p></td>
                  <td width="53" bgcolor="#99CC66"><p><img src="../images/icons/Configuration Files or Utilities.png" width="44" height="39" alt="yy" /></p>
                    <p><a href="updatecomment.php?comm_id=<?php echo $row_rscomment['comm_id']; ?>">تعديل</a></p></td>
                  <td bgcolor="#99CC66"><?php echo $row_rscomment['comment']; ?></td>
                </tr>
              </table>
<p> </p>
              <div class="box">
            <div class="box2"> </div></div>
              <?php } while ($row_rscomment = mysql_fetch_assoc($rscomment)); ?>
</div>
    

    <div id="bottom" style="clear: both;"></div>
</div>

<div id="footer">
    <h1>©</h1>
    <h1><a href="http://www.metamorphozis.com/" title="Flash Website Templates"></a>
        </h1>
</div>
</div>
</div>

<div style="text-align: center; font-size: 0.75em;"></div></body>
</html>
<?php
mysql_free_result($rscomment);
?>
------------------------------------------------------

the second page php code is :

<?php require_once('../Connections/dwcon.php'); ?>

<?php

if (!function_exists("GetSQLValueString")) {

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")

{

if (PHP_VERSION < 6) {

$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

}

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {

case "text":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "long":

case "int":

$theValue = ($theValue != "") ? intval($theValue) : "NULL";

break;

case "double":

$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";

break;

case "date":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "defined":

$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

break;

}

return $theValue;

}

if ((isset($_GET['comm_id'])) && ($_GET['comm_id'] != "")) {

$deleteSQL = sprintf("DELETE FROM ``comment`` WHERE comm_id=%s",

GetSQLValueString($_GET['comm_id'], "text"));

mysql_select_db($database_dwcon, $dwcon);

$Result1 = mysql_query($deleteSQL, $dwcon) or die(mysql_error());

$deleteGoTo = "commentcontrol.php";

if (isset($_SERVER['QUERY_STRING'])) {

$deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";

$deleteGoTo .= $_SERVER['QUERY_STRING'];

}

header(sprintf("Location: %s", $deleteGoTo));

}

$colname_Recordset1 = "-1";

if (isset($_GET['comm_id'])) {

$colname_Recordset1 = $_GET['comm_id'];

}

mysql_select_db($database_dwcon, $dwcon);

$query_Recordset1 = sprintf("SELECT * FROM `comment` WHERE comm_id = %s", GetSQLValueString($colname_Recordset1, "int"));

$Recordset1 = mysql_query($query_Recordset1, $dwcon) or die(mysql_error());

$row_Recordset1 = mysql_fetch_assoc($Recordset1);

$totalRows_Recordset1 = mysql_num_rows($Recordset1);

$colname_rscomment = "-1";

if (isset($_GET['comm_id'])) {

$colname_rscomment = $_GET['comm_id'];

}

mysql_select_db($database_dwcon, $dwcon);

$query_rscomment = sprintf("SELECT * FROM `comment` WHERE comm_id = %s", GetSQLValueString($colname_rscomment, "int"));

$rscomment = mysql_query($query_rscomment, $dwcon) or die(mysql_error());

$row_rscomment = mysql_fetch_assoc($rscomment);

$colname_rsdeletecomment = "-1";

if (isset($_GET['comm_id'])) {
$colname_rsdeletecomment = $_GET['comm_id'];
}
mysql_select_db($database_dwcon, $dwcon);
$query_rsdeletecomment = sprintf("SELECT * FROM `comment` WHERE comm_id = %s", GetSQLValueString($colname_rsdeletecomment, "int"));
$rsdeletecomment = mysql_query($query_rsdeletecomment, $dwcon) or die(mysql_error());
$row_rsdeletecomment = mysql_fetch_assoc($rsdeletecomment);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>حذف التعليق</title>
<meta name="keywords" content="" />
<meta name="description" content="" />
<link href="../styles.css" rel="stylesheet" type="text/css" />
</head>
<body>

<div id="contmain">
<div id="menu">
        <ul>
            <li><a href="#"></a></li>
            <li><a href="#"></a></li>
            <li><a href="#"></a></li>
            <li><a href="#"></a></li>
            <li><a href="../index.php"></a></li>
        </ul>
    </div>
<div id="main">
<div id="header">
<div id="logo">
    <h1><a href="../index.php"></a><a href="http://www.metamorphozis.com/" id="metamorph"></a></h1>
    </div>

</div>

<div id="page">
<div align="center">
    
</div>
<div id="sidebar2" class="sidebar">
      <ul>
          <li>
                <h2> </h2>
                <div class="title_back">
                <ul><li></li>
                </ul>
                </div>
          </li>
          <li></li>
          <li>
            <div class="title_back"> </div>
            </li>
        </ul>
    </div>
    
<div id="content">
            <div class="box">
             <div class="box2">
            <h4 align="right"> </h4>
<p> </p>
             </div>
            </div>
<p> </p>
            <div class="box">
        <div class="box2"> </div></div>
    </div>
    

    <div id="bottom" style="clear: both;"></div>
</div>

<div id="footer">
    <p>© </p>
    <p><a href="http://www.metamorphozis.com/" title="Flash Website Templates"></a>
        </p>
</div>
</div>
</div>

<div style="text-align: center; font-size: 0.75em;"></div></body>
</html>
<?php
mysql_free_result($Recordset1);
?>

--------------------------------------------------------------------

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded