How can i do this

Anon

21/11/2000

Can anyone give me some pointers/code 😉 on how i can do this :

I got this page where people order items. What i want to do is when they click on the link to go to that page, i want to check how many orders have been recvd on that day. If there are say 5 orders recvd on that day then i want them to be told that quota for the day is full and show them the form & a mesg that they can try tommorrow, if its less than 5 then they will be shown the order form.

Thanks

Anon

Hi, I am Javed and am beginner in PHP and SQL. I have created a database in MySQL named SOFTWARE,
and I have these tables in it :

MAINLIB ( For keeping the names of IMAGE LIBRARY names )
Fields are a. newlibrary varchar(60)
b. idmain int(10) ( Primary key - Autoincrement )
UNDRLIB ( For keeping the names of IMAGE CATEGORY under library names )
Fields are a. newcategory varchar(60)
b. idmain int(10) ( to relate it to MAINLIB )
c. idcat int(10) ( Primary key - Autoincrement )
DSGNLIB ( For keeping the names of IMAGES under selected categories and libraries )
Fields are a. idmain int(10) ( to relate it to MAINLIB )
b. idcat int(10) ( to relate it to UNDRCAT )
c. smallthumblink varchar(60) ( to keep small thumbnail link names of images )
d. bigimageanddesc varchar(60) ( to keep big images link names and description )
e. iddsgn int(10) ( Primary ket - Autoincrement )

Now I want to give the preferances to the user to select a library name and category and accrodingly I want to display small thumbnail images to the user. The problem is image library is bit big and I want to display these images on subsequent pages. That is in first page suppose I want to display 10 images. Then when the user press NEXT button it should display the next 10 images and so on. If the user press PREVIOUS button then it should display PREVIOUS 10 images to the user. When the user right clicks on any of the images it should provide a link to the BIG IMAGE FILE.

I dont know how to handle it, so I am requesting you to guide me. I will be much obliged for valuble sugestion.

Thanking You. I remain

Anon

Are you using a database? If so, it's a matter of one select statement to see how many orders there have been today.
Otherwise, you'll have to keep the count in a textfile or something like that.

Anon

The easiest way i can think of is:

link -> <.. "file.php?uid=12345" ..>

next page: ( I assume your using a db )

// connect to db
$query = "SELECT orders FROM atable WHERE uid = $uid";

// run query

// get what ever is returned (email me if you don't know how)

if ($retval < 5){
include("orderform.htm");
}else{
include("sorry.htm");
}

if you don't understand or need more detail just email me

nathan@ukip.com

Good luck

Anon

22/11/2000

I got it kind of working as follows, but am having some probs ..

i have link that goes to a php file to do the checking & count , then the conditional statement to check

if ($counter < 5 ){
include("neworder1.php");
}else{
include("sorry.html");
}

it works but if it includes the php page i get

Warning: Cannot add header information - headers already sent by (output started at neworder.php:2) in
neworder1.php on line 1

at the top of the page & then the form.

this appears a few times at the top of the page. At the bottom of the page i get

Warning: 5 is not a valid MySQL result resource in neworder.php on line 29

The only thing in neworder.php is the connection to mysql via an .inc file & the sql to do the checking.

If .html file is shown then there are no error messages.

Any ideas ?

Another thing if i may, how can i make sure that no one bypasses the neworder.php file which does the checking and go straight to the neworder1.php file ?

Thanks

Anon

"Warning: Cannot add header information - headers already sent by (output started at neworder.php:2) in
neworder1.php on line 1"

this is because you are trying to set a cookie/or redirect (Header(""); in neworder.php
if you are doing either of these make sure nothing is echoed before these commands.
Even white space before the first <?

at the top of the page & then the form.

"this appears a few times at the top of the page. At the bottom of the page i get"

"Warning: 5 is not a valid MySQL result resource in neworder.php on line 29"

This could be a number of things but it's most likely that the SQl is wrong. Test this by copying the SQL in running it in a telnet session, if all's well then check PHP is connecting to the SQL server correctly.

"The only thing in neworder.php is the connection to mysql via an .inc file & the sql to do the checking."

"If .html file is shown then there are no error messages."

"Any ideas ?"

Loads 🙂

"Another thing if i may, how can i make sure that no one bypasses the neworder.php file which does the checking and go straight to the neworder1.php file ?"

Can't really tell you as I don't know how it (your program) works properly.

Thanks

Your welcome

If you get really stuck, you can send your program to nathan@ukip.com and I'll have a look in my spare time.

Happy coding

Nath