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
Shopping Cart
Can anyone direct me to a Simple, Basic structure of a shopping cart.New to classes. I want to store info in sessions and write to the db.Is this the right approach?newbee.Thanks,
chat
hello i'm amir
Secure FTP
Hi experts,
Strange php code found on my website
I got hacked and the following code was placed within my files:Code: [Select]<?/*Kodlama By Liz0ziMSafe Mode Command Execution Shell*/function
Login Issue's
Code: <?php $file = fopen('user.txt', 'r');/* Set login to false initially */$login = false/* Break out of loop if login becomes true OR EOF is encountered */while(($login == false)
please, need help coding this voting for your favorite car polling system.
hi, my code needs a lot of work, but i want to be able to let users vote on their favorite car, update the database, and display the new updated data for the top ten cars listed. i want to prevent
need help with mail()
hi i want to send an email with attaching pdf file using php. i have the following script but the problem with this is when i send an attachment it does to the specified address but that email is
Deleted Delivery but material wont return
We deleted a delivery but the material its still pending.
How many users online in the last 24-hours using time()?
I'm fairly new to PHP. I have a MySQL table called 'users' and a field called 'loggedin' which is in time() format.I need a query that'll check how many players have logged in within the last
can i optmize image to 50% quality before uploading 2 server
Hi therei have jus written a php program to upload and display images but when i try to upload them it takes a long time to upload if the file is big. But the big problem is when i try to display
