[PHP-DB] Urent please

2002-07-08 Thread its me
maybe this is more a javescripy problem...but its related to my php code: how can i open a new window with javacript and pass to it php variables?? thanks guys alot. Rehab M.Shouman

RE: [PHP-DB] Urent please

2002-07-08 Thread Beau Lebens
how about when u open the new window (using something like window.open(...)) you make it open a URL something like foobar.php?var1=foo and then on that page (foobar.php) you can grab the value of $var1 as foo HTH Beau // -Original Message- // From: its me [mailto:[EMAIL PROTECTED]] //

Re: [PHP-DB] template problem!!!

2002-07-08 Thread Marcel Schindler
Hi Just enclose it in ?php ? You can do this in either templates or html pages Yeah, but this is against the template-system. Of course, this is possible but templates are usually for seperating the code from the design -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

[PHP-DB] Input Filtering

2002-07-08 Thread Jefferson Cowart
I realize that I need to do some filtering on user input (variables from POSTs or GETs) to prevent errors and security breaches. Has any one written a function to do this. As it is I realize I need to addslashes on anything going into a DB and worry about semi-colons to prevent SQL injection

[PHP-DB] Form select field problem

2002-07-08 Thread Keiran Wynyard
Hi I may be posting this to the wrong place, and if so I apologise. If someone knows of a better place to post my query please tell me, and I will. :) This problem is about 50% PHP and 50% Javascript, really to do with how the two interface with each other. Anyhoo, down to the problem. I

[PHP-DB] Re: Urent please

