Re: [chris] Posting form results into database

Mon, 21 Jun 2010 14:59:10 -0700

thanks sooo much man!!!

Re: [chris] Posting form results into database

Mon, 21 Jun 2010 14:39:38 -0700

perfect!

now if only I can figure out how to have it redirect to another page after submitting as opposed to just displaying "Thank You"

require_once "XXXX/admin/lib/init.php";

// submit form
if (@$_REQUEST['submit']) {

// error checking
$errorsAndAlerts = "";
if (!@$_REQUEST['first_name']) { $errorsAndAlerts .= "Please specify First Name!
\n"; }
if (!@$_REQUEST['last_name']) { $errorsAndAlerts .= "Please specify Last Name!
\n"; }
if (!@$_REQUEST['email_address']) { $errorsAndAlerts .= "Please specify Email Address!
\n"; }

// turn off strict mysql error checking for: STRICT_ALL_TABLES
mysqlStrictMode(false); // disable Mysql strict errors for when a field isn't defined below (can be caused when fields are added later)

// add record
if (!@$errorsAndAlerts) {
mysql_query("INSERT INTO `{$TABLE_PREFIX}view_sign_up_list` SET
first_name = '".mysql_real_escape_string( $_REQUEST['first_name'] )."',
last_name = '".mysql_real_escape_string( $_REQUEST['last_name'] )."',
club_number = '".mysql_real_escape_string( $_REQUEST['club_number'] )."',
email_address = '".mysql_real_escape_string( $_REQUEST['email_address'] )."',
yes_emails = '".mysql_real_escape_string( $_REQUEST['yes_emails'] )."',
mobile_phone_number = '".mysql_real_escape_string( $_REQUEST['mobile_phone_number'] )."',
cell_phone_carrier = '".mysql_real_escape_string( $_REQUEST['cell_phone_carrier'] )."',
yes_text = '".mysql_real_escape_string( $_REQUEST['yes_text'] )."',

createdDate = NOW(),
updatedDate = NOW(),
createdByUserNum = '0',
updatedByUserNum = '0'")
or die("MySQL Error Creating Record:
\n". htmlspecialchars(mysql_error()) . "\n");
$recordNum = mysql_insert_id();

// display thanks message and clear form
$errorsAndAlerts = "Thank you";
$_REQUEST = array();
}

}

?>

Re: [MRI] Posting form results into database

Mon, 21 Jun 2010 12:57:16 -0700

ok it worked...kind of..

Everything enters into CMSBuilder fine now.. but if I uncheck a box... and submit.. I get this error

Notice: Undefined index: yes_emails in XXXXX/club/signup.php on line 24 Notice: Undefined index: yes_text in XXXXX/club/signup.php on line 27

--------

heres where those errors are:
if (!@$errorsAndAlerts) {
mysql_query("INSERT INTO `{$TABLE_PREFIX}view_sign_up_list` SET
first_name = '".mysql_real_escape_string( $_REQUEST['first_name'] )."',
last_name = '".mysql_real_escape_string( $_REQUEST['last_name'] )."',
crown_club_number = '".mysql_real_escape_string( $_REQUEST['club_number'] )."',
email_address = '".mysql_real_escape_string( $_REQUEST['email_address'] )."',
yes_emails = '".mysql_real_escape_string( $_REQUEST['yes_emails'] )."',
mobile_phone_number = '".mysql_real_escape_string( $_REQUEST['mobile_phone_number'] )."',
cell_phone_carrier = '".mysql_real_escape_string( $_REQUEST['cell_phone_carrier'] )."',
yes_text = '".mysql_real_escape_string( $_REQUEST['yes_text'] )."',

createdDate = NOW(),
updatedDate = NOW(),
createdByUserNum = '0',
updatedByUserNum = '0'")
or die("MySQL Error Creating Record:
\n". htmlspecialchars(mysql_error()) . "\n");
$recordNum = mysql_insert_id();

Re: [Jason] Posting form results into database

Mon, 21 Jun 2010 12:47:54 -0700

ill give that a shot...thanks

Re: [MRI] Posting form results into database

Mon, 21 Jun 2010 09:30:38 -0700

any pointers for this?

Re: [chris] Posting form results into database

Fri, 18 Jun 2010 15:49:33 -0700

require_once "XXXX/admin/lib/init.php";

// submit form
if (@$_REQUEST['submit']) {

// error checking
$errorsAndAlerts = "";
if (!@$_REQUEST['first_name']) { $errorsAndAlerts .= "Please specify First Name!
\n"; }
if (!@$_REQUEST['last_name']) { $errorsAndAlerts .= "Please specify Last Name!
\n"; }
if (!@$_REQUEST['email_address']) { $errorsAndAlerts .= "Please specify Email Address!
\n"; }

// turn off strict mysql error checking for: STRICT_ALL_TABLES
mysqlStrictMode(false); // disable Mysql strict errors for when a field isn't defined below (can be caused when fields are added later)

// add record
if (!@$errorsAndAlerts) {
mysql_query("INSERT INTO `{$TABLE_PREFIX}view_sign_up_list` SET
first_name = '".mysql_real_escape_string( $_REQUEST['first_name'] )."',
last_name = '".mysql_real_escape_string( $_REQUEST['last_name'] )."',
club_number = '".mysql_real_escape_string( $_REQUEST['club_number'] )."',
email_address = '".mysql_real_escape_string( $_REQUEST['email_address'] )."',
yes_emails = '".mysql_real_escape_string( $_REQUEST['yes_emails'] )."',
mobile_phone_number = '".mysql_real_escape_string( $_REQUEST['mobile_phone_number'] )."',
cell_phone_carrier = '".mysql_real_escape_string( $_REQUEST['cell_phone_carrier'] )."',
yes_text = '".mysql_real_escape_string( $_REQUEST['yes_text'] )."',

createdDate = NOW(),
updatedDate = NOW(),
createdByUserNum = '0',
updatedByUserNum = '0'")
or die("MySQL Error Creating Record:
\n". htmlspecialchars(mysql_error()) . "\n");
$recordNum = mysql_insert_id();

// display thanks message and clear form
$errorsAndAlerts = "Thank you";
$_REQUEST = array();
}

}

?>

require_once "/XXXX/admin/lib/viewer_functions.php";

list($email_text_form_pageRecords, $email_text_form_pageMetaData) = getRecords(array(
'tableName' => 'email_text_form_page',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$email_text_form_pageRecord = @$email_text_form_pageRecords[0]; // get first record

?>

XXXXXXXXX

Posting form results into database

Fri, 18 Jun 2010 11:35:22 -0700

For the most part I have this working.. only issue im having is with check boxes and drop down lists. Ill enter all info in a form and hit submit, when I check it in the CMS everything shows except for the item that required me to check a box or select from drop down list.

any help would be great!

also the script you guys gave me a while back for this displays a message after submitting... is there a way for me to direct to a confirmation page instead?

// display thanks message and clear form
$errorsAndAlerts = "Thank you";
$_REQUEST = array();
}

Re: [Jason] Warning: session_start(): ERROR

Mon, 07 Jun 2010 10:38:08 -0700

that did it!

Warning: session_start(): ERROR

Mon, 07 Jun 2010 09:19:36 -0700

I recently updated the cms to the most recent version and ever since, ive been getting this error:

Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /home/ovation2/public_html/ovations/index.php:3) in /home/ovation2/public_html/ovations/admin/lib/init.php on line 74 Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/ovation2/public_html/ovations/index.php:3) in /home/ovation2/public_html/ovations/admin/lib/init.php on line 74

http://www.ovationscasino.com/

Re: [Jason] where clause

Fri, 04 Jun 2010 10:41:38 -0700

perfect.. now is there a way to get it so It displays records that are tagged

Getting Here before records tagged All?

instead of displaying in random order?

where clause

Fri, 04 Jun 2010 10:10:50 -0700

Im trying to get something like this.. but i assume that "or" is correct..

'where' => " page_display LIKE '%\ALL\t%' or '%\Getting Here\t%' ",

Re: [Dave] Lists (checkbox multi value) display multi values?

Mon, 08 Feb 2010 08:56:26 -0800

loaded from another table...thanks

Lists (checkbox multi value) display multi values?

Thu, 04 Feb 2010 11:45:20 -0800

I set u a section that has a multi value checkbox.. I set up the List options to pull data from database.

So for example its pulls Item Name for value and label.

the problem is, when I select a certain checkbox.. on the actual page it just lists the "Item Name".. I want it to also list the Item Description as well as the name.

How do I do this?

Sample code.. this is what im using now:

', getListLabels('rfps', 'case_studies', $rfpsRecord['case_studies'])); ?>

It just displays the Case Study Title... I want it to display the Case Study Title and the Case Study Description

Thanks in advanced

Re: [Dave] User Accounts Error

Fri, 29 Jan 2010 17:09:37 -0800

1.28

User Accounts Error

Fri, 29 Jan 2010 11:29:10 -0800

Hi,

Im trying to set up an account where a user can access and create new users without having admin access...

when that user logs in and trys to create a new user it brings up this error:

MySQL Error: Column 'isAdmin' cannot be null

Re: [chris] No records in category

Mon, 11 Jan 2010 09:14:24 -0800

SEE BELOW: After each section "location" If there are no records with the corresponding location, then I would like it to display the "No Records Available"

" width="" height="" alt="" />

Return to menu

Blaine

" width="" height="" alt="" />

Return to menu

Coon Rapids

" width="" height="" alt="" />

Return to menu

Forest Lake

" width="" height="" alt="" />

Return to menu

Ham Lake

" width="" height="" alt="" />

No records were found!

Return to menu

Lino Lakes

" width="" height="" alt="" />

Return to menu

North Branch

" width="" height="" alt="" />

Return to menu

Vadnais Heights

" width="" height="" alt="" />

Return to menu

White Bear Lake

" width="" height="" alt="" />

Return to menu

No records in category

Fri, 08 Jan 2010 16:42:29 -0800

Ok.. I have a listing for hotels.. in the CMS when you add a hotel, you select from a pre determined list for that hotels location.

So on the website I have all the hotels listed and categorized by location using:

Now i need a solution to display the "No Records Found" if there are no records for that current location.
This doesnt work because its looking at ALL records not just ones labeled with the category location:

No records were found!

So im assuming its just tweaking this line... but I cant figure it out:

Re: [chris] Details Page no record found

Tue, 24 Nov 2009 14:40:58 -0800

cool thanks!! I actually rigged it to work using another way which is probably more complicated... but ill give your suggestion a shot and see how it works.

Re: [chris] Multiple Check box list

Mon, 23 Nov 2009 09:11:03 -0800

perfecto!! thanks

Multiple Check box list

Thu, 19 Nov 2009 14:31:39 -0800

See below: 'category' is the name of my multiple checkbox list
Simulcast Racing is one of the list items. so in the code below, it will only display Promotions that have Simulcast selected.

My problem is, I need to select 2 options for a promotion. So for below I want it to display promotions with Simulcast Racing and Live Racing selected. how do I do this?

Re: [jonoc73] Multi Value Checkbox List Problem

Thu, 19 Nov 2009 13:36:04 -0800

i have a similar issue... how do I display if multiple items are checked off?

Re: [gkornbluth] Details Page no record found

Thu, 19 Nov 2009 11:05:24 -0800

I got it....sorry.

Now, just need help with the removing of the header text if there are no records in that section.

Heres how its set up.. http://runningaces.mriinteract.net/employment/

in the CMS I have a Employment listings where you can add new job listings... then you select which category it show show up in.

If there are no job listings in a certain category, I would like that category header to not display.

Heres how the listings are set up:

CARD ROOM

FACILITIES

FINANCE

FOOD & BEVERAGE

HUMAN RESOURCES

INFORMATION TECHNOLOGY

MARKETING

MUTUELS

RACING

SECURITY/SURVEILLANCE

Re: [gkornbluth] Details Page no record found

Thu, 19 Nov 2009 10:11:44 -0800

Did not work... still have the same issue..

let focus on the first issue.. then we figure out the second question i had.

ok lets try again..

http://runningaces.mriinteract.net/employment/index.php
This page lists all the job listings.. (page displays fine)

heres the header php code:

require_once "xxx";

list($ad_managerRecords, $ad_managerMetaData) = getRecords(array(
'tableName' => 'ad_manager',
'limit' => '2',
'orderBy' => 'RAND()',
'where' => " page_display LIKE '%\tAll\t%' ",
));

?>

require_once "xxx";

list($employment_pageRecords, $employment_pageMetaData) = getRecords(array(
'tableName' => 'employment_page',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$employment_pageRecord = @$employment_pageRecords[0]; // get first record

// show error message if no matching record is found
if (!$employment_pageRecord) {
print "Record not found!";
exit;
}

?>

require_once "xxx";

list($employment_listingsRecords, $employment_listingsMetaData) = getRecords(array(
'tableName' => 'employment_listings',
));

?>

Then when you click on a job listing... it should take you to the details page:
http://runningaces.mriinteract.net/employment/joblistings.php

this works fine: http://runningaces.mriinteract.net/employment/joblistings.php?HOUSEKEEPER-1

but any other job listing does not... i get the Record not found messages..

HEres the code on the details page:

require_once "xxx";

list($ad_managerRecords, $ad_managerMetaData) = getRecords(array(
'tableName' => 'ad_manager',
'limit' => '2',
'orderBy' => 'RAND()',
'where' => " page_display LIKE '%\tAll\t%' ",
));

?>

require_once "xxx";

list($employment_pageRecords, $employment_pageMetaData) = getRecords(array(
'tableName' => 'employment_page',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$employment_pageRecord = @$employment_pageRecords[0]; // get first record

// show error message if no matching record is found
if (!$employment_pageRecord) {
print "Record not found!";
exit;
}

?>

require_once "xxx";

list($employment_listingsRecords, $employment_listingsMetaData) = getRecords(array(
'tableName' => 'employment_listings',
'limit' => '1',
));
$employment_listingsRecord = @$employment_listingsRecords[0]; // get first record

// show error message if no matching record is found
if (!$employment_listingsRecord) {
print "Record not found!";
exit;
}

?>

can i send you files to review?
I think the conflict has to do with having multiple list records/single record on the same page.

Details Page no record found

Wed, 18 Nov 2009 16:35:09 -0800

I have a list page set up and when you click on an item in the list it should then link to the Details Page.

Only one list item is linking correctly, the other give me "No Record Found" message.

Im not sure if it is because on the details page, I have another multiple records list displaying.

HEres the code at the top of my detaisl page:

require_once "/XXXXXXX";

list($ad_managerRecords, $ad_managerMetaData) = getRecords(array(
'tableName' => 'ad_manager',
'limit' => '2',
'orderBy' => 'RAND()',
'where' => " page_display LIKE '%\tAll\t%' ",
));

?>

require_once "/XXXXXXX";

list($employment_pageRecords, $employment_pageMetaData) = getRecords(array(
'tableName' => 'employment_page',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$employment_pageRecord = @$employment_pageRecords[0]; // get first record

// show error message if no matching record is found
if (!$employment_pageRecord) {
print "Record not found!";
exit;
}

?>

require_once "/XXXXXXX";

list($employment_listingsRecords, $employment_listingsMetaData) = getRecords(array(
'tableName' => 'employment_listings',
'limit' => '1',
));
$employment_listingsRecord = @$employment_listingsRecords[0]; // get first record

// show error message if no matching record is found
if (!$employment_listingsRecord) {
print "Record not found!";
exit;
}

?>

The employment_listings is the record that is not displaying..
you can preview at: http://runningaces.mriinteract.net/employment/index.php
The Housekeeping works but not the others.

Also I would like to know if there is a way for the Job Category title not display if there are no records under that category.

I have set up just one multiple record manager in the CMS and when you enter a job listing, you select a category the listing goes under.

For if you look at the link above... I would like "Card Room, Finance etc" not display since there are no records under that category

THANKS IN ADVANCE!

*First Name:	*Last Name:

Card Number:
EMAIL SIGN-UP:
*Email Address:
YES! I would like to receive emails!
TEXT MESSAGING SIGN-UP:
*Mobile Phone Number (XXX-XXX-XXXX):
Cell Phone Carrier:
YES! I would like to receive text messages!