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
At max how many columns is advisable to create in a table/view
Hi All,
HTAccess auto log in?
Hi all.Too busy driving celebs about lately so I hope someone here can help me out.I need a script that will allow a user to access an HTAccess directory automatically, without the need of
user administration
Dear @all,
Pls help with PHP
Pls can anyone direct me on how to create a user account for a customer. For example i want know if i need to use the "create databse" and create "user identified by ''" for each
PRotect my POST DATA... FROM HTML ATTACKS
I need to like let's sayIf a user submit's his Prayer and he put's <meta refresh stuff while posting his Prayer, I need to disable that and replace it with some other text... so it doesn't
Not capturing all the information we require in the form.......
Hi Guys,I was wondering if you would share some more of your knowledge today, I'm hoping it will be quite a simple answer for you but one that is boggling us here! ;-)We have an html form that users
php automatically escaping single quotes
I'm trying to test out my security a bit and I've noticed that php is escaping my single quotes. For instance I enter x' OR 1=1-- in a form and the output it gives me is x\' OR 1=1--.Is there a
PHP hyperlinks generator
HiI need some help to get this done using php:1 - I have few hyperlinks say 500 in format like:<a href="http://domaina.com/1.html"
PHP arrays into arrays need help
HelloI am trying to highlight the days on my calendar based on the dates that i have in my database. Currently I can only get it to display the last element in the database which leads me to believe
Detail Expenses Report by Cost Center
I would like to obtain a report out of SAP that shows a list of expenses by cost center that shows the vendor that the expense related to.