2002-07-08 Thread Adam Royle
Simply open the javascript window with a querystring.. so you have some like this in your javascript code: window.open(somepage.php?var1=value1var2=value2,theWindow,width=200, height=300); and if the variables are inside php... use something like this: window.open(somepage.php?var1=?= var1

[PHP-DB] PDF

2002-07-08 Thread Natividad Castro
Hi to all, How can I display info in a PDF? All I need is to be able to read from a table and display fields into a PDF. Before, I had my DB in Microsoft Access, so I bounded all the fields in a report and then I converted it into PDF document. But now that we switch to MySQL, I don't know how to

Re: [PHP-DB] PDF

2002-07-08 Thread Egil Helland
On Monday, July 8, 2002, at 06:50 PM, Natividad Castro wrote: Hi to all, How can I display info in a PDF? All I need is to be able to read from a table and display fields into a PDF. Before, I had my DB in Microsoft Access, so I bounded all the fields in a report and then I converted it

[PHP-DB] Checking for a successful login and setting a global flag.

2002-07-08 Thread Youngie
Hi Follks I'm writing an application that requires the user to login to gain access to the rest of the site. The login dailog is on index.html, once verified by login.php the user is presented with a menu from which he can select several options option1.htm which executes a query through

Re: [PHP-DB] Checking for a successful login and setting aglobal flag.

2002-07-08 Thread Martin Clifford
I have my page set up to use sessions to track the users on my page. The best way I have found is to give each user a user level to identify what areas they should or should not be in. For example, if you have a page that edits the news content on your site, you might set it up like this:

Re: [PHP-DB] Checking for a successful login and setting aglobal flag.

2002-07-08 Thread Youngie
Hi Martin, I have a similar kind of setup with user level, stored as a session variable. Problem is that when the a user with level one access uses a machine to open the browser it writes level one to the session data, the next user going straight to the query.htm screen without logging on also

[PHP-DB] passing variables from one page to another

2002-07-08 Thread Matthew K. Gold
Hi Everybody, Please forgive the basic nature of this question--I have looked at the manual, but I found that much of it went over my head. I'm trying to create a second level of a website that displays course listings. The first level lists a bunch of courses. I'd like users to be able to

Re: [PHP-DB] passing variables from one page to another

2002-07-08 Thread Martin Clifford
If that is your exact code, then you need to have an ending quote after the query is written. Like this: $query = Select * from course, disc, instit, prof where course.CourseID = $CourseID and course.DiscID = disc.DiscID and course.InstitID = instit.InstitID and course.ProfID = prof.ProfID;

Re: [PHP-DB] passing variables from one page to another

2002-07-08 Thread Matthew K. Gold
You're right--I did leave out that end quotation mark. Unfortunately, though, I'm still getting the same result after adding it. best, Matt - Original Message - From: Martin Clifford [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 08, 2002 3:47 PM

Re: [PHP-DB] passing variables from one page to another

2002-07-08 Thread Daniel Brunner
Hello!! How are you fetching the rows??? mysql_fetch_rows?? or mysql_fetch_object??? Dan On Monday, July 8, 2002, at 02:52 PM, [EMAIL PROTECTED] wrote: You're right--I did leave out that end quotation mark. Unfortunately, though, I'm still getting the same result after adding it. best,

[PHP-DB] Re: PDF

2002-07-08 Thread Dan Koken
One big question.. Do you have a compelling reason, or company policy to use PDF? Why not just display your data in a html table grid. Sounds like what you are trying to do will work find here. It's faster, simple, and avoids another level of overhead (complexity). Just wondering ... and

Re: [PHP-DB] passing variables from one page to another

2002-07-08 Thread Matthew K. Gold
ummm:).I'm now using fetch_rows, though I wasn't using anything before. Still, it's not working. Here's the new script (thanks again for your help): ?php $db = @mysql_connect(host,user,pword); mysql_select_db(dln, $db); if ( !$CourseID ) { print (no course id included) exit };

RE: [PHP-DB] passing variables from one page to another

2002-07-08 Thread Hutchins, Richard
Matthew, have you tried running your query from the command line in MySQL? If you can do that successfully, that'll prove that the query is functioning properly and the problem can be tracked elsewhere. -Original Message- From: Matthew K. Gold [mailto:[EMAIL PROTECTED]] Sent: Monday,

[PHP-DB] MySQL Query problem...

2002-07-08 Thread NIPP, SCOTT V (SBCSI)
I seem to have run into another problem with a query that I am doing exactly like the example in the MySQL documentation, I think. The following query is not working on my PHP page, and it is not working from a MySQL command line either. This looks exactly the same as an example in the

Re: [PHP-DB] passing variables from one page to another

2002-07-08 Thread Matthew K. Gold
It works from the command line if I leave out course.CourseID = $CourseID in the where line of the select clause. I assume that I'd have to leave that out when working from the command line because it's defined in the php file... But I think that that is where my problem is. As I've

RE: [PHP-DB] passing variables from one page to another

2002-07-08 Thread Rich Hutchins
Just wanted to eliminate one possible problem area. If the query works, then the problem must be in the PHP or the HTML. What do you see if you right click and view source on the blank page you get? If you see something there, copy it into a reply. Might be nothing important, but it'll show us

Re: [PHP-DB] PDF

2002-07-08 Thread Jason Wong
Natividad Castro said: Hi to all, How can I display info in a PDF? All I need is to be able to read from a table and display fields into a PDF. Before, I had my DB in Microsoft Access, so I bounded all the fields in a report and then I converted it into PDF document. But now that we switch

Re: [PHP-DB] PDF

2002-07-08 Thread Chris Boget
If someone has any idea, please let me know I would strongly suggest that you use a PDF class of some sort. There're quite a few available. I've had good results with pc4p. Typically, most PDF classes require that it be working from some sort of static template. If that is fine, then

Re: [PHP-DB] passing variables from one page to another

2002-07-08 Thread Matthew K. Gold
Thanks for the response. Here's what I see in the source code: !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META content=text/html; charset=windows-1252 http-equiv=Content-Type/HEAD BODY/BODY/HTML I'm not actually testing the link--I'm just typing the following url into

[PHP-DB] FYI :: MSSQL and stored procedures

2002-07-08 Thread Shrock, Court
Just throwing this out there in case someone has come across this before and hasn't found a solution: If you are performing a stored procedure inside a loop, it is a good idea to unset the variable that mssql_init returns so that you do NOT bind multiple values to the same stored procedure:

RE: [PHP-DB] Form select field problem

2002-07-08 Thread Beau Lebens
Keiran, A couple possibilities for you; 1. Try referring to the field (in JavaScript) as something like; (might have to play around with this) document.existing[groupchoice[]].selectedIndex 2. Make it so that each selection on the select tag is mirrored into another hidden input field

[PHP-DB] Session data not being deleted on browser close.

2002-07-08 Thread Youngie
Why would my session data not be deleted after my browser is closed? I can set some session variables, close my browser, reopen them and the old values are still present, I can verify this by seeing that the file still containts my session data and values. Thanks John. -- PHP Database

[PHP-DB] Build-up of MySQL Sessions

2002-07-08 Thread SpamSucks86
I'm running windows 2000 and the latest releases of PHP and MySQL. All database connections are made with mysql_pconnect(). Connections build up, however. The only person connecting to this webserver at the moment is myself. It seems that it opens connections and doesn't close them, or opens

Re: [PHP-DB] Oracle IDLE_TIME Profile Parameter plogon

2002-07-08 Thread Steve Farmer
Hi, At 1:40 PM +0200 8/7/02, B. PERRINE wrote: We are using these ORACLE PARAMETERS, but we don't use plogon; too problems. Instead, we use one logon per request. Is any one really use plogon successfully with Oracle Database 8i and more ? I am using plogon with no problems, apache is compiled

RE: [PHP-DB] Session data not being deleted on browser close.

2002-07-08 Thread Beau Lebens
have you closed all browser windows? eg. if you open your browser, then spawn a new window (ctrl-n or similar) then do something with one of them which creates session vars, then close that window, then open a new one again, the session has probably remained active because the first window was