Page 1 of 1
Why Dosent this script work
Posted: Tue Apr 03, 2007 7:03 am
by ojsimon
feyd | Please use Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
when i open this script it just shows a blank page, what is wrong, the aim of the script is to put the search criteria into a variable.
Code: Select all
<?php
if(isset($_POST['findThis'])){
# find exact match:
$sql = "SELECT * FROM `myTable` WHERE `colName`='" . $_POST['searchVar'] . "'";
# OR find similar match:
$sql = "SELECT * FROM `myTable` WHERE `colName` LIKE '%" . $_POST['searchVar'] . "%'";
$query = mysql_query($sql,$resource);
while($row = mysql_fetch_assoc($query)){
print_r($row);
}
}
?>
feyd | Please use Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
Posted: Tue Apr 03, 2007 7:08 am
by mentor
Does $_POST['findThis'] has some value?
Make sure $resource is a valid MySQL connection link. Use mysql_query() like this
Code: Select all
$query = mysql_query($sql,$resource) or die(mysql_error());
Posted: Tue Apr 03, 2007 7:11 am
by ojsimon
Sorry i am quite new to php what value are you talking about, where o i put this value in the ""
Thanks
Posted: Tue Apr 03, 2007 7:12 am
by mentor
Posted: Tue Apr 03, 2007 7:17 am
by ojsimon
Sorry this is confusing me would it be easier to do a html form and set to variable like
<form action="myPage.php" method="post">
<input type="text" name="searchVar">
<input type="submit" name="findThis">
</form>
would i be able to use the variable in php
Thanks
Posted: Tue Apr 03, 2007 7:19 am
by mentor
Did you try
Code: Select all
$query = mysql_query($sql,$resource) or die(mysql_error());
Posted: Tue Apr 03, 2007 7:37 am
by feyd
Run the following in a new file and tell us the results please.
Code: Select all
<?php
$neg = array('off', 0, false, '', null);
$flags = array(
'Register Globals' => 'register_globals',
'Short Tags' => 'short_open_tag',
'Display Errors' => 'display_errors',
'Magic Quotes GPC' => 'magic_quotes_gpc',
'Magic Quotes Runtime' => 'magic_quotes_runtime',
'Magic Quotes Sybase' => 'magic_quotes_sybase',
);
$ve = phpversion();
$os = PHP_OS;
$er = intval(error_reporting());
foreach ($flags as $n => $v)
{
$flags[$n] = (in_array(strtolower(ini_get($v)), $neg) ? 'Off' : 'On');
}
$flags['Config file'] = get_cfg_var('cfg_file_path');
if (empty($flags['Config file']))
{
$flags['Config file'] = '-';
}
$cli = (php_sapi_name() == 'cli');
$eol = "\n";
$gle = get_loaded_extensions();
$rows = array();
$le = '';
$wide = 4;
$j = count($gle);
$pad = $wide - $j % $wide;
$len = max(array_map('strlen', $gle));
$func = create_function('$a', 'return str_pad($a, ' . intval($len) . ');');
$gle = array_map($func, $gle);
for($i = 0; $i < $j; $i += $wide)
{
$le .= ' ' . implode(' ', array_slice($gle, $i, $wide)) . $eol;
}
$ec = array(
'E_STRICT' => 2048, 'E_ALL' => 2047, 'E_USER_NOTICE' => 1024,
'E_USER_WARNING' => 512, 'E_USER_ERROR' => 256, 'E_COMPILE_WARNING' => 128,
'E_COMPILE_ERROR' => 64, 'E_CORE_WARNING' => 32, 'E_CORE_ERROR' => 16,
'E_NOTICE' => 8, 'E_PARSE' => 4, 'E_WARNING' => 2, 'E_ERROR' => 1,
);
$e = array();
$t = $er;
foreach ($ec as $n => $v)
{
if (($t & $v) == $v)
{
$e[] = $n;
$t ^= $v;
}
}
if (ceil(count($ec) / 2) + 1 < count($e))
{
$e2 = array();
foreach ($ec as $n => $v)
{
if (!in_array($n, $e) and $n != 'E_ALL')
{
$e2[] = $n;
}
}
$er = $er . ' ((E_ALL | E_STRICT) ^ ' . implode(' ^ ', $e2) . '))';
}
else
{
$er = $er . ' (' . implode(' | ', $e) . ')';
}
if (!$cli)
{
echo '<html><head><title>quick info</title></head><body><pre>', $eol;
}
echo 'PHP Version: ', $ve, $eol;
echo 'PHP OS: ', $os, $eol;
echo 'Error Reporting: ', $er, $eol;
foreach ($flags as $n => $v)
{
echo $n, ': ', $v, $eol;
}
echo 'Loaded Extensions:', $eol, $le, $eol;
if (!$cli)
{
echo '</pre></body></html>', $eol;
}
?>
Posted: Tue Apr 03, 2007 7:45 am
by ojsimon
This gave me a blank screen again.
thanks
Posted: Tue Apr 03, 2007 8:07 am
by feyd
The script I posted gives you a blank screen? I highly doubt that unless you didn't follow the instructions.
This is what was returned when i tried again
Posted: Tue Apr 03, 2007 9:00 am
by ojsimon
<html><head><title>quick info</title></head><body><pre>
PHP Version: 5.2.0
PHP OS: Darwin
Error Reporting: 6135 ((E_ALL | E_STRICT) ^ E_STRICT ^ E_NOTICE))
Register Globals: Off
Short Tags: On
Display Errors: On
Magic Quotes GPC: On
Magic Quotes Runtime: Off
Magic Quotes Sybase: Off
Config file: /Applications/Zend/ZendStudio-5.5.0/bin/php5/php.ini
Loaded Extensions:
xmlwriter libxml dom xmlreader
xml tokenizer session SimpleXML
SPL PDO SQLite standard
Reflection posix pdo_sqlite mysql
json iconv hash filter
date ctype zlib pcre
Zend Debugger
</pre></body></html>
Posted: Tue Apr 03, 2007 9:24 am
by feyd
Edit the ini file located at /Applications/Zend/ZendStudio-5.5.0/bin/php5/php.ini. Set error_reporting to E_ALL and short_open_tag to Off.