hello,
Thanks for looking this over and helping me out. My problem is I have a online store locator database and whats happening is I keep getting an "array" message when I look at the store. I am working with the following code...
The first file I created was something called countrydropdown.php and here is the code in that file..
Code: function countrydropdown() {
?>
<form method="post">
Please choose type of Party Occsaion Hosted::<br /><br />
Weddings:<input type="checkbox" value="Weddings" name="country[]">:
Birthday Parties:<input type="checkbox" value="Birthday" name="country[]">:
Social Events:<input type="checkbox" value="Social" name="country[]">:<br /><br />
Games:<input type="checkbox" value="Games" name="country[]">:
Anniversaries:<input type="checkbox" value="Anniversaries" name="country[]">:
Fantasy Leagues:<input type="checkbox" value="Fantasy" name="country[]">:<br /><br />
Meetings:<input type="checkbox" value="Meetings" name="country[]">:
Sports:<input type="checkbox" value="Sports" name="country[]">:
Awards:<input type="checkbox" value="Awards" name="country[]">:
Baby Showers:<input type="checkbox" value="Baby Showers" name="country[]">:<br /><br />
Kid Friendly:
Yes:<input type="checkbox" value="Yes" name="country[]">:
No:<input type="checkbox" value="No" name="country[]">:
<?php
}
?>
The second file I am working with is the inc_newstore.php and its contents are...
Code: include("inc_security.php");
global $strFormadminstate;
screenheading("Party Room Submission Form");
print("<form action="{$_SERVER['PHP_SELF']}" method="post">n");
print("<input type="hidden" name="pageaction" value="savestore">n");
print $strFormadminstate;
print("<table class="newtable" width="572" border="0" cellpadding="2" cellspacing="2">n");
print(" <tr>n");
print(" <td width="110" class="newhead"> Capacity</td>n");
print(" <td class="newtext"><input type="text" name="companystoreID" size="20"></td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="newhead"> Store name</td>n");
print(" <td class="newtext"><input type="text" name="storename" size="40"></td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="newhead"> Address</td>n");
print(" <td class="newtext"><input type="text" name="address" size="40"></td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="newhead"> City</td>n");
print(" <td class="newtext"><input type="text" name="city" size="40"></td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="newhead"> State</td>n");
print(" <td class="newtext">");
include ("statedropdown.php");
print(" <tr>n");
print(" <td class="newhead"> Zip / Post Code</td>n");
print(" <td class="newtext"><input type="text" name="zippostcode" size="20"></td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="newhead"> Telephone 1</td>n");
print(" <td class="newtext"><input type="text" name="telephone1" size="30"></td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="newhead"> Telephone 2</td>n");
print(" <td class="newtext"><input type="text" name="telephone2" size="30"></td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="newhead"> Fax</td>n");
print(" <td class="newtext"><input type="text" name="fax" size="30"></td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="newhead"> Email</td>n");
print(" <td class="newtext"><input type="text" name="email" size="50"></td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="newhead"> Website</td>n");
print(" <td class="newtext">http:// <input type="text" name="website" size="50"></td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="newhead"> Party Occasions</td>n");
print(" <td class="newtext">");
countrydropdown();
print(" <tr>n");
print(" <td class="newhead">Description of <br/>Party Room
Kid Friendly
Wi-Fi Access
Or Other Features
</td>n");
print(" <td class="newtext"><textarea name="description" rows="5" cols="40" onkeyup="CheckFieldLength(description, 'charcount1', 'remaining1', 255);" onkeydown="CheckFieldLength(description, 'charcount1', 'remaining1', 255);" onmouseout="CheckFieldLength(description, 'charcount1', 'remaining1',255);"></textarea>
n");
print("<small><span id="charcount1">0</span> characters entered. | <span id="remaining1">255</span> characters remaining.</small>n");
print("</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="newhead"> Store Hours</td>n");
print(" <td class="newtext">n");
print("<table cellpadding="2" cellspacing="2" border="0">");
print(" <tr>n");
print(" <td></td><td class="hourshead">OPEN</td><td class="hourshead">CLOSE</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="hoursday">Monday</td>n");
print(" <td class="hourstext"><input type="text" name="openmonday" size="15"></td>n");
print(" <td class="hourstext"><input type="text" name="closemonday" size="15"></td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="hoursday">Tuesday</td>n");
print(" <td class="hourstext"><input type="text" name="opentuesday" size="15"></td>n");
print(" <td class="hourstext"><input type="text" name="closetuesday" size="15"></td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="hoursday">Wednesday</td>n");
print(" <td class="hourstext"><input type="text" name="openwednesday" size="15"></td>n");
print(" <td class="hourstext"><input type="text" name="closewednesday" size="15"></td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="hoursday">Thursday</td>n");
print(" <td class="hourstext"><input type="text" name="openthursday" size="15"></td>n");
print(" <td class="hourstext"><input type="text" name="closethursday" size="15"></td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="hoursday">Friday</td>n");
print(" <td class="hourstext"><input type="text" name="openfriday" size="15"></td>n");
print(" <td class="hourstext"><input type="text" name="closefriday" size="15"></td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="hoursday">Saturday</td>n");
print(" <td class="hourstext"><input type="text" name="opensaturday" size="15"></td>n");
print(" <td class="hourstext"><input type="text" name="closesaturday" size="15"></td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="hoursday">Sunday</td>n");
print(" <td class="hourstext"><input type="text" name="opensunday" size="15"></td>n");
print(" <td class="hourstext"><input type="text" name="closesunday" size="15"></td>n");
print(" </tr>n");
print("</table>n");
print("
n");
print("Other hours information
n");
print("<textarea name="opencloseinfo" rows="5" cols="40" onkeyup="CheckFieldLength(opencloseinfo, 'charcount2', 'remaining2', 255);" onkeydown="CheckFieldLength(opencloseinfo, 'charcount2', 'remaining2', 255);" onmouseout="CheckFieldLength(opencloseinfo, 'charcount2', 'remaining2',255);"></textarea>
n");
print("<small><span id="charcount2">0</span> characters entered. | <span id="remaining2">255</span> characters remaining.</small>n");
print("</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="newhead"> Store Manager</td>n");
print(" <td class="newtext"><input type="text" name="storemanager" size="40"></td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="newhead"> Map Link</td>n");
print(" <td class="newtext">http:// <input type="text" name="maplink" size="50"></td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="newhead"> Directions</td>n");
print(" <td class="newtext"><textarea name="directions" rows="5" cols="40" onkeyup="CheckFieldLength(directions, 'charcount3', 'remaining3', 255);" onkeydown="CheckFieldLength(directions, 'charcount3', 'remaining3', 255);" onmouseout="CheckFieldLength(direcitons, 'charcount3', 'remaining3',255);"></textarea>
n");
print("<small><span id="charcount3">0</span> characters entered. | <span id="remaining3">255</span> characters remaining.</small>n");
print("</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="newhead"> Active</td>n");
print(" <td class="newtext"><input type="checkbox" name="recordstatus" value="active" checked></td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td> </td>n");
print(" <td><input type="submit" value="save store"></td>n");
print(" </tr>n");
print("</table>n");
print("</form>n");
print("<div id="bottomspacer"></div>n");
?>
Finally the third file is inc_viewstore.php file and its contents is...
Code: include("inc_security.php");
screenheading("Viewing Party Room Record");
if (isset($_REQUEST['id']))
(int)$intID = addslashes($_REQUEST['id']);
else
$intID = null;
$SQLstmt = "SELECT storeID, companystoreID, storename, address, city, suburb, " .
"statename, country, zippostcode, telephone1, telephone2, fax, " .
"email, website, description, openmonday, closemonday, opentuesday, " .
"closetuesday, openwednesday, closewednesday, openthursday, " .
"closethursday, openfriday, closefriday, opensaturday, closesaturday, " .
"opensunday, closesunday, opencloseinfo, storemanager, maplink, " .
"directions, recordstatus, slstore.recordlastmodified, " .
"slstore.recordlastmodifiedby, slstore.recordcreated, " .
"slstore.recordcreatedby FROM slstore LEFT JOIN slstate ON " .
"slstore.stateID = slstate.stateID WHERE storeID = '$intID'";
if ($resultSet = dbaction($SQLstmt))
{
$row = getrsrow($resultSet);
print("<table width="572" class="viewtable" border="0" cellpadding="4" cellspacing="2">n");
print(" <tr>n");
print(" <td class="viewhead" width="120"> Store ID</td>n");
print(" <td class="viewtext">{$row['storeID']}</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="viewhead"> Capacity</td>n");
print(" <td class="viewtext">{$row['companystoreID']}</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="viewhead"> Store Name</td>n");
print(" <td class="viewtext">{$row['storename']}</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="viewhead"> Address</td>n");
print(" <td class="viewtext">{$row['address']}</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="viewhead"> City</td>n");
print(" <td class="viewtext">{$row['city']}</td>n");
print(" </tr>n");
print(" <td class="viewhead"> State</td>n");
print(" <td class="viewtext">{$row['statename']}</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="viewhead"> Zip / Post Code</td>n");
print(" <td class="viewtext">{$row['zippostcode']}</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="viewhead"> Telephone 1</td>n");
print(" <td class="viewtext">{$row['telephone1']}</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="viewhead"> Telephone 2</td>n");
print(" <td class="viewtext">{$row['telephone2']}</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="viewhead"> Fax</td>n");
print(" <td class="viewtext">{$row['fax']}</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="viewhead"> Email</td>n");
print(" <td class="viewtext">");
if ($row['email'] != "")
print("<a href="mailto:{$row['email']}">{$row['email']}</a>");
print("</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="viewhead"> Website</td>n");
print(" <td class="viewtext">");
if ($row['website'] != "")
print("<a href="http://{$row['website']}" target="_blank">{$row['website']}</a>");
print("</td>n");
print(" <tr>n");
print(" <td class="viewhead"> Party Occasion</td>n");
print(" <td class="viewtext">{$row['country']}</td>n");
print(" </tr>n");
print(" <td class="viewhead"> Description of <br/>Party Room
Kid Friendly
Wi-Fi Access
Or Other Features
</td>n");
print(" <td class="viewtext">{$row['description']}</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="viewhead"> Store Hours</td>n");
print(" <td class="viewtext">n");
print("<table cellpadding="2" cellspacing="2" border="0">");
print(" <tr>n");
print(" <td></td><td class="hourshead">OPEN</td><td class="hourshead">CLOSE</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="hoursday">Monday</td>n");
print(" <td class="hourstext">{$row['openmonday']}</td>n");
print(" <td class="hourstext">{$row['closemonday']}</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="hoursday">Tuesday</td>n");
print(" <td class="hourstext">{$row['opentuesday']}</td>n");
print(" <td class="hourstext">{$row['closetuesday']}</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="hoursday">Wednesday</td>n");
print(" <td class="hourstext">{$row['openwednesday']}</td>n");
print(" <td class="hourstext">{$row['closewednesday']}</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="hoursday">Thursday</td>n");
print(" <td class="hourstext">{$row['openthursday']}</td>n");
print(" <td class="hourstext">{$row['closethursday']}</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="hoursday">Friday</td>n");
print(" <td class="hourstext">{$row['openfriday']}</td>n");
print(" <td class="hourstext">{$row['closefriday']}</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="hoursday">Saturday</td>n");
print(" <td class="hourstext">{$row['opensaturday']}</td>n");
print(" <td class="hourstext">{$row['closesaturday']}</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="hoursday">Sunday</td>n");
print(" <td class="hourstext">{$row['opensunday']}</td>n");
print(" <td class="hourstext">{$row['closesunday']}</td>n");
print(" </tr>n");
print("</table>n");
print("
n");
print("Other hours information
n");
print $row['opencloseinfo'];
print("</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="viewhead"> Store Manager</td>n");
print(" <td class="viewtext">{$row['storemanager']}</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="viewhead"> Map Link</td>n");
print(" <td class="viewtext">");
if ($row['maplink'] != "")
print("<a href="http://{$row['maplink']}" target="_blank">{$row['maplink']}</a>");
print("</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="viewhead"> Directions</td>n");
print(" <td class="viewtext">{$row['directions']}</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="viewhead"> Record Status</td>n");
print(" <td class="viewtext">");
if ($row['recordstatus'] == "active")
print("active");
else
print("inactive");
print("</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="viewhead"> Last Modified</td>n");
print(" <td class="viewtext">{$row['recordlastmodified']}</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="viewhead"> Last Modified By</td>n");
print(" <td class="viewtext">{$row['recordlastmodifiedby']}</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="viewhead"> Created</td>n");
print(" <td class="viewtext">{$row['recordcreated']}</td>n");
print(" </tr>n");
print(" <tr>n");
print(" <td class="viewhead"> Created By</td>n");
print(" <td class="viewtext">{$row['recordcreatedby']}</td>n");
print(" </tr>n");
print("</table>n");
print("<div id="bottomspacer"></div>n");
}
?>
Now I know my problem is somewhere in the file "inc_viewstore". The line with the issue is...
Code: print
(" <tr>n");
print(" <td class="viewhead"> Party Occasion</td>n");
print(" <td class="viewtext">{$row['country']}</td>n");
print(" </tr>n");
When I tested this I kept seeing the word "Array" popup under "Party Occasion". I took a screenshot
EDIT: Seriously dude.. use CODE tags
Insert data in Mysql and move to another page
I'm stuck with this simple problem. I need to insert data in Mysql and then hit submit and move to another page. My first thougt was to use Post but that didn't work. How do I use Get and Post to do
apart from cron
I need to run a php file every one hour. Is there any other solution apart from cron job?
using explode() to fill in checkboxes
HiI have a field stored in a table that contains regions in the UK separated by commas. There could be any number of pieces held in this field from 1-12, based upon the users specified operating
How a counter of users ? such as ---> (231 Viewing)
I want to count how many users are actually viewing the page, How is that possible?Thank you guys!
$action = "insert"; //$action = $_GET['action'];
$action = "insert";//$action = $_GET['action'];why is this invalid type? I am just modifying code that is there and want the action = insert so it will run all the parts of the code for
Email/MMS to Site
Hey guys. I'm looking for a way for a user to upload images and/or text via their cell phones. It could be MMS but since most phones have email these days, maybe just a way to process email. I've
some query on multilingual website
Hi all,Which is the simplest and easiest method to make a website multilingual,is it putting files in different folder for different languages? or something else ?any suggestions will be
empty() error
Why doesCode: empty($USER_ID = $_SESSION["USER_ID"])create this error...Parse error: syntax error, unexpected '=', expecting ')' in /home3/finestto/public_html/index.php on line 17
path to include folder
Hi everyone,When I'm testing locally, I have to add the name of the site folder as part of the path name when I'm including files, eg.include $_SERVER['DOCUMENT_ROOT'] .
Filename and Line Number Custom Error
I have a class, with a method that accepts 2 parameters. I would like to output error messages. So, lets say a new file is created, and my class is used in that file. We will call that file test.php
