posting data to the db publically...?
15 posts by 4 authors in: Forums > CMS Builder
Last Post: March 31, 2009 (RSS)
By HDLLC - March 11, 2009
First part:
Can I put a CMS Builder install up, and allow users (public - without un and pw) enter data into a question/answer form.
I then want to set up a protected page where me, as admin, can search through those fields to match criteria against their answers (sell product).
Is this possible...?
Second part: (different site)
Can CMS Builder be used to create a classifieds system that allows folks to post items for sale - kind of a self-service For Sale By Owner?
Is there a way to charge for that service easily through paypal or something? (ie: pay $10 for account access to post an item for sale).
Thanks in advance!
--Jeff
Re: [HDLLC] posting data to the db publically...?
By Dave - March 11, 2009
Yes, that's all possible. With some of it requiring some custom programming.
For the first part, I've added a sample "Add Form" that will allow users to add data to the CMS Builder databases. This would make a good starting point for what you need.
See what you can do with that and let me know if you have any more questions. Also, we have consulting services available if you want a quote on some custom programming.
Hope that helps!
interactivetools.com
Re: [Dave] posting data to the db publically...?
By HDLLC - March 11, 2009
Much appreciated - I'll use this to get started on just having a visitor add a record, in this case - a request for a specific item. That way, the site admin can search for those looking for something like that once it comes in - kind of like someone searching for a specific car. Let's them search for their visitors looking to buy something like that when it arrives.
Question though - how do I go about mapping this to a specific field I create in the database (using the CMS admin)...?
<textarea name="content" cols="30" rows="4"><?php echo htmlspecialchars(@$_REQUEST['content']) ?></textarea>Alter the ['content'] portion to reflect the field I am referencing?
Thanks!
--Jeff
Re: [Dave] posting data to the db publically...?
By HDLLC - March 11, 2009
Make sense?
Thanks!
--Jeff
Re: [HDLLC] posting data to the db publically...?
By Dave - March 11, 2009
>Alter the ['content'] portion to reflect the field I am referencing?
Yes, that's exactly it.
And for the classified system, I had a sample "user signup" form I can give you. It will need some minor modifications just as the other script, though.
Let me know if you want that.
interactivetools.com
Re: [Dave] posting data to the db publically...?
By HDLLC - March 11, 2009
Thanks a million!
Bring it on! Would love to have that too!
Thanks!
--Jeff
Re: [HDLLC] posting data to the db publically...?
By Dave - March 11, 2009
And if you get an error that mysql_select_count_from () is missing add this to the bottom of /lib/database_functions.php
//
function mysql_select_count_from($tableName, $whereClause = '') {
if (!$tableName) { die(__FUNCTION__ . ": No tableName specified!"); }
$tableNameWithPrefix = getTableNameWithPrefix($tableName);
$escapedTableName = mysql_real_escape_string( $tableNameWithPrefix );
if ($whereClause != '') { $whereClause = "WHERE $whereClause"; }
$query = "SELECT COUNT(*) FROM $escapedTableName $whereClause";
$result = @mysql_query($query) or die(__FUNCTION__ . "() MySQL Error: ". htmlspecialchars(mysql_error()) . "\n");
list($recordCount) = mysql_fetch_row($result);
if (is_resource($result)) { mysql_free_result($result); }
//
return $recordCount;
}Let me know if that works for you.
interactivetools.com
Re: [Dave] posting data to the db publically...?
By s2smedia - March 30, 2009
I keep getting a fatal error.. Here is just a test i was trying to get it to work with:
<?php
require_once "admin/lib/init.php";
// submit form
if (@$_REQUEST['submit']) {
// error checking
$errorsAndAlerts = "";
if (!@$_REQUEST['title']) { $errorsAndAlerts .= "Please specify title!<br/>\n"; }
if (!@$_REQUEST['content']) { $errorsAndAlerts .= "Please specify content!<br/>\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}client_list` SET
title = '".mysql_real_escape_string( $_REQUEST['contact_name'] )."',
content = '".mysql_real_escape_string( $_REQUEST['company_name'] )."',
createdDate = NOW(),
updatedDate = NOW(),
createdByUserNum = '0',
updatedByUserNum = '0'")
or die("MySQL Error Creating Record:<br/>\n". htmlspecialchars(mysql_error()) . "\n");
$recordNum = mysql_insert_id();
// display thanks message and clear form
$errorsAndAlerts = "Thanks, we've added that record!";
$_REQUEST = array();
}
}
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
<style type="text/css">
body, td { font-family: arial }
</style>
</head>
<body>
<form method="post" action="">
<input type="hidden" name="submit" value="1" />
<h1>Sample Record Add Form</h1>
<?php if (@$errorsAndAlerts): ?>
<div style="color: red; font-weight: bold; font-size: 16px;"><br/>
<?php echo $errorsAndAlerts; ?><br/><br/>
</div>
<?php endif ?>
<table border="0" cellspacing="0" cellpadding="2">
<tr>
<td valign="top">Title</td>
<td><input type="text" name="title" value="<?php echo htmlspecialchars(@$_REQUEST['contact_name']) ?>" size="30" /></td>
</tr>
<tr>
<td valign="top">Content</td>
<td><textarea name="content" cols="30" rows="4"><?php echo htmlspecialchars(@$_REQUEST['company_name']) ?></textarea></td>
</tr>
</table><br/><br/>
<input type="submit" name="add" value="Add Record >>" />
</form>
</body>
</html>
Re: [s2smedia] posting data to the db publically...?
By Dave - March 30, 2009
interactivetools.com
Re: [Dave] posting data to the db publically...?
By s2smedia - March 30, 2009