Learn VBA & Macros in 1 Week!

PHP - Slight Sql Problem

Full Excel VBA Course - Beginner to Expert

Slight Sql Problem	View Content

Hi

I have been getting this error.

mysql_fetch_array() expects parameter 1 to be resource, boolean given

Its driving me mad I know its something really simple. Can anyone see what it is?

Code: [Select]
mysql_select_db("product", $con);

$sqlout = mysql_query("SELECT * FROM 'tblt' WHERE 'UID' =('$ids')");

while($sqlres = mysql_fetch_array($sqlout))

Thanks

James

Full Excel VBA Course - Beginner to Expert

Query Problem (slight Php Related)

Similar Tutorials

View Content

Hey guys for some reason my script is being strange.

<?
if(!empty($_POST['why']))
{

$why = mysql_real_escape_string($_POST['why']);

$answer = $_POST['answer'];

$id = $_POST['cid'];

if($answer == "Accept")

{

$query1 = mysql_query("UPDATE characters SET accepted = '1' WHERE id = '".$id."'");

$aquery = mysql_query("UPDATE applications SET tester = '".$_COOKIE['Username']."', accepted = '1', answered = '1' WHERE cid = '".$id."'") or die('Could not connect: ' . mysql_error());

echo"Successfully accepted";

}
}
If you notice the echo it outputs the successfully executed, tho the mysql query doesn't go through for some strange issue even through it says it does since I got the or die(mysql_error) thing and it still doesn't output a error. So I got a hard time finding the problem.

Slight Hand

Similar Tutorials

View Content

Probably real basic but im nto great with the maths aspect of php, how would i get the $level + noto to show from the php below as currently i get,
From: System

4 minutes ago You have reached level 1 + 1 in Notoriety, Please check the Skill Points section to see if you now qualify for any upgrades!
$sql="INSERT INTO messages (to_username,from_username,message,type, timestamp) VALUES('$playerdata[username]','System','You have reached level $level + 1 in Notoriety, Please check the Skill Points section to see if you now qualify for any upgrades!','Player', NOW())";
mysql_query($sql) or die(mysql_error());

Php Form Processor, Slight Image Attachment Issue.

Similar Tutorials

View Content

Hey guys, I am adding to my current php form processor and I need it to be able to support image uploads, that also show up as an attachment in the email with the rest of the form data. The only part I am having problems with is getting the image to work as an attachment in the email, at the moment, it is not showing up at all in the email but it is successful at showing up on the web server (which I have it doing for storage reasons). I have attached the code involved for the image processing portion, an also a snippet of code showing how the emails are sent.

This code is for the image attachment processing

<?php
//Get the uploaded file information
$name_of_uploaded_file =
basename($_FILES['uploaded_file']['name']);

//Get the file extension of the file
$type_of_uploaded_file =
    substr($name_of_uploaded_file,
    strrpos($name_of_uploaded_file, '.') + 1);
$size_of_uploaded_file =
    $_FILES["uploaded_file"]["size"]/1024;//size in KBs

//Settings
$max_allowed_file_size = 150; // size in KB
$allowed_extensions = array("jpg", "jpeg", "gif", "bmp", "png");

//Validations
if($size_of_uploaded_file > $max_allowed_file_size )
{
  $errors .= "\n File size too large! Max file size alowed is $max_allowed_file_size";
}

//------ Validate the file extension -----
$allowed_ext = false;
for($i=0; $i<sizeof($allowed_extensions); $i++)
{
  if(strcasecmp($allowed_extensions[$i],$type_of_uploaded_file) == 0)
  {
    $allowed_ext = true;
  }
}
if(!$allowed_ext)
{
  $errors .= "\n The uploaded file is not supported file type. ".
  " Only the following file types are supported: ".implode(',',$allowed_extensions);
}

//Copy the temp. uploaded file to server
$path_of_uploaded_file = $upload_folder . $name_of_uploaded_file;
$tmp_path = $_FILES["uploaded_file"]["tmp_name"];
if(is_uploaded_file($tmp_path))
{
  if(!copy($tmp_path,$path_of_uploaded_file))
  {
    $errors .= '\n Error while copying the uploaded file';
  }
}
?>

