[SOLVED] Structure Help

darkfreaks · February 4, 2008

could someone straighten it out abit? it is all jumbled up and it isnt working right.

<?php
$strTitle = "Bulletin Board";
define('QUADODO_IN_SYSTEM', true);
require_once('includes/header2.php');
$logname = stripslashes($qls->user_info['username']);

$catid = $qls->Security->make_safe($_GET['catid']);
$covid = $qls->Security->make_safe($_GET['covid']);

if (empty($logname)) {
echo "You MUST be logged in to view this page";
}else{


include ('config.php');
$query1=trim(mysql_real_escape_string($query1));
$query1 = "SELECT * FROM vc_coven WHERE id='$covid'";
$result1 = mysql_query($query1);

$num=mysql_num_rows($result1);

mysql_close();

$i=0;
while ($i < $num) {

$id = mysql_result($result1,$i,"id");
$header = mysql_result($result1,$i,"header");
$name = mysql_result($result1,$i,"name");

include ('config.php');
$query6=trim(mysql_real_escape_string($query6));
$query6 = "SELECT * FROM vc_covenmembers WHERE covenname='$name' AND username='$logname'";
$result6 = mysql_query($query6);

$num=mysql_num_rows($result6);

mysql_close();

$i=0;
for ($i = 0; $i < $num; $i++) {

$status = mysql_result($result6,$i,"status");

echo "<form method='post' action='delete.php'>
<input type='hidden' name='catid' value='$covid'>
$header
<a href='../covens/$name'><h2>$name</h2></a>";

include ('config.php');
$query=trim(mysql_real_escape_string($query));
$query = "SELECT * FROM vc_coventopics WHERE catid='$catid'";
$result = mysql_query($query);
$link = mysql_connect("localhost", "chrxtr2_dbase", "l0v3sux
");
mysql_select_db("chrxtr2_dbase", $link);

$numrows=mysql_num_rows($result);




mysql_close();

$i=0;
while ($i < $num) {

$catid = mysql_result($result,$i,"catid");
$username = mysql_result($result,$i,"username");
$date = mysql_result($result,$i,"date");
$message = mysql_result($result,$i,"message");
$title = mysql_result($result,$i,"title");

echo "<table width=\"60%\" cellpadding=\"0\" cellspacing=\"0\">
<tr valign='top'>
<td width=\"10%\" align=\"center\">
<a href=\"../profile/$username\"><br>$username</a><br>
</td>
<td width=\"50%\">
<table border=\"0\" width=\"100%\" class=\"titlebar\">
<tr><td align=\"left\"><B>$title</B></td><td align=\"right\">
$date
</td></tr>
</table>
$message
</td></tr>
</table>
";

$i++;
};

echo "<p>";

include ('config.php');
$limit=25;
if(empty($_GET['page'])){ 
        $page = 1; 
        $s_limit = 0; 
    } else{ 
        $page = $_GET['page']; 
        $s_limit = ($page - 1) * $limit; 
    } 
    

$query2 = "SELECT * FROM vc_covenmessages WHERE catid='$catid' ORDER BY `id` DESC LIMIT  $s_limit,$limit";
$result2 = mysql_query($query2);

$num=mysql_num_rows($result2);
$blow = $num / $limit; 
    $blown = explode('.', $blow); 
    if(empty($blown[1])){ 
        $top = $blown[0]; 
    } else{ 
        $top = $blown[0] + 1; 
    } 
    // That tells us how many total pages we are going to have 
     
    // Variables for Previous and Next Links 
    $prev = $page - 1; 
    $next = $page + 1; 
     
    /* 
    Now we are going to put in the links, 
    <<PREV 1 2 3 (etc.) NEXT>> 
    */ 
    if($page == 1){ 
        echo '«PREV '; 
    } else{ 
        echo '<a href="data.php?page='. $prev .'">«PREV</a> '; 
    } 
    for($x = 1; $x < $page; $x += 1){ 
        echo '<a href="data.php?page='. $x .'">'. $x .'</a> '; 
    } 
    echo $page . ' '; 
    for($y = $page + 1; $y <= $top; $y += 1){ 
        echo '<a href="data.php?page='. $y .'">'. $y .'</a> '; 
    } 
    if($page == $top){ 
        echo 'NEXT»'; 
    } else{ 
        echo '<a href="data.php?page='. $next .'">NEXT»</a>'; 
    } 
     
    // Create Some Seperation from our results and the data 
    echo "\n<br>\n<br>\n"; 


mysql_close();

$i=0;
while ($i < $num) {

$catid = mysql_result($result2,$i,"catid");
$id = mysql_result($result2,$i,"id");
$username = mysql_result($result2,$i,"username");
$date = mysql_result($result2,$i,"date");
$message = mysql_result($result2,$i,"message");
$title = mysql_result($result2,$i,"title");

echo "<table width=\"60%\" cellpadding=\"0\" cellspacing=\"0\" class=\"cmessage\">
<tr valign='top'>
<td width=\"10%\" align=\"center\">
<a href=\"../profile/$username\"><br>$username</a><br>";
if ($status=="owner") {
echo "<input type='checkbox' name='id' value='$id'>";
};
if ($status=="admin") {
echo "<input type='checkbox' name='id' value='$id'>";
};
echo "</td>
<td width=\"50%\">
<table border=\"0\" width=\"100%\" class=\"titlebar\">
<tr><td align=\"left\"><B>$title</B></td><td align=\"right\">
$date
</td></tr>
</table>
$message
</td></tr>
</table>
";

$i++;
};

if ($status=="owner") {
echo "<input type='submit' name='deletemessage' value='Delete Message'>";
};
if ($status=="admin") {
echo "<input type='submit' name='deletemessage' value='Delete Message'>";
};
echo "</form>";
?>
<p>
<form name="sendmessage" id="sendmessage" method="post" action="messageleft.php">
<input type="hidden" name="date" id="date" value="<?php
$date_time = date('l M d, Y g:i A');
echo ($date_time); 
?>(GMT)">
<input type="hidden" name="username" value="<?php echo $logname; ?>"><br>
<input type="hidden" name="catid" value="<?php echo $catid; ?>"><br>
<input type="hidden" name="covid" value="<?php echo $covid; ?>"><br>
<br>
Title <input type="text" name="title" id="title" value="<?php echo $title; ?>"><br>
<textarea rows="10" cols="60" name="message" id="message"></textarea>
<br>
<input type="submit" id="submit" name="submit" value=" Send Message ">
</form>
<?php
$i++;
};
};
};
include ('includes/footer.php');
?>

darkfreaks · February 4, 2008

sorry this is the right code:

<?php
$strTitle = "Upload a pic";
define('QUADODO_IN_SYSTEM', true);
require_once('includes/header2.php');

$u = $qls->Security->make_safe($_GET['u']);
$pname = $qls->Security->make_safe($_GET['pname']);

$username = stripslashes($qls->user_info['username']);

include ('config.php');

$upload_dir = "gallery/";
$num_files = 5;
$size_bytes =512000; //512000 bytes = 500KB.
$limitedext = array(".gif",".jpg",".jpeg",".png");


   if (!is_dir("$upload_dir")) {
      die ("Error: The directory <b>($upload_dir)</b> doesn't exist");
   }
   //check if the directory is writable.
   if (!is_writeable("$upload_dir")){
      die ("Error: The directory <b>($upload_dir)</b> is NOT writable, Please CHMOD (777)");
   }


//if the form has been submitted, then do the upload process
//infact, if you clicked on (Upload Now!) button.
if (isset($_POST['upload_form'])){

       echo "<h3>Upload results:</h3>";

       //do a loop for uploading files based on ($num_files) number of files.
       for ($i = 1; $i <= $num_files; $i++) {

           //define variables to hold the values.
           $new_file = $_FILES['file'.$i];
           $file_name = $new_file['name'];
           //to remove spaces from file name we have to replace it with "_".
           $file_name = str_replace(' ', '_', $file_name);
           $file_tmp = $new_file['tmp_name'];
           $file_size = $new_file['size'];

           #-----------------------------------------------------------#
           # this code will check if the files was selected or not.    #
           #-----------------------------------------------------------#

           if (!is_uploaded_file($file_tmp)) {
              //print error message and file number.
              echo "File $i: Not selected.<br>";
           }else{
                 #-----------------------------------------------------------#
                 # this code will check file extension                       #
                 #-----------------------------------------------------------#

                 $ext = strrchr($file_name,'.');
                 if (!in_array(strtolower($ext),$limitedext)) {
	 echo "File $i: ($file_name) Wrong file extension. <br>";}
                 }else{
                       #-----------------------------------------------------------#
                       # this code will check file size is correct                 #
                       #-----------------------------------------------------------#

                       if ($file_size > $size_bytes){
	       echo "File $i: ($file_name) Faild to upload. File must be <b>". $size_bytes / 1024 ."</b> KB. <br>";}
                       }else{
                             #-----------------------------------------------------------#
                             # this code check if file is Already EXISTS.                #
                             #-----------------------------------------------------------#

                             if(file_exists($upload_dir.$file_name)){
		     echo "File $i: ($file_name) already exists.<br>";}
	       }else{
                                   #-----------------------------------------------------------#
                                   # this function will upload the files.   cool          #
                                   #-----------------------------------------------------------#
                                   if((move_uploaded_file($file_tmp,$upload_dir.$file_name)) {
$query = "INSERT INTO `vc_pics` (`username`,`pic`,`pname`) VALUES('{$username}','{$file_name}','{$pname}')";
mysql_query($query)or die(mysql_error());
			   echo "File $i: ($file_name) Uploaded.<br>";
                                   }else{
			   echo "File $i: Faild to upload.<br>";}
	 }#end of (move_uploaded_file).

                             }#end of (file_exists).

                       }#end of (file_size).
	       

               

           

   
       # print back button.
       echo "»<a href=\"$_SERVER[php_SELF]\">back</a>";
////////////////////////////////////////////////////////////////////////////////
//else if the form didn't submitted then show it.
}else{
    echo " <h3>Select files to upload!.</h3>
           Max file size = ". $size_bytes / 1024 ." KB";
    echo " <form method=\"post\" action=\"$_SERVER[php_SELF]\" enctype=\"multipart/form-data\">";
           // show the file input field based on($num_files).
           for ($i = 1; $i <= $num_files; $i++) {
               echo "Pic $i: <input type=\"file\" name=\"file". $i ."\"><br>
<input type=\"hidden\" name=\"username\" id=\"username\" value=\"$username\"><br>";
           }
    echo " <input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"$size_bytes\">
           <input type=\"submit\" name=\"upload_form\" value=\"Upload Now!\">
           </form>";
}


include ('includes/footer.php');
?>

revraz · February 4, 2008

Thats a lot of code and not much of a idea what's wrong or where to even look.

darkfreaks · February 4, 2008

UNexpected T_else on line 60

Line:

 }else{
                       #-----------------------------------------------------------#
                       # this code will check file size is correct                 #
                       #-----------------------------------------------------------#

                       if ($file_size > $size_bytes){
	       echo "File $i: ($file_name) Faild to upload. File must be <b>". $size_bytes / 1024 ."</b> KB. <br>";}
                       else{
                             #-----------------------------------------------------------#
                             # this code check if file is Already EXISTS.                #
                             #-----------------------------------------------------------#

                             if(file_exists($upload_dir.$file_name)){
		     echo "File $i: ($file_name) already exists.<br>";}
	       }else{
                                   #-----------------------------------------------------------#
                                   # this function will upload the files.   cool          #
                                   #-----------------------------------------------------------#
                                   move_uploaded_file($file_tmp,$upload_dir.$file_name);
$query = "INSERT INTO `vc_pics` (`username`,`pic`,`pname`) VALUES('{$username}','{$file_name}','{$pname}')";
mysql_query($query)or die(mysql_error());
			   echo "File $i: ($file_name) Uploaded.<br>";
                                   }else{
			   echo "File $i: Faild to upload.<br>";}
	 }#end of (move_uploaded_file).

                             }#end of (file_exists).

		     }

Stooney · February 4, 2008

Which line is 60? And I would recommend organizing your code for everyone's sake.

revraz · February 4, 2008

The first else needs to be elseif since you have another else after it.

darkfreaks · February 4, 2008

fixed i do have a minor error unknown colmn pname?

Stooney · February 4, 2008

That means the table doesn't have a column named 'pname'

Barand · February 4, 2008

Exactly as it says on the tin - Check your table definition

Sign In

[SOLVED] Structure Help

Recommended Posts

darkfreaks

Link to comment

Share on other sites

darkfreaks

Link to comment

Share on other sites

revraz

Link to comment

Share on other sites

darkfreaks

Link to comment

Share on other sites

Stooney

Link to comment

Share on other sites

revraz

Link to comment

Share on other sites

darkfreaks

Link to comment

Share on other sites

Stooney

Link to comment

Share on other sites

Barand

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information