Hi Alex,
Assuming that I understood your situation I'll make this suggestion. I'm not sure
whether this option is supported in you PHP version but I think it'll be definitely
available after (and with) 5.0.
There are new function series called Sqlite (www.sqlite.org), an embded file based SQL
=== is a strict equals.
if you have a string $s = '12345' then
if(12345 == $s) is true
but
if(12345 === $s) is not true because 12345 is an int and '12345' is a string
-dave
Bruno Braga wrote:
Hi guys..
Wich is the diference between if ($var == '1') or if ($var === '1')
== means equalit
HI. I've been using mySQL 4.0.13, php4.3.4, and phpMyAdmin2.5.5 on Mac
OS 10.3.3 as a learning/testing/development environment for a couple of
months now - no problems, works great.
I've created more than a few mySQL databases and tables, but yesterday
I created a database, a table, and LOAD DA
Jeff, et al --
...and then [EMAIL PROTECTED] said...
%
% Hey David...
Hi again!
%
% Does this mean you are potentially brining back more then one row, and
% mysql_result doesn't know where to get it from? Does this change if you
% add, LIMIT 1 to the query.
In this case, we're absolutely su
> Warning: mysql_result(): Unable to jump to row 0 on MySQL result index
4...
> Now this makes some sense; the manual says that
> mysql_result ( resource result , int row )
> will jump to row $row in the output but says nothing about returning me a
> given fields.
> Any other thoughts?
H
Jeff, et al --
...and then [EMAIL PROTECTED] said...
%
[quoting me]
%
% >mysql_fetch_array() returns an array, and I know I want a field from just
% >this one row (not looping), could I just
% >
% > $i = mysql_fetch_array($r)[0] ;
%
% Hi David
% How about:
% $i = mysql_result(m
At 2004-05-12 14:11, Alex Gemmell wrote:
>Also, I heard that converting the .mdb file to a .dbf file might help but how do I
>connect to that with PHP? The PHP manual says this about dbase functions:
>These functions allow you to access records stored in dBase-format (dbf) databases.
>There i
You'd have to ask someone with more internals knowledge for that one...
I'm sure it does get GC'd, but I don't know if it happens in-script or
at the end. Also, I would assume it is freed when GC'd, but who knows, I
might be wrong. It's much safer to free it yourself.
paperCrane
David T-G wro
Sorry that. I was trying to be modular! I also understand that everyone is
busy and I highly appreciate any help.
Anyway I cleaned it up a bit I hope its clear now ( all I am trying to do is
to show a list of countries from my database and then according to the
selected country make another select
> Here is the complete code. In the one line Java script that I have I am
> setting the value. So what am I missing?
For the sake of the listers trying to help you, and for your own clarity
of concept, I'd suggest starting out by putting all your code into one
file. It's quite hard to follow as
Alex Gemmell wrote:
Yep - I could do that...
Or I could use this: http://www.cynergi.net/exportsql/
I haven't tried "exportsql" yet, it probably will fall over or be a
nightmare to get going knowing my current run of luck!
Let's all put our hands together and pray that it works (and for world pe
J. Alejandro Ceballos Z. wrote:
While calling a php with a parameter, the plus sign is interpreted as a
white space.
Is any solution to prevent this in the php page, not before calling it
or previously urlencoding?
No, it needs to be encoded if you're going to put it in the URL.
--
---John Holm
Yep - I could do that...
Or I could use this: http://www.cynergi.net/exportsql/
I haven't tried "exportsql" yet, it probably will fall over or be a
nightmare to get going knowing my current run of luck!
Let's all put our hands together and pray that it works (and for world peace
or something).
Alex, et al --
Sorry I'm late, and I hope that your upcoming mysql install works out
well for you.
Since you have the ability to convert this DB to something else (I was
going to ask but got busy and then this whole thread happenned :-) could
you also just dump it to a CSV file? That would be ea
Here is the complete code. In the one line Java script that I have I am
setting the value. So what am I missing?
Quicksearch.php file has the following code
Steps 1-4
In that case, you could write a PHP script on your PC (Windows right?)
that reads the data from the MDB file then posts the data to the MySQL
database. Sounds easy enough. Hah (that phrase has bitten me on the
backside more times than I can remember.. Challenges are fun though heh)
-Tg
> -O
Apologies if my situation isn't clear. My brain is noodle-soup after all
this!
I am given an updated copy of the MS Access database periodically. That
needs uploading to the website and a few pages use it to populate themselves
with relevant data.
Basically - username/password check to login. I
> Thanks so much but I am so new to all this so need more explanation
please.
> I think at this point I don't mind the round trip to the server side
till I
> find a better way. But for now I think I have what you are suggesting
but
> then why my "echo" is not retuning anything :
>
>
I think you'd have the same issue with Chilisoft ASP as you would with
PHP because the issue isn't with the scripting language but with the
OS's support for ODBC or DSNless connections to an Access database.I
did a little reading on Chilisoft ASP a while ago and (1) it's not free
from what I un
Thanks again Trevor and Bob!
The reason I was mentioning ASP is because "Chilli Soft! ASP" thingy (?) is
installed on the live (Linux/Apache) server. IIS doesn't come in to play
(other than on my localhost I was (stupidly) testing on!).
I have just got off the phone having managed to get the ser
Thanks so much but I am so new to all this so need more explanation please.
I think at this point I don't mind the round trip to the server side till I
find a better way. But for now I think I have what you are suggesting but
then why my "echo" is not retuning anything :
Good point Bob. If you're running IIS and can get PHP installed then
you can use the ADOdb or probably various other methods for accessing
the MDB files. No need to learn ASP then! That should speed up
development time a little at least.
So looks like the options are:
1. Get various database to
You'd have to take the value of the first select box in your form and pass
it to another script. You can do that by setting the form's ACTION property
to either GET or POST. Personally, I prefer POST.
In the script to which you submit your form, you can access the value of the
select object thusly
Hi Alex
ADODb will not work either. ADODb is basically a PHP abstraction class
library that relies on lower level database extensions to connect to the
various databases. The problem for you is that other than the odbc
extension combined with MDBTools, and the odbtp extension, there is no
other
Yeah, go ahead and steal the connection strings, that's why I posted
them :)
Also check out:
http://www.connectionstrings.com/
http://www.afn.org/~afn45181/Ben/SPSS/Merant/merant/client/win32/program
%20files/SPSSOEM/ODBC42/help/wwhelp/wwhimpl/common/html/wwhelp.htm?conte
xt=ODBC&file=Rdbasfox6.h
Well I am suing Java script to capture the selected item and make it the
value of my input box. But my problem is how to access this information from
this point on. Can someone please tell me how I can use the selected item in
my next SQL query?
-Original Message-
From: Tony S. Wu [mailto:
Hello
We currently run mysql 4.0.14 in MyISAM table format.
Server config :
Dual P-3 600
1GB of ECC SDRAM
6 SCSI drives 10,000 RPM using RAID 5 Array.
OS :
RedHat Linux 9.
We just realized we really need the adnvaned futures of InnoDB or MaxDB/SAP DB.
What would it takes (System preformance, co
sounds like a job for JavaScript.
Tony S. Wu
[EMAIL PROTECTED]
"Look into the right places, you can find some good offerings."
http://homepage.mac.com/tonyswu/stw- The perfect business.
http://homepage.mac.com/tonyswu/tonyswu- My web page.
--
Thanks Peter,
A very kind offer, but I'm tied to my hosts and to using MS Access. I have
been using PHP throughout the website but could possibly use ASP for this
very small part of the site (i.e. display a record of 20 fields depending on
who logins in). I need to learn ASP however and I don't
Thanks Bob,
I was afraid of that! Ah well. I have one or two more glimmers of hope
left before I abandon this entirely and learn some ASP super-quickly!
Alex
|:| Reply-to: [EMAIL PROTECTED] |:|
|-Original Message-
|From: Robert Twitty [mailto:[EMAIL PROTECTED]
|Sent: 12 May 2004 14:54
Thank you Trevor!
Funny you should mention ADOdb. I just d/l it and uploaded it to my web
site! I am working through the docs now. I was losing hope because I
couldn't find what I was looking for but if you don't mind I will help
myself to your connection string:
case "OtherDB":
# Sample
First, I don't think you are likely to use COM calls on a linux box
since COM and DCOM are MS things aren't they? Even if not, it might
require some configuration on the server end which you can't do.
I use the ADOdb database library for PHP in all the things I do:
http://php.weblogs.com/adodb
Hello,
I am very new to php and mysql so please be patient with me. I don't even
know if I am using the right listing, but I hope someone can help me!
I need to create a and the possible options are from my mysql
database ( so far so good, I was able to find code to do that).
Now I need t
On Wed, 12 May 2004, Alex Gemmell wrote:
> Hello all,
>
> I am fairly new to Linux/PHP so please bear with me. I have an awfully
> awkward problem to solve - a stop gap solution for the next 6 months until
> we have out in-house servers set up and running. I also have a very short
> timeframe to
|-Original Message-
|From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
|Sent: 12 May 2004 13:43
|To: Alex Gemmell
|Cc: PHP List
|Subject: Re: [PHP-DB] Linux/PHP/Access Database - oh boy :(
|
|
|>Hello all,
|
|>Am I right in thinking I have very few options? I don't want to move
|over to
>Hello all,
>Am I right in thinking I have very few options? I don't want to move
over to ASP (would that even help?) because it means learning VBScript and
I don't have a >lot of time. Also, I can't use another database (e.g.
MySQL) cos the server admin is NOT helping me and won't install
Hello all,
I am fairly new to Linux/PHP so please bear with me. I have an awfully awkward problem to solve
– a stop gap solution for the next 6 months until we have out in-house
servers set up and running. I also
have a very short timeframe to sort this out. I am using PHP on a remot
Hi all
thanx for the suggestions! yah, now i give my customers 2 buttons that will
direct them to 2 functionalities.
however, I still have a problem!! =(
i'm using 2 headers:
header("Content-type: application/vnd-ms.word");
header("Content-Disposition: attachment; filename=agent.doc");
Justin, et al --
...and then Justin Patrin said...
%
% David T-G wrote:
%
% >...and then Justin Patrin said...
% >%
...
% >% Of course, this leaves the result handle open. It's best to store the
% >% result handle and free it with mysql_free_result().
% >
% >Makes sense. I actually hadn't th
Hi:
I want to make a php install package on Win32 contain my php.ini
and auto add .php file map to IIS5.0,but i don't know where the IIS
file map is stored,i searched 'php' in registry and all ini file in
system dir,but no result returned.
who know the key?
Best Regards
beforefly
[EM
40 matches
Mail list logo