This is the header setup for sending the email, which for some reason I think i am missing something here, causing the image to not show up in the email.

Code: [Select]
$headers = "From: edited_out_for_this_post@edited_out_for_this_post.com\r\n";
$headers .= "Reply-To: no-reply@edited_out_for_this_post.com\r\n";
$headers .= "Return-Path: no-reply@edited_out_for_this_post.com\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";

Thanks for your help in advance!

Problem Fixed But Caused New Problem

Similar Tutorials

View Content

Guys thanks for helping me solve the problem i had but now i have another problem and i am lost. i have included the code below for you to have overview.

On the home page the url shows how it should be: http://localhost/board/italian.php?country=Italian
BUT
When you mouse over the NEXT link to go to next page you get this : http://localhost/board/?page=1&country=Italian and then an error 404 when you click on the link
page = 1 no matter if you are mousing over link for page 5 or 2

This is the code:

<table style="width:100%; margin-left:auto; margin-right:auto">
       <?php

           $items_per_page = 5;//how many records/rows to display per page

           $page_url = "http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];

           $cleaned_current_page_country = htmlspecialchars($_GET["country"]);

           $page_number = (isset($_GET['page']))? filter_var($_GET['page']) : 1;
           //$page_number = filter_var($_GET['page']);
           //$page_number = $_GET['page'];

           $selected_restaurant_type = $_GET['country'];

           // find number of rows in the db
               $query = "SELECT * FROM menu_update WHERE special_of_theday = 1 AND restaurant_type = '".$selected_restaurant_type."' ";
               $query_result = mysqli_query($connection, $query);
               $row_count = mysqli_fetch_array($query_result);
               $total_rows = mysqli_num_rows($query_result);

           $expected_number_of_pages = ceil($total_rows/$items_per_page); //expected number of pages

           $page_position = (($page_number - 1) * $items_per_page); //get starting position to fetch record

           //fetch a group of records using sql LIMIT clause
               $query = "SELECT * FROM menu_update WHERE special_of_theDay = 1 AND restaurant_type = '".$selected_restaurant_type."' LIMIT " .$page_position. ',' .$items_per_page;
               $query_result = mysqli_query($connection, $query);
       ?>

           <table width="100%" border=0>
               <tr bgcolor = "#cccccc">
                   <td>Meal</td>
                   <td>Meal name</td>
                   <td>Meal Price</td>
                   <td>Order Now</td>
                   <td>Full Menu</td>
                   <td>Our Gallery</td>
                   <td>Find Us</td>
                   <td>Our Chef</td>
                   <td>Our Manager</td>
               </tr>
       <?php
               while($row_count = mysqli_fetch_array($query_result)){
                   echo "<tr>";
                       echo"
                           <td style ='width:200px; text-align:center; height:120px; background:#eaedf2'><a href='meal_fullPic.php'><img src= ".$row_count['img']." /></a></td>
                           <td style ='width:119px; text-align:center; height:120px; background:#eaedf2'> ".$row_count['meal_name']."</td>
                           <td style ='width:100px; text-align:center; height:120px; background:#eaedf2'>".$row_count['price']."</td>
                           <td style ='width:100px; text-align:center; height:120px; background:#eaedf2'><a href='order_processor.php'><img src= ".$row_count['order_now']." /></a></td>
                           <td style ='width:100px; text-align:center; height:120px; background:#eaedf2'><a href='full_menu.php'><img src= ".$row_count['full_menu_img']." /></a></td>

                           <td style ='width:170px; text-align:center; height:120px; background:#eaedf2'><a href='restaurant_gallery.php'><img src= ".$row_count['restaurant_pic']." /></a></td>
                           <td style ='width:100px; text-align:center; height:120px; background:#eaedf2'><a href='restaurant_location.php'><img src= ".$row_count['location_pic']." /></a></td>
                           <td style ='width:119px; height:120px; background:#eaedf2'> ".$row_count['chef_name']."</td>
                           <td style ='width:119px; height:120px; background:#eaedf2'> ".$row_count['admin']."</td>
                       ";
                   echo "</tr>";
               }
               mysqli_close($connection);
       ?>
           </table>
       <div class="board_pagination">
       <?php
           //display the links to the pages
           for($current_page = 1; $current_page <= $expected_number_of_pages; $current_page++){
    if ($page_number != $expected_number_of_pages){
                   $data = array(
                       'page' => $page_number,
                       'country' => $cleaned_current_page_country,
                   );
                   $the_query = http_build_query($data);
                   $page_url .= '?' . $the_query;
                   echo '<li><a href=" '.$the_query.' ">'.$current_page.'</a></li> ';
               }
           }
       ?>
       </div>
   </table>

