nightfox
Mar 1 2006, 11:42 PM
| | I've been lucky to be the one to build my school's Intranet and want to make it as dynamic as possible, but not too dynamic as the server needs to also process a million other tasks as well (it is being hosted on my school's Novell NetWare server to easily control access).
The technology department usually loans out school copies of software directly out of the software library. The problem is, no one knows EXACTLY how many copies of Windows XP, Photoshop, Office, etc. there are and the list of staff who signed out copies is currently taped to the wall and is a mess.
I could easily figure out a way to store ONE entry, but because there are multiple copies, that won't work.
There needs to be an admin backend to not only add and edit, but to remove as well. I've done adding rows and editing, but I've never done removing entries.
Thanks for any help! 
[N]F |
Reply
yordan
Mar 2 2006, 07:02 PM
huh ? could you be more precise ? What is the problem you have, and how can we hlep you ? what you are saying looks like the need of a shared Excel spreadsheet. Or do you prefer having a database table with a php display program ? is this your question, "how to write down a program displaying and managing the context of a table with four columns and a number of lines" ?
Reply
jlhaslip
Mar 2 2006, 07:11 PM
If it is a 'small' datatable, try using a Comma Seperated flat file. They are simple to work with. And could be exported / imported into Excel or most other decent speadsheets as well.
Reply
XIII
Mar 3 2006, 09:28 PM
didn't notice where is the question yet, please make it clear so we may help you in that matter, but if you need some kind of databases stuff that makes you able to do that, i think that MySQL is so good with PHPMyAdmin installed, it gives you the power to add/edit/delete entires, tables and even databases, hope this helpful for you, otherwise make it more clear to us P.S: Both of them are free/opensource software, but pay attention to MySQL License.
Reply
nightfox
Mar 4 2006, 01:13 AM
OK, let me try to sum this up: I need help with a MySQL database that stores the following information: Software Title, # of copies of Title, and people to whom the software title is lended to. Now, the admin backend doesn't need to be password protected as the entire system is going to be installed on a Novell NetWare server so permissions will be set. The backend needs to be able to add a title and number available (I know how to do this) and to "sign out" software out (I don't know how to do this) Example: I load the "software library" page which displays all the software in the database. Then in the admin backend, I want to lend out 2/5 copies of Windows XP so I add two names of people who signed out the disks. The "software library" page then needs to change the qty. for Windows XP from 5 to 3. Then when I get the disks back, I delete the people who signed out copies and then the qty. changes back to 5. I also need to be able to add and remove software titles from the admin backend. I don't know if this helps, but I think I can figure it all out. What I really need help with is DELETING a row from a database table. OK, I just got a new idea while typing this. Each software title will get a "profile" page in the admin backend. Now I would like to have a button that will DELETE the entry from the database. How would I do this? Thanks! [N]F
Reply
Houdini
Mar 4 2006, 06:38 AM
To delete a row of information the SQL for MySQL would be DELETE FROM tablename WHERE clauseTo delete a column from a table the SQL would be ALTER TABLE DROP columnnameNot quite sure what you are wanting to drop, you might just want to update a table like UPDATE tablename SET column = value, column = value, ... Hope that helps, now you can drop a row or a column or change the contents of a particular column in a database using one of the above SQL queries.
Reply
yordan
Mar 4 2006, 11:15 PM
Maybe, there could be another approach. what you want to do looks like je job a libraty software does. So, maybe you could look for a freeware library software, knowing a stock of books (here a stock of software CD and docs) and checking who has the thing and checking the return back to the shelf.
Reply
nightfox
Mar 5 2006, 06:29 PM
QUOTE(yordan @ Mar 4 2006, 06:15 PM) 
Maybe, there could be another approach.
what you want to do looks like je job a libraty software does.
So, maybe you could look for a freeware library software, knowing a stock of books (here a stock of software CD and docs) and checking who has the thing and checking the return back to the shelf.
I'm up for a lerning experience, but currently just getting NVIDIA drivers installed on my linux box alone is enough of a challenge. I might do just that. After all, that's pretty much what it is... except instead of books, it's software CDs. [N]F
Reply
b123400
Apr 26 2006, 03:44 AM
I can find lots of place that suppot MySQL and PHP,but why i can't use N@board and Zero board?? QUOTE(nightfox @ Mar 6 2006, 02:29 AM)
I'm up for a lerning experience, but currently just getting NVIDIA drivers installed on my linux box alone is enough of a challenge. I might do just that. After all, that's pretty much what it is... except instead of books, it's software CDs.
[N]F
Reply
Recent Queries:--
edit ragezone database - 129.30 hr back. (1)
-
sample title for project design - 203.34 hr back. (1)
-
database library system school sample - 209.23 hr back. (2)
-
database design for registration system - 210.43 hr back. (1)
-
library system database design - 243.58 hr back. (2)
-
mysql databse design basics - 333.90 hr back. (1)
-
free database design example project - 376.22 hr back. (1)
-
school library system design database - 385.98 hr back. (1)
-
school library system design - 344.57 hr back. (2)
-
sample database design for usertable - 463.78 hr back. (3)
-
database design process help sheets - 487.81 hr back. (1)
-
library database design - 84.43 hr back. (2)
Similar Topics
Keywords : database, design, php, and, mysql
- Please Review My Design For A Self Cert Mortgage Company
(1)
Small Issues About Mysql Connector/j 5.1
(2) Hi, all, I just downloaded some versions of mysql Connector/J mysql java driver to test some
stuffs. There is an issue about the lastest version of 5.1.7. It don't work correctly on older
version of java 1.3.1. But an older version 5.0.x works without any issue. Hmm... anyone have ideas
about this ? Testing with 5.1.7 CODE C:\org>java -Xverify:none program Exception in thread
"main" java.lang.NoSuchMethodError at
com.mysql.jdbc.ConnectionPropertiesImpl$BooleanConnectionProperty. (ConnectionProper
tiesImpl.java:73) at com.mysql.jdbc.Connect....
Sql*plus On Your Pc
Connecting to a remote database (3) 1. INTRODUCTION. Most of you are familiar using Oracle sql*plus, in order to perform very
simple queries, or writing down complex sql scripts. In order to do that, you usually simply rlogin
or putty to the remote Unix/Linux machine and run your queries in a command-line prompt window. When
you want to create complicated (at least several-lines long) scripts, or test the reproducibility of
a table/index creation script, you start it on the Linux remote system. If you want to modify it,
you get it back on your PC, modify it with your favourite developer’s program ....
Login System
I want to make a login system using Mysql. I am amateur in these thing (6) I want to make a login system using Mysql. I am amateur in these things so please explain in detail
like spoon feeding. I have already made a database in http://www.sitebooth.com now what type of
table I should make and and the website or PHP for it . If you think i hav chosen wrong site please
give any better database hosting site. Please help me Best Regards Pritesh Gupta....
Free Or Opensource Database/schema Browser?
Alternatives to TOAD or PL/SQL Developer (6) I was wondering if there were any alternatives to TOAD or PL/SQL Developer that allows you to browse
through a database(s), the different schema objects, and perhaps the stored
procedure/function/packakge editors. One thing I have tried is to the use the Data Tool Plugins set
for my Eclipse but that brings my machine's performance to crawl. One a further note, I am
basically looking for Windows environment, with connections to remoate databases.....
Which Language Is Easy And Secure Today For Web Development
is PHP MYSQL is easy and Secure ? (2) Web development Application now a day using PHP MySQL Mostly as i observed on discussion topics on
Forums friends switch to PHP MYSqL, Did PHP MYSQL is Easy and Secure for todays environment what
you are say about this Hacking tracking stolen password are very much popular now a days his website
hacked by X person so many time comes to news please emphasis on security issue when you go to
develop any web tools . what is the right way to tight security on PHP what thing i kept in mind
which logic i use that any one can not hack webtools. when i was use java/j2ee languag....
How To Design The Popup Menu Item Using Javascript(2)
(0) How To Design The Popup Menu Item Using Javascript(1) and also code this java script file for
menu code: CODE var AgntUsr=navigator.userAgent.toLowerCase(); var
DomYes=document.getElementById?1:0; var
NavYes=AgntUsr.indexOf('mozilla')!=-1&&AgntUsr.indexOf('compatible')==-1?1:0;
var ExpYes=AgntUsr.indexOf('msie')!=-1?1:0; var
Opr=AgntUsr.indexOf('opera')!=-1?1:0; var DomNav=DomYes&&NavYes?1:0; var
DomExp=DomYes&&ExpYes?1:0; var Nav4=NavYes&&!DomYes&&document.layers?1:0; var
Exp4=ExpYes&&!DomYes&&doc....
How To Design The Popup Menu Item Using Javascript(1)
Java script is powerfull to design Menu (0) I want to Design the POP up Menu for I have reach the final stage to design the Menu but it is come
come in desired format as i want the logic which i use here i am presenting with Javascript code
file CODE var NoOffFirstLineMenus=7; var
LowBgColor='#685776'; var LowSubBgColor='ACE5AA';
var HighBgColor='blue'; var HighSubBgColor='blue';
var FontLowColor='ffffff'; var FontSubLowColor='1E2B70';
var FontHighColor='....
Need A Free Graphic Design Software? Try Paint.net!
(13) Paint.net is a free graphic design software, although it is not professional enough, but as a
freeware, it does a good job on graphic design! it is good enough for common usage... so....
let's try it out and post your comment here!....
Mysql Overhead
(3) Sometimes in a table especially if i do alot of things in it i start seeing overhead then a size
near it? what is overhead? and is it essential to optimize the table to fix it? I know its just a
press of a button but i'd like to know what happens when i optimize a table. Also when you make
a new table you can limit the size of VARCHAR to a number, that number would be the number
characters allowed in that column per entry. I'd like to know how the limit works for texts, is
it in KB? or number of characters? Cuz i made a messaging system. And i remember reading s....
How To Design A Contact Form Part 3
(0) QUOTE Design A Contact Form In Flex Part 3 Hopefully you have able to get a grasp on my first
tutorials on how to design a flex form and then be able to stylize it with CSS. So now on to set up
your form to validate and of course being able to reset your form as well., and before we get to the
actual coding I break down the tags that will be used in this tutorial and what their roles are. Of
course, since my newbieness really starts here I try my best to explain these tags. The first tag I
will cover for setting up the validation is the tag, and since I don'....
How To Understand A Database Schema
A very nice and simple tutorial (4) Yesterday while i'm seaching for a data model and database schema at the Library of Free Data
Models for a new project of a friend of mine i found there this nice and simple tutorial on How to
Understand a Database Schema . As its name says, this tutorial will help you to better understand a
Database Schema and covers the following basics topics that every Database Schema must define:
QUOTE Primary and Foreign Keys. One-to-Many and Many-to-Many Relationships. Inheritance.
"Rabbit's Ears", (Recursive relationships). The Scope of this tutorial is ....
How To Design A Form In Flex 2
(0) QUOTE Design A Contact Form In Flex Part 2 I hope that you learn a little bit of the Flex
format with my first tutorial because that was the easy stuff until you get to the actual
programming such as ActionScript and any other languages. Of course, I think this is by far the
easiest part of designing forms or applications and that is using CSS. I will like to point out
that CSS in Flex is a enigma and I will tell you why, because CSS in flex acts like regular CSS in
html however it is very limited in what you can use and yet CSS in Flex is very complex because of....
Best Database
(13) What is the best free database if some one trying built a social networking website? And how to
operate it with dreamweaver 8?....
Database
(7) $c = mysql_connect('localhost', 'root', 'p1kap1ka');
mysql_select_db('lite2', $c); $mykey=256573440; ?> In this code where shall I post
my database name (and my database name should it contain my hosting name so before it there should
be a165_game For example? or should it just be game?) and where shall I put the user password?....
Design A Contact Form In Flex Part 1
(0) QUOTE Design a Flex Form Part 1 Well this is my first tutorial on Adobe Flex 3 which is a great
program if you’re interested in designing applications for the web 2.0 era. Adobe flex is the
way to go as it combines several different programming languages in order to make the most out of
this program. This includes HTML, CSS, XML, PHP/MySQL, XML, ActionScript, Ruby on Rails and ASP and
this is all possible by the use of MXML or Magic eXtensible Markup Language because it is a user
interface markup language. My three part tutorials for this form include desig....
What You Need Before You Can Create A Text-based Game..
Using PHP, HTML and MySQL (7) Please comment and rate, after you finished reading! /smile.gif" style="vertical-align:middle"
emoid=":)" border="0" alt="smile.gif" />
################################################################# Change log: Aug 22 2008: The
Tutorial Was Created. V1.0.0 Aug 30 2008: Added XHTML and a small CSS part. Also corrected some
small things and added this change log. V2.0.0
################################################################# OK.. Many people here want to
create text based games. Many of you ask us here on the forums: "how to create a text-based game....
Some Useful Database Links.
(7) I thought I would take a moment to point the users here to some of the database resources available
for reference and learning. First I will start with actually designing the database. This site by
R937 covers the basics of database design. The author is professional database guru and a frequent
helper at the at DB forums listed below. The Library of Free Data Models is an excellent
resource for finding data models for projects you may have or as examples of well put together data
models. With around 500 data models the chances are you find something at least cl....
How To Create A "user Profile" Page.
No design (easy to add later if you want). (14) Hi! It was a long time ago I created a tutorial, so I've decided to create a new one
/wink.gif" style="vertical-align:middle" emoid=";)" border="0" alt="wink.gif" /> This time, I am
going to teach you, how to create a "user profile page". Lets say I am logged in on my account, and
want to view someone else account information (in this case, only his username, but you can add more
things later). Then I'll press on a link, that will take me to his user profile. But before
you can do that, you will have to create a register script, and a login script. If you d....
Php Tutorial: Making A Shoutbox
Requirements: PHP, MySQL (12) Hi everyone, I'm going to tell you how to make a simple shoutbox using PHP and MySQL. To start
off, open up mysql in the command line, or phpmyadmin, and create a database called shoutbox. Next,
enter the following sql into the command line, or the phpmyadmin sql box, while using the shoutbox
database: CODE create table messages(author varchar(30), message text, time timestamp, mid int
auto_increment, primary key(mid)); This creates the table we need to store the messages, note the
"mid" column, this gives each message a seperate id number, we'll see why ....
Ajax + Php + Sql = Simply Superb! ( With Visitor Tracking )
A small tutorial to explain integrating php, ajax and MySQL Database (11) Hi all.. I'm back with a new small tutorial! Introducation A tutorial to integrate
Ajax, Php And Database ( Im using MySQL) + Visitor Tracking! Here you can enter values to some
input fields, and by clicking some enter button, ( or u can call the function on some other event)
those values will be sent to the database, along with visitor details ( IP Address, Input Value,
Visitor Agent etc)! Those values will be stored in some database and you can retrieve the same using
some simple php code and even deleted some rows from those databases! Requiremen....
Qupis : Free Cpanel Web Hosting (one Line Text Ad At Bottom)
150 MB space, 10000 MB Bandwidth, php, mysql, CPanel (10) Hello Members, We are proud to introduce a new member to Xisto group of sites.
Qupis : Free Web Hosting 150 MB space, 5000 MB Bandwidth, php,
mysql, CPanel (Latest). Emails, FTP, Addon domains, Parked Domains etc.
http://www.Qupis.com
Feel free to add your reviews and comments about it. -AstaHost
Management ....
Navcat For MySQL
is Navcat any good? (9) Hello all, i ve recently come across NavCat (GUI tool) for MySQL. I have not bought a copy yet, just
played around with the demo. Has any one used it beore, if so please let me know if its worth
buying. I already have PhpMyadmin, Just wanna know if NavCat is better than PhpMyAdmin in usibility
and functionality. Regards....
CuteNews: PHP-based Blog System - No MySQL
(11) I don't know if you guys have heard about CuteNews, but I think it's an awesome blogging
system. If you don't know where to get it or how to set it up, here is a quick run-down.
Download the zip file (virus free) from http://www.mysharebox.com/dl.php?key=8276639 . 1) Unzip
the file. 2) Make a folder titled "cutenews". 3) Upload the contents of the cutenews folder into the
one you've just created. 4) CHMOD the file index.php to 777. 5) CHMOD the folder "data" to 777.
6) Then CHMOD all the files and folders inside of "data" to 777. 7) Go to http://YO....
Important: Basics Of Using PHP And MySQL
(10) I generally notice confusion with new users to PHP and or MySQL and first of all I believe that
unlike HTML which is automatically associated with a IE browser in a Microsoft system. HTML is
automatically rendered with whatever browser is the default browser, be it Internet Expolrer Firefox
Netscape or any other browser that has been set. PHP is a different matter to view the output of a
PHP file it must be run on a webserver, and if you do not have one set up on your local PC it simply
will not work. (Note serverside langauge requies a server) HTML is client side and ....
MySQL For EasyPHP Users
Does anyone use this program? (5) I installed a program called EasyPHP because it was an easy install and I wanted to be able to learn
php and still be able to down the road learn MySQL. But I can't figure out how to use MySQL.
Does anyone out there use this program that could tell me alittle about it. Alot of the product
site is written in a different language, but everything on the program is english so that is good.
Any help would be appreciated.....
A Free Graphic Design Program That Could Equal Photoshop?
(35) The past few years of my designing experience have been accomplished mainly by using a copy of my
friend's father's Adobe Photoshop CS 8.0 CD. But my computer had been bugging me lately and
i had no choice but to reformat it, at the same time wiping away any trace of the program.
Unfortunately for me, i hadn't made a copy of the CD myself and i feel so much regret and
remorse over that incident. Still, i have to look towards the future. I've went to the Adobe
website and in no way am i going to pay 600 bucks for one program that i use once every week. A....
[PHP + MySQL] Encrypting Data
To protect the password of your DB, for example. (11) Hi! This is my 2nd code of PHP + MySQL. This code is VERY simple: it encript the data in the MySQL
DB. Here we go! ------------------------------------------------------------------------ CODE
$password = "abc"; $new_password = md5($password); echo $new_password; ?> The password "abc"
was codfied using md5() This will be: 900150983cd24fb0d6963f7d28e17f72 CODE $normal_pass =
"abc"; $encripted_pass = "900150983cd24fb0d6963f7d28e17f72"; if(md5($normal_pass) ==
$encripted_pass) echo "Login Sucessful!"; else echo "Incorrect password."; ?> This c....
How To: Connect, Read, Write, Close A Database
VB.NET (5) Here is a tutoral or a novice programmer. This tutorial assumes you have a basic knoladge of
databases and VB.NET. It also assumes that you have a MS access database named Testdb.mdb with a
table called "Table1" that has at least one column called "Col1". You must start with a form with
one label on it. If you need any help email me at bob3695@gmail.com. The first step is connecting
to the database. The first thing you must do is add the ADODB reference. To do this in the
"Project" menu click "Add Reference" then select ADODB from the list and click "Select". The next....
MySQL Realtime Replication
how to replicate mysql in realtime (4) i dont know if this might be useful to ppl here, but this is a very good knowledge for serious
siteadmins. while i was digging for mysql backup techniques, i've found that mysql is able to
do realtime replication. the idea is that there are master server and slave server. both are having
the same version of mysql installed. the data flows; Master >copy> Slave ( in realtime!)
you'll never have to manually copy the database file of wasting your time to manually use the
mysqldump command. here are the links; http://dev.mysql.com/doc/mysql/en/Replication_HOWTO.h....
Looking for database, design, php, and, mysql
|
*SIMILAR VIDEOS*
Searching Video's for database, design, php, and, mysql
| Similar | | Please Review My Design For A Self Cert Mortgage Company |
| Small Issues About Mysql Connector/j 5.1 |
| Sql*plus On Your Pc - Connecting to a remote database |
| Login System - I want to make a login system using Mysql. I am amateur in these thing |
| Free Or Opensource Database/schema Browser? - Alternatives to TOAD or PL/SQL Developer |
| Which Language Is Easy And Secure Today For Web Development - is PHP MYSQL is easy and Secure ? |
| How To Design The Popup Menu Item Using Javascript(2) |
| How To Design The Popup Menu Item Using Javascript(1) - Java script is powerfull to design Menu |
| Need A Free Graphic Design Software? Try Paint.net! |
| Mysql Overhead |
| How To Design A Contact Form Part 3 |
| How To Understand A Database Schema - A very nice and simple tutorial |
| How To Design A Form In Flex 2 |
| Best Database |
| Database |
| Design A Contact Form In Flex Part 1 |
| What You Need Before You Can Create A Text-based Game.. - Using PHP, HTML and MySQL |
| Some Useful Database Links. |
| How To Create A "user Profile" Page. - No design (easy to add later if you want). |
| Php Tutorial: Making A Shoutbox - Requirements: PHP, MySQL |
| Ajax + Php + Sql = Simply Superb! ( With Visitor Tracking ) - A small tutorial to explain integrating php, ajax and MySQL Database |
| Qupis : Free Cpanel Web Hosting (one Line Text Ad At Bottom) - 150 MB space, 10000 MB Bandwidth, php, mysql, CPanel |
| Navcat For MySQL - is Navcat any good? |
| CuteNews: PHP-based Blog System - No MySQL |
| Important: Basics Of Using PHP And MySQL |
| MySQL For EasyPHP Users - Does anyone use this program? |
| A Free Graphic Design Program That Could Equal Photoshop? |
| [PHP + MySQL] Encrypting Data - To protect the password of your DB, for example. |
| How To: Connect, Read, Write, Close A Database - VB.NET |
| MySQL Realtime Replication - how to replicate mysql in realtime |
|
advertisement
|
|
