PHPEEEE! Newbee!

aussiejackson

Hi All,

After a little direction if someone can spare a second? Very new to php but I'm slowly filling the blanks. Could someone tell me how I would accomplish the following or point me to a tutorial that would show me these basics?

I would like to make a form on one of my pages (templates) not show up if a certain field in the database is empty. E.g.If the email filed in the database is empty, don't show the form. If someone could give me an example of this working that would be fantastic!

team_lh_Max

First you should connect to your database, assuming you know how that works, write a seperate file for database connection and include it

include "dbconnect.inc.php"

then with the sql query get the field and save it in lets say $email

now to your real question i think this should do it.
In case your question was more related to connect to the database and so on there are tons of tutorials, simply google it.

$form = '<form action=.....</form>'

if(isset($email) { //This line is somehow related to your table field type as well, you might try as well if($email == 0) {
echo $form;
} else {
exit();
}

aussiejackson

Thanks team.lh Max! I think that's the answer I was looking for. The CMS I am editing is already connected to the database and I'm having not problem pulling info from it but I just didn't want the form showing if there was no email value to send it to.

You hit the nail on the head man! That's perfect.

aussiejackson

Sorry buddy. I can't seem to figure out exaclyt how this code would be applied to my document.

This is how I've got it:

<?php require_once('inc/contact.php'); ?>
<br>

$form = '<form action="http://www.marketsonline.com.au/contact_m_admin/dynaform/dynaform.php" method="POST">
<input type="hidden" name="rec_mailto" value="<?=$page[adminemail]?>">
<input type="hidden" name="rec_subject" value="New DynaForm Email">
<input type="hidden" name="rec_thanks" value="http://www.marketsonline.com.au/contact_m_admin/dynaform/thanks.html">
Name<br><input type="text" name="Name"><br><br>
Email<br><input type="text" name="Email"><br><br>
Comments<br><input type="text" name="Phone"><br><br>
Address<br><input type="text" name="Comments"><br><br>
<input type="submit" value="Submit">
</form>'

<?php  if($adminemail == 0) {
echo $form;
} else {
exit();
}?>

</body>
</html>

If I sound like an idiot I apologise! I have attached the php file for you to see if your would like.

team_lh_Max

lol its ok

well first of all you forgot the opening and closing php tags around the $form, like this php is ignoring it.

Try that and then there might still be a problem with the variable $adminemail which seems to be saved in an aray.

In case you run into troubles remove the line

<?=$page[adminemail]?>

and replace with <? $adminemail ?>.

On top of the $form put

$adminemail = $page[adminemail]

But you shouldnt forget im a n00b too, just a bit more experienced then you perhaps,..but still a n00b. Perhaps you should wait for somebody more experienced.

Crowly

Something along these lines:

<?php 
  require_once('inc/contact.php');
  echo "<br>";

  // you need to add some code here too add value to $page

  if ($adminemail!==NULL) {
printf( "<form action=\"http://www.marketsonline.com.au/contact_m_admin/dynaform/dynaform.php\" method=\"POST\">
<input type=\"hidden\" name=\"rec_mailto\" value=\"%s\">
<input type=\"hidden\" name=\"rec_subject\" value=\"New DynaForm Email\">
<input type=\"hidden\" name=\"rec_thanks\" value=\"http://www.marketsonline.com.au/contact_m_admin/dynaform/thanks.html\">
Name<br><input type=\"text\" name=\"Name\"><br><br>
Email<br><input type=\"text\" name=\"Email\"><br><br>
Comments<br><input type=\"text\" name=\"Phone\"><br><br>
Address<br><input type=\"text\" name=\"Comments\"><br><br>
<input type=\"submit\" value=\"Submit\">
</form>",$page['adminemail']);
}

?>

In the if statement you could try these checks instead:

if ($email!=="") {}
if (strlen($email)>0) {} // if the length of $email is above 0 do something

Heres bigger example that i use on one of my pages. I have a table that displays info from a table, but depending on a parameter i add some extra fields and a form to the table so i can update it as well. It will only add the form and extra fields when $valg=="en".
( \n is not required, it just adds a new line, so the code is more readable when you view the html source after execution)

     // more code here 

  $result=mysql_query("select * from medlemmer order by $order",$link);

  if ($valg=="en")
  {
    echo "<form action=\"oppdater.php\" method=\"POST\">";
    $f=12;
  }
  else
  {
    $f=15;
  }

  printf("<TABLE BORDER=\"1\" id=\"table5\" CELLSPACING=\"1\" CELLPADDING=\"1\" 
   style=\"border: 1px #000000; font-size: %dpx; align=center;\">\n",$f);
  echo "<tr>\n";      
  if ($valg=="en")
  {
    echo"<td>#</td>\n";
  }
  echo "<TD>&nbsp;<a href=\"index.php?order=navn\"><b>Navn</b></a></TD>\n<TD>&nbsp;<b>Adresse</b>&nbsp;</TD>\n<TD>&nbsp;<b>Postnr</b>&nbsp;</TD>\n<TD>&nbsp;<b>Poststed</b>&nbsp;</TD>\n<TD>&nbsp;<b>Tlf</b>&nbsp;</TD>\n<TD>&nbsp;<b>Mobil</b>&nbsp;</TD>\n<TD>&nbsp;<b>Epost</b>&nbsp;</TD>\n<TD>&nbsp;<a href=\"index.php\"><b>Verv</b></a>&nbsp;</TD></TR>\n";

  while($row = mysql_fetch_array($result))
  { 
    echo "<tr>\n";
    if ($valg=="en")
    {
      printf("<td><input type=\"radio\" name=\"id\" value=\"%d\"></td>\n",$row['id']);
    }
    printf("<td>&nbsp;%s</td>\n<td>&nbsp;%s&nbsp;</td>\n<td>&nbsp;%s&nbsp;</td>\n<td>&nbsp;%s&nbsp;</td>\n<td>&nbsp;%s&nbsp;</td>\n<td>&nbsp;%s&nbsp;</td>\n<td>&nbsp;%s&nbsp;</td>\n<td>&nbsp;%s&nbsp;</td></tr>\n",$row["navn"],$row["adresse"],$row["postnr"],$row["poststed"],$row["tlf"],$row["mobil"],$row["epost"],$row["posisjon"]); 
  }
  if ($valg=="en")
  { 
    echo "<tr>
      <td>Ny:&nbsp;</td>
      <td><input type=\"text\" size=\"12\" name=\"navn\"></td>
      <td><input type=\"text\" size=\"15\" name=\"adresse\"></td>
      <td><input type=\"text\" size=\"7\" name=\"postnr\"></td>
      <td><input type=\"text\" size=\"11\" name=\"poststed\"></td>
      <td><input type=\"text\" size=\"10\" name=\"tlf\"></td>
      <td><input type=\"text\" size=\"10\" name=\"mobil\"></td>
      <td><input type=\"text\" size=\"23\" name=\"epost\"></td>
      <td><select name=\"pos\">\n
      <option value=\"\">\n";
      while ($vrow = mysql_fetch_array($vresult))
      {
        printf("<option value=\"%s\">%s\n",$vrow['posisjon'],$vrow['posisjon']);
      }
      echo "           <tr>\n<td colspan=\"9\" style=\"text-align: center;\"><INPUT TYPE=\"submit\" VALUE=\"OK\">&nbsp;<INPUT TYPE=\"Reset\" VALUE=\"Reset\"></td>\n</tr>\n";
      echo "           </select>\n</td>\n
      </tr>\n";
  }
  echo "</table>\n"; //slutt tabel5
  if ($valg=="en")
  {
    echo "</form>\n";
  }

Hope this can point you in the right direction.

aussiejackson

Hi Guys,

Thanks heaps for the advise but I seem to be a little bit stuck. Here's where i'm at:

<?php
  echo "<br>";

  // you need to add some code here too add value to $page

  if ($adminemail!==NULL) {
printf( "<form action=\"http://www.marketsonline.com.au/contact_m_admin/dynaform/dynaform.php\" method=\"POST\">
<input type=\"hidden\" name=\"rec_mailto\" value=\"%s\">
<input type=\"hidden\" name=\"rec_subject\" value=\"New DynaForm Email\">
<input type=\"hidden\" name=\"rec_thanks\" value=\"http://www.marketsonline.com.au/contact_m_admin/dynaform/thanks.html\">
Name<br><input type=\"text\" name=\"Name\"><br><br>
Email<br><input type=\"text\" name=\"Email\"><br><br>
Comments<br><input type=\"text\" name=\"Phone\"><br><br>
Address<br><input type=\"text\" name=\"Comments\"><br><br>
<input type=\"submit\" value=\"Submit\">
</form>",$page['adminemail']);
} ?>

Regarding the statement:

 // you need to add some code here too add value to $page

Sorry... I don't understand. Could you please explain how I add a value?

With the code I have added above, the form does not show up at all. There are no errors though. Maybe this is because of me not defining the value of $page?

I assume that the <?php tags have to go around the whole string of code? Also what does it mean by having value=\"%s\"?

I attached the new php doc as a text file in case anyone wants to correct my mistakes......

Thanks again everyone.

aussiejackson

I couldn't get it to work the way you said but I got it to work this way:

<?php if($page[adminemail]) {
printf( "<form action=\"http://www.marketsonline.com.au/contact_m_admin/dynaform/dynaform.php\" method=\"POST\">
<input type=\"hidden\" name=\"rec_mailto\" value=\"%s\">
<input type=\"hidden\" name=\"rec_subject\" value=\"New DynaForm Email\">
<input type=\"hidden\" name=\"rec_thanks\" value=\"http://www.marketsonline.com.au/contact_m_admin/dynaform/thanks.html\">
Name<br><input type=\"text\" name=\"Name\"><br><br>
Email<br><input type=\"text\" name=\"Email\"><br><br>
Comments<br><input type=\"text\" name=\"Phone\"><br><br>
Address<br><input type=\"text\" name=\"Comments\"><br><br>
<input type=\"submit\" value=\"Submit\">
</form>",$page['adminemail']);
} ?>

Thanks guys.

Crowly

Also what does it mean by having value=\"%s\"?

\ is just an escape char so it doesnt think the string ends at the ". Instead of \" i guess you can use a mix of " and ', ex 'something something value="test" something else'. But i prefer the \" method.

The %s is the string value of $page['adminemail']. Read more on Printf here.

What i meant by adding a value to $page['adminemail'] was that at some point before the if and printf command you have to assign a value to the variable with something like $page=mysql_fetch_array() etc.

Hope that cleared things up a bit. Im still quite new to PHP myself so might not always be the best to explain stuff. Most of my coding experience comes from Oracle Forms 6 and Pl/Sql.