Get Problem

Similar Tutorials

View Content

Does any1 know what would cause this problem?

Here is the url
www.mysite.com/profile.php?id=1447835&state=AL&firstname=TOM&lastname=ANDERSON

When I try to echo the id, only 6 numbers appear, the 7th is stripped for some reason

<? echo ($_GET["id"]); ?>
would print 144783

if I change the $ID to 123456789 it will only echo 123456

If...else Problem

Similar Tutorials

View Content

I have a simple text file called bio.txt:
Code: [Select]
wohlersr; Richie Wohlers; Intermediate; Four Aces
meyersg; Greg Meyers; Novice; Four Aces
I wrote a little script, to return the info for Greg Meyers if the user id is correct, or say "Member not found" if incorrect. For some reason, my output is giving me both. I assume it's a context error, but can't figure it out.

Here's my script:
Code: [Select]
<?php
$file=file("bio.txt");
$count=count($file);

$i=0;
while($i<=$count)
{
$row = explode(";", $file[$i]);

$id = $row[0];
$name = $row[1];
$class = $row[2];
$club = $row[3];

if($id=="meyersg"){
echo $name."</br>";
echo $class."</br>";
echo $club."</br>";
}else{
echo "Member not found.";
}

$i++;
}

?>
And here's the output I'm getting:
Code: [Select]
Member not found. Greg Meyers
Novice
Four Aces
Member not found.

The Problem With Vps

Similar Tutorials

View Content

