[thelist] help with project design

[Terion Miller]

On Tue, Nov 25, 2008 at 3:13 PM, Matt McKeon <matt at camadro.com> wrote:

> Terion Miller wrote:
> > I have to make a form to add text ads to a db then have those ads display
> in
> > a table with 3 columns 1 ad per column and this little application has to
> > work inside the Helios adserver, I'm stuck because at this point I can't
> > even get my form working on my local server...
> >
> > all the code I have written thus far:
> >
> > <?php include("inc/dbConnOpen.php") ;   /* connect */
> >
> > if (isset($_POST['HREF'])){$HREF = $_POST['HREF'];} else {$HREF = "";}
> >     {$errmsg = 'Please Select a LINK FOR THE AD';}
> > if (isset($_POST['TITLE'])){$TITLE = $_POST['TITLE'];} else {$TITLE =
> "";}
> > {$errmsg = 'Please Select a TITLE FOR THE AD';}
> > if (isset($_POST['BLURB'])){$BLURB = $_POST['BLURB'];} else {$BLURB =
> "";}
> > {$errmsg = 'Please enter the text for the ad';}
> > if (isset($_POST['BDATE'])){$BDATE = $_POST['BDATE'];} else {$BDATE =
> "";}
> > {$errmsg = 'Please enter the beginning date for the ad';}
> > if (isset($_POST['EDATE'])){$EDATE = $_POST['EDATE'];} else {$EDATE =
> "";}
> > {$errmsg = 'Please enter the end date for the ad';}
> >
> > mysql_select_db($mysql);
> > $sql = "INSERT INTO textads (HREF, TITLE, BLURB,BDATE,EDATE,EXPOS) VALUES
> > ('HREF',' BLURB', 'BDATE', 'EDATE', 'EXPOS')";
> > mysql_query($sql) or die('Error, insert query failed');
> > ?>
> >
> So, are you getting errors or what's happening when you run this?
>
> Hum, looks like you've got a lot of syntax errors.
> What do these lines mean  {$errmsg = 'Please enter the text for the ad';} ?
>
> I'm assuming they should be a part of the else? It should then look more
> like:
> if (isset($_POST['BLURB'])) {
>   $BLURB = $_POST['BLURB'];
> } else {
>   $BLURB = "";
>   $errmsg = 'Please enter the text for the ad';
> }
>
> That should be a start since you didn't specify what you need help with.
>
> HTH
> Matt
>
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>
Thanks that did help, for some reason I'm having so many problems with php (
I have mostly been only layout and design as in html and css person)
so now I have (thought I would get to the basics) ;
<?php
if(isset($_POST['add']))
{
include 'inc/dbconnOpen.php';
$HREF = $_POST['HREF'];
$TITLE = $_POST['TITLE'];
$BLURB = $_POST['BLURB'];

$query = "INSERT INTO 'textads' ('HREF', 'BLURB', 'TITLE') VALUES ('$HREF',
'$TITLE', '$BLURB'), 'Y', 'Y', 'Y')";
mysql_query($query) or die('Error, friggin insert query failed');

echo "New Dream Job Text Ad  added";
}
else
{
?>
<form method="post">
<table width="400" border="0" cellspacing="1" cellpadding="2">
<tr>
<td width="100">TITLE</td>
<td><input name="TITLE" type="text" id="TITLE"></td>
</tr>
<tr>
<td width="100">Blurb</td>
<td><input name="BLURB" type="text" id="BLURB"></td>
</tr>
<tr>
<td width="100">LINK</td>
<td><input name="HREF" type="text" id="HREF"></td>
</tr>


<tr>
<td width="100">&nbsp;</td>
<td><input name="add" type="submit" id="add" value="Add AD"></td>
</tr>
</table>
</form>
<?php
}
?>
</body>
</html>


and still can't get it to insert ....I am trying to follow tutorials but I
just don't get it...