09-12-2012
MySQL LIKE code not working in safari browser
I am looking for database
PHP Code:
SELECT * FROM table_name WHERE event LIKE '%" . $search . "%' OR date LIKE '%”. $search . "%'
This works fine in Firefox and in IE, but when i try it in safari, it seems to pull up the right results but then straight away changes and gives me all the results from the table. I am sure it has soomething to do with the LIKE operator because when i tried
This script works fine in Firefox and in Chrom, but when i try it in safari browser, it seems to pull up the right results but then as the crow flies away changes and gives me all the results from the table.
I am sure it has something to do with the LIKE coad because when i tried
SELECT * FROM table_name WHERE date = (the date i was trying to search for)
Kindly provide me solutions
Thanks in advance
7 More Discussions You Might Find Interesting
1. UNIX and Linux Applications
Hi,
I'm new to mysql, I've installed MYSQL on our unix server and started MYSQL on this server.
I've now downloaded MYSQL Query Browser, when I try to connect to MYSQL server, I get the following error "could not connect to the specified instance" - MySQL Error Number 1130.
From the... (3 Replies)
Discussion started by: venhart
3 Replies
2. Red Hat
All
I just loaded RH Enterprise Linux 5 and the installation went smoothly. I am behind a DSL router and I can ping/ssh/telnet to machines on my local network as well as machines at remote sites. DNS seems to be working. but the browser and IM (AIM) cannot connect and time out.
Any insight... (1 Reply)
Discussion started by: razor3928
1 Replies
3. UNIX and Linux Applications
Hi there, I have a query that works just fine, but im having a little problem understanding how it works and have been struggling to find any docs that explain the techniques that are being used. If anybody out there could explain how this is put together then that would be great
I have three... (1 Reply)
Discussion started by: rethink
1 Replies
4. UNIX and Linux Applications
Need a help Schema browser in Toad not listing the tables when i connected to Oracle 11g schema
did any body faced the issue... ? How to resolve the issue (0 Replies)
Discussion started by: girija
0 Replies
5. Linux
Hi All,
My chrome browser was working correctly on my Debian Lenny 5 PC..Today i downloaded the version from google and tried to install the deb from command line as follows:
dpkg -i <latest-chrome-package>
The installation failed but now my existing old chrome browser is not starting.
... (2 Replies)
Discussion started by: coolatt
2 Replies
6. AIX
Hello,
We enabled X11 and xming is riunning. we used to open firefox window using below command on AIX.
/usr/bin/firefox
Xclock is working fine now. But for some reason firefox stopped working on one of our AIX LPAR. Can you please look in to below error.
/>/usr/bin/firefox... (5 Replies)
Discussion started by: aaron8667
5 Replies
7. Shell Programming and Scripting
Hi Team,
I have created attached script in mysql environment. But there is below error .
can you please suggest .
Error : Unknown table 'processlist' in finformation_schema
#!/bin/bash
mysql -u $DBUSER -p$DBPASS -e "
select
-- *
id
from information_schema.processlist
where... (1 Reply)
Discussion started by: Jewel
1 Replies
LEARN ABOUT PHP
get_browser
GET_BROWSER(3) 1 GET_BROWSER(3)
get_browser - Tells what the user's browser is capable of
SYNOPSIS
mixed get_browser ([string $user_agent], [bool $return_array = false])
DESCRIPTION
Attempts to determine the capabilities of the user's browser, by looking up the browser's information in the browscap.ini file.
PARAMETERS
o $user_agent
- The User Agent to be analyzed. By default, the value of HTTP User-Agent header is used; however, you can alter this (i.e., look
up another browser's info) by passing this parameter. You can bypass this parameter with a NULL value.
o $return_array
- If set to TRUE, this function will return an array instead of an object.
RETURN VALUES
The information is returned in an object or an array which will contain various data elements representing, for instance, the browser's
major and minor version numbers and ID string; TRUE/ FALSE values for features such as frames, JavaScript, and cookies; and so forth.
The cookies value simply means that the browser itself is capable of accepting cookies and does not mean the user has enabled the browser
to accept cookies or not. The only way to test if cookies are accepted is to set one with setcookie(3), reload, and check for the value.
CHANGELOG
+--------+--------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+--------------------------------------------------+
| 4.3.2 | |
| | |
| | The optional parameter $return_array was added. |
| | |
+--------+--------------------------------------------------+
EXAMPLES
Example #1
Listing all information about the users browser
<?php
echo $_SERVER['HTTP_USER_AGENT'] . "
";
$browser = get_browser(null, true);
print_r($browser);
?>
The above example will output something similar to:
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7) Gecko/20040803 Firefox/0.9.3
Array
(
[browser_name_regex] => ^mozilla/5.0 (windows; .; windows nt 5.1; .*rv:.*) gecko/.* firefox/0.9.*$
[browser_name_pattern] => Mozilla/5.0 (Windows; ?; Windows NT 5.1; *rv:*) Gecko/* Firefox/0.9*
[parent] => Firefox 0.9
[platform] => WinXP
[browser] => Firefox
[version] => 0.9
[majorver] => 0
[minorver] => 9
[cssversion] => 2
[frames] => 1
[iframes] => 1
[tables] => 1
[cookies] => 1
[backgroundsounds] =>
[vbscript] =>
[javascript] => 1
[javaapplets] => 1
[activexcontrols] =>
[cdf] =>
[aol] =>
[beta] => 1
[win16] =>
[crawler] =>
[stripper] =>
[wap] =>
[netclr] =>
)
NOTES
Note
In order for this to work, your browscap configuration setting in php.ini must point to the correct location of the browscap.ini
file on your system.
browscap.ini is not bundled with PHP, but you may find an up-to-date php_browscap.ini file here.
While browscap.ini contains information on many browsers, it relies on user updates to keep the database current. The format of the
file is fairly self-explanatory.
PHP Documentation Group GET_BROWSER(3)