In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
wrote:
> $search = "TheName"
> $data = "TheName,TheAddress,ThePhone"
>
> if (preg_match('"/\b'.$search.'\b/i"', $data))
> {
> echo "True";
> }
> else
> {
> echo "False";
> }
> I am trying to see if the search name matches exactly a name in the
Hello,
I have Interbase 5.5 running on NT box, and the goal is to access it from
Apache/PHP on Linux box.
The following code is quite trivial, but in my case it doesn't work. I found
many similar posts searching Internet on that, but did not find an answer.
All it gives is "Warning: InterBase
How do you loop through all the text objects in a PHP script? In otherwords, I want
use logic to check the value of each textbox without specifically referencing the
actual object name. Visual Basic has this type of logic.
Hi,
To be honest I don't know if PHP will work with version 5.x of Informix. I
think it must be 7.x. At least that's for the SE version.
In case I'm wrong for On-Line you can have a go but you'll have to specify
the libs manually when compiling Apache.
If you run esql -libs this will list the l
I'm trying to build a search query that will allow users to search (via a
textbox) different tables.
For example, I have a table name contacts with columns ContactID, FirstName,
LastName, and Active. I want to be able to search for John Smith or Smith
where Active=yes (as opposed to Active=no whi
You'll need three pages:
in the first one put
submit it to the second page where you have:
$sql = "select * from contacts where (FirstName like '%$contactname%' or
LastName like '%$contactname%') and Active='yes' order by ID";
$result = mysql_query($sql);
$numrows = mysql_num_rows(
Hallo!
Maybe you can help me with my problems.
I have a html form that deletes (or updates) over a php-script datas from my
database like "delete from table_name where id=xy"
and it works correctly.
But when I have about 100 entries in my database then it takes about 50 sec.
to delete an entry
How many rows are in the table? Is the "id" column indexed? It looks like
it's scanning through each row to find a match. How long does it take to
delete just the one row? If it's 2 seconds, then that delete is acting the
same way.
If you have a very small table, then it sounds like the datab
On Thursday, July 26, 2001 at 9:48 PM, Sommai Fongnamthip said:
> I have oracle 8i in Linux server. How could I
> connect it with PHP (on other server)?
Install the Oracle Client software (on the other server).
---
Brian S. Dunworth
Sr. Software Dev
Its a mySQL DB at a providers Server, so I think the memory and the cache
schould be okay.
Mybe this helps: The HTML File look like this:
Do really want to delete this entry
and the function in the admin_index.php3 looks like this
function delete_entry($svid)
{
$connectionID
It sounds like your 'id' column does not have an index.
Jeff
Uli wrote:
> Hallo!
>
> Maybe you can help me with my problems.
>
> I have a html form that deletes (or updates) over a php-script datas from
> my database like "delete from table_name where id=xy"
>
> and it works correctly.
>
>
Use $dbh = ibase_connect ("database", "user", "password", "ISO8859_1",
0, 1);
The extra arguments are needed for any interbase < 6.0
--
Jeremy Bettis
[EMAIL PROTECTED]
"Maxim Pavlov" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hello,
>
> I have Interbas
I need to pull oracle blobs out of the database and write them to the file
system (Solaris).
Has anyone had any success doing this?
Tom
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact th
I have had no success finding a thread on the subject of how to test results of a
query.
I know it can be positive without finding any rows.
What are the ways to test.
Dave
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-ma
Dave.
Is this what you mean? In the example below, you won't fall into the while
loop unless you get a row back from the statement handle ($sth).
$dbh = ibase_connect( $connect, $this->login, $this->passwd )
$sth = ibase_query( $sql, $dbh );
while ( $row = ibase_fetch_row ( $sth ) )
{
OK, I set my LIBS environment variable to my esql -libs result and the
confire shell is OK now, but now I get the next error when running the make
command :
# make
===> src
make[1]: Entering directory `/tmp/apache_1.3.20'
make[2]: Entering directory `/tmp/apache_1.3.20/src'
===> src/os/unix
>
> At 10:02 AM 7/26/01 +0700, Sommai Fongnamthip wrote:
> >Hi,
> > When I retrieve data to display on web with PHP, it can print out
> > from web in Browser Stlye. How could we have some PHP code to retrieve
> > current display data into PC and print it with some Custom Report Style?
>
Use PHP's mail() function to send it to your customer, store in a directory
from they can FTP it.
Miles
At 08:45 AM 7/27/01 +0700, Sommai Fongnamthip wrote:
>OK. How do I operate when finished generate text file or report file in
>server? Could I download it and to view / print from client r
I seem to be having difficulty creating a hypertext link between the results
of a sql query, ie a a formated page with a contact record (FirstName,
LastName, etc.) to a page that will allow for editing. The results page is
text only and the edit/update page has text boxes.
Not sure if this clear,
I am still trying to figure out how to do it. I want to display my result
from the data base in tree/menu like system.
So the result page will look like this:
+Result1 (you click this , it will expand)
-Item1 (you click this and get more info)
-Item2
-Item3
+Result2
This is not VB - this is better. Probably want to name all of your text
fields something
similar, since they'll be mixed in with the drop downs, radio buttons,
etc...
Check $HTTP_POST_VARS and $HTTP_GET_VARS in your form's target.
-Szii
- Original Message -
From: "Peter J. Krawetzky"
I´m using PHP 4 with ODBC and sometimes I get a response that was unable
to connect to the MSSQL database. Then I go to the ODBC configuration to
test the connection and I get a response that everything is working fine,
but my pages still can´t connect. Is that normal? What can I do?
I´m using N
"Sharif Islam" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
> I am still trying to figure out how to do it. I want to display my result
> from the data base in tree/menu like system.
Could you give us your SELECT statement and one row of returned data?
>
> "Peter J. Krawetzky" <[EMAIL PROTECTED]> wrote in
> message 001001c11697$fe331d40$[EMAIL PROTECTED]">news:001001c11697$fe331d40$[EMAIL PROTECTED]...
> How do you loop through all the text objects in a PHP script? In
otherwords,
> I want use logic to check the value of each textbox without spec
IF I click this submit button:
then (isset($submit_key) ) is TRUE
IF i press my ENTER button instead of click it
then (isset($submit_key) ) is FALSE..
is this normal behavior?
Ken
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For addition
are INSERT INTO statements forbiden inside a function??
Dave
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
> Now then, I have changed a column in the table, and the only way I found to
> change a data type is to delete the offending column and then add it again.
>
> When I do the select now the new column, which was at $row[3] is now always
> $row[39]. I don't mind this, because I know where it is, bu
27 matches
Mail list logo