Hi. I am from poland. I am 17 old age and like webmastering. I write my social network. I have new server 10 GB VPS and my script no runing In my server. in my server do can not login. No runing function
Code: [Select]
mb_strtolower();as delete function mb_strtolower() ; this login runing.
In my server haven`t installing liberary GD and no runing upload avatars.

my code upload is:
elseif ($_GET['act'] == "upload") {
echo <<< KONIEC
<hr>
<center>
        <p>
                <h2>Dodaj zdjęcie</h2>
                <ul class="gallery clearfix">
                        <li class="extra">
KONIEC;

error_reporting(E_ALL);

// we first include the upload class, as we will need it here to deal with the uploaded file
include('include/class.upload.php');

// retrieve eventual CLI parameters
$cli = (isset($argc) && $argc > 1);
if ($cli) {
    if (isset($argv[1])) $_GET['file'] = $argv[1];
    if (isset($argv[2])) $_GET['dir'] = $argv[2];
    if (isset($argv[3])) $_GET['pics'] = $argv[3];
}

// set variables
$dir_dest = (isset($_GET['dir']) ? $_GET['dir'] : 'test');
$dir_pics = (isset($_GET['pics']) ? $_GET['pics'] : $dir_dest);

if (!$cli) {

}

// we have three forms on the test page, so we redirect accordingly
if ((isset($_POST['action']) ? $_POST['action'] : (isset($_GET['action']) ? $_GET['action'] : '')) == 'simple') {

    // ---------- SIMPLE UPLOAD ----------

    // we create an instance of the class, giving as argument the PHP object
    // corresponding to the file field from the form
    // All the uploads are accessible from the PHP object $_FILES
    $handle = new Upload($_FILES['my_field']);

    // then we check if the file has been uploaded properly
    // in its *temporary* location in the server (often, it is /tmp)
    if ($handle->uploaded) {

        // yes, the file is on the server
        // now, we start the upload 'process'. That is, to copy the uploaded file
        // from its temporary location to the wanted location
        // It could be something like $handle->Process('/home/www/my_uploads/');
        $handle->Process($dir_dest);


         function TestProcess(&$handle, $title = 'test', $details='') {
            global $dir_pics, $dir_dest;
                        $unlink = 'test/'. $handle->file_dst_name;
$myid = $_SESSION['id'];
$opis = htmlspecialchars(stripslashes(strip_tags(trim($_POST["opis"]))), ENT_QUOTES);
            $handle->Process($dir_dest);

            if ($handle->processed) {
                                unlink("$unlink");
                                $link = ''.$dir_pics.'/' . $handle->file_dst_name .'';
                                $addphoto = mysql_query("INSERT INTO photo VALUES('', '$myid', '$link', '$opis')");
                                echo <<< KONIEC
                                <br>
                                <center>
                                <img src="$link" >
                                <br>
                                <br />
                                </center>
KONIEC;
            } else {
                echo '<fieldset class="classuploadphp">';
                echo '  <legend>' . $title . '</legend>';
                echo '  Error: ' . $handle->error . '';
                if ($details) echo '  <pre class="code php">' . htmlentities($details) . '</pre>';
                echo '</fieldset>';
            }
        }
        if (!file_exists($dir_dest)) mkdir($dir_dest);



        // -----------
                $handle->image_convert         = 'jpg';
                $handle->image_resize          = true;
        $handle->image_ratio_y         = true;
        $handle->image_x               = 500;
        $handle->image_precrop         = 15;
        $handle->image_watermark       = "watermark_large.png";
        $handle->image_watermark_x     = 20;
        $handle->image_watermark_y     = -20;
        TestProcess($handle, '15px pre-cropping (before resizing 800 wide), large watermark automatically reduced, position 20 -20', "\$foo->image_convert         = 'jpg';\n\$foo->image_resize          = true;\n\$foo->image_ratio_y         = true;\n\$foo->image_x               = 800;\n\$foo->image_precrop         = 15;\n\$foo->image_watermark       = 'watermark_large.png';\n\$foo->image_watermark_x     = 20;\n\$foo->image_watermark_y     = -20;");

        } else {
            // one error occured
            echo '<fieldset>';
            echo '  <legend>file not uploaded to the wanted location</legend>';
            echo '  Error: ' . $handle->error . '';
            echo '</fieldset>';
        }

        // we copy the file a second time


        // we delete the temporary files
        $handle-> Clean();

    } else {
        // if we are here, the local file failed for some reasons
        echo '<fieldset>';
        echo '  <legend>local file error</legend>';
        echo '  Error: ' . $handle->error . '';
        echo '</fieldset>';
    }

echo <<< KONIEC
<li>
                </ul>

        </p>
</center>
KONIEC;

is it the only problem that isn`t installing GD as i have something off in php.ini ? Plise Help me

I Think I Have A Problem.... Can You Help Me? :)

Similar Tutorials

View Content

i'm getting this erro
"Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /***/***/*****.php on line 278
not an active session, starts new"

