CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> PHP

 Retrieving Data based on User_ID Question

Print topic Send  topic

Author Message
Dave122

Posts: 3
Posted: 09/21/2005, 12:37 AM

Hello, I am currently building a application where parents can view the data of their kids. The data is being uploaded with access as frontend to mysql. The students have a Parent_ID field which indicates to which parent they belong.

The problem is that I don't know what kind of custom code I have to add to show the students based on the User_ID.

Can someone explain it to me with a basic example?

Thanks in Advance

Dave
View profile  Send private message
Damian Hupfeld
Posted: 09/21/2005, 4:49 AM

Basically you have the parents log in and you filter the children based on a
CCGetSession(UserID) against the Parent_ID.

Damian



"Dave122" <Dave122@forum.codecharge> wrote in message
news:543310dbc447f3@news.codecharge.com...
> Hello, I am currently building a application where parents can view the
> data of
> their kids. The data is being uploaded with access as frontend to mysql.
> The
> students have a Parent_ID field which indicates to which parent they
> belong.
>
> The problem is that I don't know what kind of custom code I have to add to
> show
> the students based on the User_ID.
>
> Can someone explain it to me with a basic example?
>
> Thanks in Advance
>
> Dave
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>

Dave122

Posts: 3
Posted: 09/28/2005, 12:18 AM

Thanks that worked. However I have 2 more problems which I can't figure out.

1. Once I add a fileupload component I get a error with rand() which says incorrect values 100000,999999 in classes.php on line 1266

Everything works fine but the error is ofcourse annoying. Is there a way to fix this?

2. Once the file is uploaded it adds a number behind it for unique filenames. You can get the original filename back by adding GetOrigfilename in the beforeshow event. However once I want to change the label in a link so users can view the file instead of seeing it as normal text I use somethng like <a href="files/{File}" target="_blanc">{File}</a>

This works but as soon as I add the GetorigFilename the link changes as well ofcourse so I will have incorrect links for every file since the number is removed. Is there a way to solve this?

Thanks in Advance

Dave
View profile  Send private message
Damian Hupfeld
Posted: 09/30/2005, 6:49 AM

hmmm...
you could use a generic link name and link to the full file name
you could use SUBSTR to strip the datestamp from the displayed text/link

Im sure there are probably quite a few ways to do this.

Damian


"Dave122" <Dave122@forum.codecharge> wrote in message
news:5433a43ade5cb9@news.codecharge.com...
> Thanks that worked. However I have 2 more problems which I can't figure
> out.
>
> 1. Once I add a fileupload component I get a error with rand() which says
> incorrect values 100000,999999 in classes.php on line 1266
>
> Everything works fine but the error is ofcourse annoying. Is there a way
> to fix
> this?
>
> 2. Once the file is uploaded it adds a number behind it for unique
> filenames.
> You can get the original filename back by adding GetOrigfilename in the
> beforeshow event. However once I want to change the label in a link so
> users
> can view the file instead of seeing it as normal text I use somethng like
> <a
> href="files/{File}" target="_blanc">{File}</a>
>
> This works but as soon as I add the GetorigFilename the link changes as
> well
> ofcourse so I will have incorrect links for every file since the number is
> removed. Is there a way to solve this?
>
> Thanks in Advance
>
> Dave
> ---------------------------------------
> 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.