https://interactivetools.com/forum/forum-search.php?k=user%3Ajsammann Thu, 21 May 2026 18:34:54 -0700 en-us Prevent submitting empty form https://interactivetools.com/forum/forum-posts.php?postNum=2234731#post2234731 I have searched the forums but am not able to find what I believe to be a simple task. I have created a basic search form that looks for 3 fields; last name, item number and zip code. It works great until you just hit submit without entering anything into the fields, it then returns everything in the database. Is there a way to prevent this? I'm sure there is I just don't seem to know what to search for. Thanks in advance.

]]> Wed, 13 Aug 2014 18:44:43 -0700 forum-posts.php?postNum=2234731#post2234731 Simple Search (maybe?) https://interactivetools.com/forum/forum-posts.php?postNum=2234170#post2234170 <form method="POST" action="/includes/cloud.php">
<input type="text" name="keywords_keyword" value="">
<input type="submit" name="submit" value="Search">
</form>

I think I'm attempting a simple search above is my search.php page

Below is my cloud.php page

All I want to do is search a field in my table called key words, the field contains multiple strings separated by commas (math 101,English Comp,Biology Lab) I would like the search to return the names of people in the respective class. What am I doing wrong?

Thanks,

James

<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
/* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */

// load viewer library
$libraryPath = 'cmsAdmin/lib/viewer_functions.php';
$dirsToCheck = array('/home/localmls/public_html/','','../','../../','../../../');
foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

// load records from 'sullivan_county'
list($sullivan_countyRecords, $sullivan_countyMetaData) = getRecords(array(
'tableName' => 'sullivan_county',
'orderBy' => 'RAND()',
'loadUploads' => false,
'allowSearch' => true,
));

?><!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>
<title></title>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
<style type="text/css">

/* mouse over link */
a:hover {
text-decoration: underline;
}
div {
text-align:justify;
}

</style>

</head>
<body>

<!-- STEP2: Display Records (Paste this where you want your records to be listed) -->
<div>
<?php foreach ($sullivan_countyRecords as $record): ?>

<a href="<?php echo htmlencode($record['cloud_url']) ?>"style="color:<?php echo $record['color'] ?>;font-size:<?php echo $record['size'] ?>;background-color:<?php echo $record['bg_color'] ?>;" target="_blank"><?php echo htmlencode($record['cloud_title']) ?></a>&nbsp;&nbsp;&nbsp;

<?php endforeach ?>
</div>
<?php if (!$sullivan_countyRecords): ?>
No records were found!<br/><br/>
<?php endif ?>

<!-- /STEP2: Display Records -->

</body>
</html>

]]> Tue, 10 Jun 2014 12:57:00 -0700 forum-posts.php?postNum=2234170#post2234170 Field Checkbox (Multi-Value) Question. https://interactivetools.com/forum/forum-posts.php?postNum=2232429#post2232429 That worked perfectly! Thank you.

]]> Mon, 18 Nov 2013 15:56:56 -0800 forum-posts.php?postNum=2232429#post2232429 Field Checkbox (Multi-Value) Question. https://interactivetools.com/forum/forum-posts.php?postNum=2232415#post2232415 Hi, I have a question reguarding writing a select for the checkbox (mulit Value) 

I wanted to limit the select to records in another table to those that they created.  Here is my query so far:     SELECT website FROM cms_websites WHERE createdByUserNum = (Need to know what to put here) 

]]> Mon, 18 Nov 2013 06:28:04 -0800 forum-posts.php?postNum=2232415#post2232415