this is the code:
if ($phase = mysql_result(mysql_query("SELECT `phase` FROM `as_support` WHERE `mission` = '$var2'"),0,0))
{
   if ($phase=='5') {
//      mysql_query("DELETE FROM `as_support` WHERE `mission` = '$var2'");
//      header("Location: https://www.**********/*******/*******.php");
   }
   else {
      echo date('h:i:s') . ": PHASE is $phase<br />";
      echo "\$var1=$var1,\$var2=$var2<br />";
   }
}
else {
   echo "not an active session, starts new<br />";
   echo "\$var1=$var1,\$var2=$var2<br />";
   mysql_query("INSERT INTO `as_support` (`mission`, `phase`) VALUES ('$var2', '0')") OR DIE(mysql_error());

the first line is line no. 278

can someone please tell me what to do?

tnx

shirley

Php Problem

Similar Tutorials

View Content

The problem is whit the var $threadid .
It dosent work here(it dosen't display the data from database): $dbh = "SELECT *FROM comments WHERE threadid = '".$threadid."' ";
But if I assign a value before the that code the html page show correctly.

Code: [Select]
include("config.php");

$name = $_POST['name'];
$comment = $_POST['comment'];
$threadid = $_POST['threadid'];

if($name & $comment)
{
$dbh="INSERT INTO comments (name,comment,threadid) VALUES ('$name','$comment','$threadid') ";
mysql_query($dbh);

}

$dbh = "SELECT *FROM comments WHERE threadid = '".$threadid."' ";
$req = mysql_query($dbh);
while($row=mysql_fetch_array($req))
{
echo "<li>";
echo "<br>"."<b>".$row['name']."</b></br>"."<br>".$row['comment']."</br>";
echo "</li>";
}

Code: [Select]
$('.submit').click(function(){
location.reload();
var name = $("#name").val();
var comment = $("#comment").val();

var threadid = $("#v").val();

var dat = 'name='+name+'&comment='+comment+'&threadid='+threadid;

$.ajax({
type:"post",
url:"comment.php",
data:dat,
success:function(){
console.log("dat");
}
});

return false;

});

Php Sql Problem

Similar Tutorials

View Content

Hi there,

I have a map of America made in flash, where you click on a state and the page should display the SQL database information for that state in the HTML table - but instead all it shows is the first entry of the database regardless of which state you click and it doesn't display the 2 radio buttons.

My code is as follows

Flash Actionscript 3 (just showing one state)
Code: [Select]
function waClick(event:MouseEvent):void {
var waURL:URLRequest = new URLRequest("restaurants.php?state=Washington");
navigateToURL(waURL, "_self");
}
wa_btn.addEventListener(MouseEvent.CLICK, waClick);
PHP code

Code: [Select]
<?php
  include("mvfconnect.php");
  $theChoice = $_GET['state'];
  $query = "SELECT * FROM restaurants WHERE" .$theChoice;
  $result = @ mysql_query($query);
  if (!$result) {
   $message="Unfortunately we are having problems with this page, we promise to have it fixed as soon as possible";
    die($message);
  }
  $num = mysql_num_fields($result);
  $i=0;
  while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
   $show1=substr($row['state'],0,50)."...";
   $show2=substr($row['city'],0,50)."...";
   $show3=substr($row['rname'],0,50)."...";
   $show4=substr($row['address'],0,50)."...";
   $show5=substr($row['pnum'],0,50)."...";
   $show6=substr($row['web'],0,50)."...";
   $show7=substr($row['dishes'],0,50)."...";
   $show8=substr($row['dish_details'],0,50)."...";
   $show9=substr($row['challenges'],0,50)."...";
   $show10=substr($row['challenge_details'],0,50)."...";
   $show11=substr($row['youtube'],0,50)."...";
   $show12=substr($row['images'],0,50)."...";
   echo "<tr>".
          "<td>".$row['city']."</td>".
          "<td>".$row['rname']."</td>".
          "<td>".$row['address']."</td>".
          "<td>".$row['pnum']."</td>".
          "<td>".$row['web']."</td>".
          "<td>".$row['dishes']."</td>".
          "<td>".$row['challenges']."</td>".
              "<td id='state".$i."' style='display:none'>".$row['state']."</td>".
          "<td id='city".$i."' style='display:none'>".$row['city']."</td>".
          "<td id='rname".$i."' style='display:none'>".$row['rname']."</td>".
          "<td id='address".$i."' style='display:none'>".$row['address']."</td>".
          "<td id='pnum".$i."' style='display:none'>".$row['pnum']."</td>".
          "<td id='web".$i."' style='display:none'>".$row['web']."</td>".
          "<td id='dishes".$i."' style='display:none'>".$row['dishes']."</td>".
          "<td id='dish_details".$i."' style='display:none'>".$row['dish_details']."</td>".
          "<td id='challenges".$i."' style='display:none'>".$row['challenges']."</td>".
          "<td id='challenge_details".$i."' style='display:none'>".$row['challenge_details']."</td>".
          "<td id='youtube".$i."' style='display:none'>".$row['youtube']."</td>".
                  "<td id='images".$i."' style='display:none'>".$row['images']."</td>".
                  "<td><input type='radio' name='vid' id='vid".$i."' onclick='openVideo(".$i.")' /></td>".
          "<td><input type='radio' name='pic' id='pic".$i."' onclick='openImage(".$i.")' /></td>".
          "<td class='last'style='display:none'>".$show1." ".$show2." ".$show3." ".$show4." ".$show5." ".$show6."
                  ".$show7." ".$show8." ".$show9." ".$show10."</td>".
         "</tr>";
    $i++;
   }
?>

I have used this code before and it has worked fine, can someone please help me out!

If Then Problem

Similar Tutorials

View Content

Not exactly sure how to do this.

What I need is when a person clicks on the link ie: page.php?nid=1 then it loads what needs to be loaded but if a user clicks and there is no nid ie: page.php?nid= Then it loads something else.

if (nid==$nid){
echo "This is the data to show";
}else{
Show this data instead
}

Both if and else both show different mysql data.

Hopefully I explained myself well.

Php Com Problem

Similar Tutorials

View Content

Hi,

I am trying to write in an existing excel file. But for some reason, I can't open the workbook (but I know I have made similar code work before). Here I am just pasting the code upto the error line

$filename="C:\\apache\\htdocs\\GAC2\\dload\\template.xls";
$excel = new COM("excel.application") or die("Unable to instanciate excel");
$excel->Visible = 1;
$excel->DisplayAlerts = 1;
try{
$wkb = $excel->Workbooks->Open($filename);
}catch (Exception $e) {
echo 'Caught exception: ', $e->getMessage(), "\n";
}

//........ Later part of the code

This returns the following error
Code: [Select]
Caught exception:
Source: Microsoft Office Excel
Description: Unable to get the Open property of the Workbooks class

For record, the I have already validated the file location. And I have tried the following line instead without any positive result.
Code: [Select]
$filename="C:\apache\htdocs\GAC2\dload\template.xls";
Looking for any help please.

-Abd

Ipb- Problem

Similar Tutorials

View Content

Hey guys i just installed a new Theme on my IPB 3.3.4 its called Dashboard now, the start page looks fine but if i try to click on "My Profile" an error pops up. Error message: Parse error: syntax error, unexpected '' (T_ENCAPSED_AND_WHITESPACE), expecting identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING) in C:\xampp\htdocs\board\cache\skin_cache\cacheid_4\skin_profile.php on line 1035 skin_profile.php on line 1035: <span class='ipsType_smaller desc lighter blend_links'><a href='" . $this->registry->getClass('output')->formatUrl( $this->registry->getClass('output')->buildUrl( "app=members&module=profile&section=status&type=single&status_id={$status['status_id']}", "public",'' ), "array($status['member_id'], $status['members_seo_name'])", "members_status_single" ) . "'>{$this->lang->words['ps_updated']} " . $this->registry->getClass('class_localization')->getDate($status['status_date'],"manual{%d %b}", 0) . " · " . intval($status['status_replies']) . " {$this->lang->words['ps_comments']}</a></span>

