Gossamer Forum
(Advanced Search)
for
Home : Products : DBMan : Customization :

Number of Database Listings.

Mar 5, 1999, 11:51 AM
JetTroop
New User (3 posts)
Mar 5, 1999, 11:51 AM
Post #1 of 7
Views: 3837
Shortcut
Quote Reply
Number of Database Listings.
I've done a search but couldn't find if it's been dicussed before, although I'm sure it has.

My question is this. On the main login screen for DBman, I have the standard blah, blah, blah. But I want it to say, "There are currently 500 listings in Database"

I know this can be done for Links but I wasn't sure if it's the same for DBMan.

Thanks!

------------------
Sean Fay

Aurora Web - Professional Web Hosting loaded with features.
http://www.auroraweb.net
Mar 5, 1999, 3:12 PM
JPDeni
Veteran / Moderator (8669 posts)
Mar 5, 1999, 3:12 PM
Post #2 of 7
Views: 3727
Shortcut
Quote Reply
Re: Number of Database Listings. In reply to
I think this should work:

Code:
open (DB, "<$db_file_name") or &cgierr("error in search. unable to open database: $db_file_name.\nReason: $!");
if ($db_use_flock) { flock(DB, 1); }
@lines = <DB>;
close DB;
$items = scalar(@lines);

Then use the variable $items where you want to print out the number of records.


------------------
JPD




[This message has been edited by JPDeni (edited March 11, 1999).]
Mar 6, 1999, 11:22 AM
jdulberg
User (305 posts)
Mar 6, 1999, 11:22 AM
Post #3 of 7
Views: 3747
Shortcut
Quote Reply
Re: Number of Database Listings. In reply to
Yep, it works quite nicely! Thanks for yet another mod!


------------------
Jason
Extreme mtb
http://extreme.nas.net
Mar 11, 1999, 10:27 AM
sangiro
Enthusiast (524 posts)
sangiro's avatar
Mar 11, 1999, 10:27 AM
Post #4 of 7
Views: 3741
Shortcut
Quote Reply
Re: Number of Database Listings. In reply to
Thank you - I'm looking for this as well. As I am a Perl/CGI illiterate, any help on how to pop this piece of code into its own CGI file that I can call through an SSI statement from any page to show the number of records?



------------------
Safe swoops
Sangiro

www.dropzone.com
Mar 11, 1999, 1:48 PM
JPDeni
Veteran / Moderator (8669 posts)
Mar 11, 1999, 1:48 PM
Post #5 of 7
Views: 3737
Shortcut
Quote Reply
Re: Number of Database Listings. In reply to
I'm afraid I can't help you with SSI. With any luck someone else will be able to help.



------------------
JPD





Mar 11, 1999, 2:07 PM
Alex
Administrator (9387 posts)
Mar 11, 1999, 2:07 PM
Post #6 of 7
Views: 3728
Shortcut
Quote Reply
Re: Number of Database Listings. In reply to
All you need to do is:

Code:
#!/usr/bin/perl
print "Content-type: text/html\n\n";
open (DB, "/path/to/default.db") or print "Cant' find db!";
while (<DB> ) { $count++; }
close DB;
print $count;
# ------------------------------------------

and then call it <!--#exec cgi="/path/to/cgi/file"-->

Cheers,

Alex
Mar 12, 1999, 3:53 PM
sangiro
Enthusiast (524 posts)
sangiro's avatar
Mar 12, 1999, 3:53 PM
Post #7 of 7
Views: 3742
Shortcut
Quote Reply
Re: Number of Database Listings. In reply to
Thank you Alex!

Here are some flowers for you guys...

I've got more scripts running on my new web site then I care to know. So, being a bit of a dud with PERL I need to ask for help and advice often.

I have not come across the level of advice and responsiveness that I receive in these forums anywhere else on the web.

Your team certainly builds great scripts and your support kicks ass!

Keep it up.




------------------
Safe swoops
Sangiro

www.dropzone.com