PHP - Php Newbie Question...

Hi there, I am scratching my head for ages trying to get this to work.  I am adapting a script that simply outputs a floorplan image from a MySQL database. Only problem is that it outputs the <DIV> and all the title and formatting even if no image exists. I only want to output the <DIV> if an image exists.  Thanks in advance for any help. Charlotte


Code: [Select]
<div id="property-contact">
    <h2 id="h2-section" class="h2-section"><?php _e('Floor Plan',TS_DOMAIN) ?></h2>
    <div class="box2 clearfix">
   <?php $floor_plans_image_id =get_post_meta($post->ID, "_thumbnail_id", true);
    $myrows = $wpdb->get_results( "SELECT guid FROM wp_posts WHERE ID=".$floor_plans_image_id );

   ?>
   <a href="<?=$myrows[0]->guid?>" rel="prettyPhoto[gallery]"><img src="<?=$myrows[0]->guid?>" width="250px;"/></a>
</div><!-- end box3 -->
</div>

hi I'm a newbie in php and I came across this

Code: [Select]
if($_SERVER['REQUEST_METHOD'] == 'POST'){

and this
Code: [Select]
$_POST = $this->_params;

I know this might be a stupid question but can you please tell me what they are

After looking around the net and getting i feel close i though i would post and ask you all.

I am trying to add x number of names to a database each on its own row. I found some code and have edited it and i understand most of what its doing but i cannot get it to work, it just add witch ever name was last.

Here is the form code just with 3 test fields.
Quote

<form id="form1" name="form1" method="post" action="addplayer2.php">
       <p>
        <input name="player[]" type="text" id="player[]" size="15" />
      </p>
         <p>
        <input name="player[]" type="text" id="player[]" size="15" />
      </p>
         <p>
        <input name="player[]" type="text" id="player[]" size="15" />
      </p>
 <input type="submit" name="submit" id="submit" value="Submit" />
</form>


Ok this the script i found in it unedited state, i thought i would be easy to understand if you saw it before i broke it.

I tried changing the word Activity to player and the work Act to play and then changing all other referanced.
Quote

<?php
$con = mysql_connect("localhost","Application","*******");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("CpaApp", $con);

foreach($_POST['Activity'] as $row=>$Act)
{
$Activity=$Act; // why does this not have post? Or is it using the one above?
$Position=$_POST['Position'][$row];
$StartDate=$_POST['StartDate'][$row];
$EndDate=$_POST['EndDate'][$row];
}


//enter rows into database
foreach($_POST['Activity'] as $row=>$Act)
{
$Activity=mysql_real_escape_string($Act); // Same question why no $_POST? does it use the one above?
$Position=mysql_real_escape_string($_POST['Position'][$row]);
$StartDate=mysql_real_escape_string($_POST['StartDate'][$row]);
$EndDate=mysql_real_escape_string($_POST['EndDate'][$row]);
}


$involv = "INSERT INTO Involvement (Activity, Position, StartDate, EndDate)
VALUES ('.$Activity.','.$Position.','.$StartDate.','.$EndDate.')";


if (!mysql_query($involv,$con))
{
die('Error: ' . mysql_error());
}
echo "$row record added";

mysql_close($con)
?>


On filling out the fields with name lets say Paul Bill and Jack it echos that it has added x number of rows but when looking in the database it has only added the last in this case Jack.

If there is anyone willing to edit the code above so it will work with my single field i would be very great full, also if someone would answer the questions i placed in the script that would be great also.

Many thanks.
Lister471

Hye there im branded new in php here. Im trying to develop a system based on php and mysql.
I have 20 fields on my database table. Im trying to separate fields into 2 forms which is each form contain 10 fields
- form_1.php(contain 10 fields)
-form_2.php(contain 10 fields)

form_1.php and form_2.php is connected each other which is user have to insert data in the form_1.php and then there are NEXT button that will bring user to form_2.php.In the form_2.php there will be a SUBMIT button which send data to database.
Im trying to do but i cannot go through can someone show me any way to ??

Hello,  I'm new to PHP/MySQL.  Here's the situation: I have a simple little database called, "quiz."  (I want to keep it simple until I figure out what I'm doing.)  This database has one user, me, and two tables: Questions (QuestionID, QuestionText), and Answers (QuestionID, OptionText)  QuestionID is set to autoincrement.  I have one record so the biggest QuestionID is 1.

Here is the php file:

 <?php
$link = mysql_connect('PathToMySQL', 'MyUsername', 'MyPassword');
 if (!$link) {
  die('Could not connect: ' . mysql_error());
}
echo 'Connected!';
mysql_select_db(quiz);
$sql = 'SELECT QuestionID, MAX(QuestionID) FROM Questions;';

// everything works great until this point
// but I want the store the data into a variable so the
// answer form will know what QuestionID to assign to the answers.
// So I tried the following:

echo $sql;

// but that just echoed the query itself, not the result.
// I got: Connected!SELECT "QuestionID, MAX(QuestionID) FROM Questions;"
// I was expecting to see: "Connected!1"

// close database
mysql_close($link);
?>

 

I need to capture the value of QuestionID to pass that to the answers.  How do I do that?

Thank you all for this forum, and for any answers.  That PHP manual is thick and complex.  I always hate being a newbie.  I have been in Newbieville for several languages now; this is no different.  I can say from experience that the good news is that it gets better!

 

Richard Hollenbeck