Else/if Problem

Similar Tutorials

View Content

Hopefully people here know an easy solution to a problem I'm having.

First of all, I'm using a script in Wordpress to retrieve the current url. Then I use a code in a link, adding a little code after it, which would switch the theme of my Wordpress (basically, "currenturlcode&wptheme=Sidebar%20disabled").

It works great, thanks to that, people will remain on the same page they are and switch the theme. However, if that is clicked on the main page, it goes to the 404 page, cause it needs to use "?" instead of "&" in case of that.

So what I need help with here, is somehow making my link see if they are on the main page, and if so, adding "?wptheme=Sidebar%20disabled" there, on other cases"&wptheme=Sidebar%20disabled".

Help Me With This Problem

Similar Tutorials

View Content

Im trying to parse this string and put it in the array.. However i dont know how..

Code: [Select]
11111<>your mobile<>the receiver<>keyword<>2012-01-15<>12:09:08<>wow "this", is great!
I want to remove this sign <> and put the elements on the array.. Also i would not want to loose the quotes and commas

Can someone help me?

thanks

While / If Else Problem

Similar Tutorials

View Content

I am trying to use the following code snippet to return values from a database with a "," after each value apart form the last one. At the moment for testing I have 2 rows with values 1 and 3

$totalRows_Recordset3 equals 2 (I echoed this to check)

$i=1;
  while($row_Recordset3 = mysql_fetch_assoc($Recordset3))
  {
    if($i < $totalRows_Recordset3)
    {
      $str = $str.$row_Recordset3['reading'].",";
      $i=$i+1;
    }
    else
    {
      $str = $str.$row_Recordset3['reading'];
      $i=$i+1;
    }
  }

