PDA

View Full Version : PHP field - output a URL from Admin area?



cyberious
01-08-2004, 07:40 PM
I'm very new to PHP and MySQL, but I am modifying a script for an events calendar, and I need one of the fields to be a "Website" field. From the Admin area, I need to enter the URL and have it displayed in the calendar so visitors can click on it and open a new window.

THIS IS THE ENTIRE ADMIN PAGE:


<?php

require("showlister_methods.inc");

?>

<html>

<head>

<title>showlister :: add shows [1]</title>

<link rel="stylesheet" type="text/css" href="showlister.css">

</head>

<body>



<div class="box">

showlister :: add show

</div>



<div class="box">

<form method="post" action="add_shows.php">

<table>

<tr>

<td>

month


<select name="month">

<option value="01">01</option>

<option value="02">02</option>

<option value="03">03</option>

<option value="04">04</option>

<option value="05">05</option>

<option value="06">06</option>

<option value="07">07</option>

<option value="08">08</option>

<option value="09">09</option>

<option value="10">10</option>

<option value="11">11</option>

<option value="12">12</option>

</select>

</td>

<td>

day


<select name="day">

<option value="01">01</option>

<option value="02">02</option>

<option value="03">03</option>

<option value="04">04</option>

<option value="05">05</option>

<option value="06">06</option>

<option value="07">07</option>

<option value="08">08</option>

<option value="09">09</option>

<option value="10">10</option>

<option value="11">11</option>

<option value="12">12</option>

<option value="13">13</option>

<option value="14">14</option>

<option value="15">15</option>

<option value="16">16</option>

<option value="17">17</option>

<option value="18">18</option>

<option value="19">19</option>

<option value="20">20</option>

<option value="21">21</option>

<option value="22">22</option>

<option value="23">23</option>

<option value="24">24</option>

<option value="25">25</option>

<option value="26">26</option>

<option value="27">27</option>

<option value="28">28</option>

<option value="29">29</option>

<option value="30">30</option>

<option value="31">31</option>

</select>

</td>

<td>

year


<select name="year">

<option value="2003">2003</option>
<option value="2004">2004</option>

<option value="2005">2005</option>

<option value="2006">2006</option>

<option value="2007">2007</option>

<option value="2008">2008</option>

<option value="2009">2009</option>

<option value="2010">2010</option>

</select>

</td>

<td>

time


<input type="text" name="time">

</td>


<td>

venue


<input type="text" name="venue">

</td>

<td>

location


<input type="text" name="location">

</td>

<td>

phone


<input type="text" name="phone">

</td>
<td>

website


<input type="text" name="website">

</td>



</tr>

<tr>

<td colspan="8" align="center">

<input type="submit" value="add show">

</td>

</tr>

</table>

</form>

</div>



<?php

footer();

?>

I'm not sure about the admin page, and do need some help with any changes that need to be made to the "Details" field in the MySQL database, if possible. I'm REPLACING the Details field with "Website".

Any help would be greatly appreciated! I need to figure this one out for a possible client.

Thanks in advance!

cyberious
01-09-2004, 02:18 PM
I guess I was a bit tired when I was working on this. I did figure it out this morning.....

Here's the solution:

Instead of messing with the fields in the Admin Panel, you just have to touch up the HTML on the resulting page that it appears on.

Like this:


echo("\t\t<td>" . "" . "$the_website" . " ('" . "$the_website" . "')</td>\n");

As far as the database goes, all I needed to do was add the "website" to it...

Sorry for posting a dumb question!