CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> PHP

 Use username from Login in Listbox

Print topic Send  topic

Author Message
muebelacker

Posts: 5
Posted: 01/28/2008, 7:10 AM

Hello All,

i've a Login Page and i want to use the username to select a special entry in a listbox. So i insert a custom code on the clientside on the Login Button.

window.location.href = "Login.php?login=" + login.value;

then i modified the Listbox like this

SELECT name FROM mitarbeiter_login WHERE benutzer={login}

but this do not work any hints?

br
Mathias
View profile  Send private message
wkempees
Posted: 01/28/2008, 4:29 PM


Reading your problem description, you do this after succesful login, right?

After the Login procedure succesfuly completes it sets a number of session
variables.
CCS has a number of functions to retreive these values.
CCGetUserID
CCGetGroupID
CCGetUserLogin
(See HelpFile)
So your plain SQL would become
> SELECT name FROM mitarbeiter_login WHERE benutzer=CCGetUserLogin();
(depending on wehere you put this statemen you will need quotes.)

Walter



"muebelacker" <muebelacker@forum.codecharge> schreef in bericht
news:5479df0681091e@news.codecharge.com...
> Hello All,
>
> i've a Login Page and i want to use the username to select a special entry
> in a
> listbox. So i insert a custom code on the clientside on the Login Button.
>
> window.location.href = "Login.php?login=" + login.value;
>
> then i modified the Listbox like this
>
> SELECT name FROM mitarbeiter_login WHERE benutzer={login}
>
> but this do not work any hints?
>
> br
> Mathias
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>


Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.