I get the number 3 which is the last value in the database, but I can't see why I don't get "1,3"

I am sure it is something simple but it just escapes me.

Thanks in advance for any help

Gordon

Problem

Similar Tutorials

View Content

Okey so i made a table that you put your name,author,and message

when you submit it , it echoes a table with the name,author and message written (and it also echoes a delete buttom,so delete this post oif necessary)

im new to php and i have been with this problem for a couple of weeks so i guess its time to ask for some help

the problem is that i dunnot know how to make my delete buttom work! i tried if statement but it dosent work i also tried ternary operation and dint work :S

i read that there is something like $post[ID](and this is supposed to get the ID of the post submmited, and delete it) im not sure, im so confused! help! XD

this is the code

<?php

$tittle=$_POST['tittle'];
$author=$_POST['author'];
$message=$_POST['message'];

if ($_POST['submitnews']){

$currentdate= date("y-m-d");
$currenttime=date("H:i:s",strtotime("-6 hours"));

$post=mysql_query("INSERT INTO news VALUES('','$tittle','$author','$message','$currentdate','$currenttime')");
echo"Posted!";

}

$select=mysql_query("SELECT * FROM news ORDER BY id DESC");

while ($row= mysql_fetch_assoc($select))

{
$id=$row['id'];
$tittle=$row['tittle'];
$author=$row['author'];
$message=$row['message'];
$date=$row['date'];
$time=$row['time'];

if ($_SESSION['admin'])

{

echo "

<table width='488px' id='news_table'>
<tr>
<td>
</td>
<td>
<center><font size='5'>$tittle</font></center><br>
</td>
</tr>
<tr>
<td>
</td>
<td>
$message
</td>
</tr>
<tr>
<td>
</td>
<td>
<font size='1'>Posted By:<font color='green'>$author</font> on <font color='gray'>$date</font> at <font color='gray'>$time</font></font>
<input name='delete' type='submit' value='delete'>
<td>
</td>
</tr><br><br>
</table>";

Problem

Similar Tutorials

View Content

A Problem With Utf-8

Similar Tutorials

View Content

hello! I have a problem with utf-8 ... In horizontalmenu.php I have:

 print '<a href="/calcioitalia/coaches/'.$name.'.html').'">'.$name.'</a>';

where

$name=José Mário

and in .htaccess I have

AddDefaultCharset UTF-8
AddCharset UTF-8 .html

and doesn't work... How could I solve this problem? Thank u!

Oop Problem!

Similar Tutorials

View Content

I am trying to understand PHP OOP and I have some code that is not working. here is the error code.
Code: [Select]
Parse error: parse error, expecting `T_FUNCTION' in C:\wamp\www\testing\armor_lib.php on line 11
And here is the armor_lib.php file:
<?php
class armor {
// Head
public $head;
public $torso;
public $pants;
public $gloves;
public $boots;

// new stuff here
class head extends armor {
function __construct($head){
$this->set_head($head);
}
}
// Torso
class torso extends armor {
function __construct($torso){
$this->set_torso($torso);
}
}
// Pants
class pants extends armor {
function __construct($pants){
$this->set_pants($pants);
}
}
// Gloves
class gloves extends armor {
function __construct($gloves){
$this->set_gloves($gloves);
}
}
// Boots
class boots extends armor {
function __construct($boots){
$this->set_boots($boots);
}
}
}
?>

And here is the php in the armor.php file I have:
<?php
$head = new armor("Leather Helm");
$torso = new armor("Leather Shirt");
$pants = new armor("Leather Pants");
$gloves = new armor("Chain Mail Gloves");
$boots = new armor("Leather Boots");

echo "You are wearing: " . $head->get_head() . "on your Head";
echo "<br />";
echo "You are wearing: " . $torso->get_torso() . "on your Torso";
echo "<br />";
echo "You are wearing: " . $pants->get_pants() . "on your Legs";
echo "<br />";
echo "You are wearing: " . $gloves->get_gloves() . "on your Hands";
echo "<br />";
echo "You are wearing: " . $boots->get_boots() . "on your Feet";
?>

Any Help in understanding this will be much appreciated. Thanks.