Hi everybody
actually I need your help in fixing my code. Actually I have a library system that can be applied in university or any school and I'm stucking in a page that for loan student book. I have student table, Library table, books table, usersystem table and Bookoutonloan table as I mention it below so here in this table I have 4 foreign keys from different tables as I mentioned them before so here in the php page when I want to loan student I can't do it actually it will work but it's totally wrong so I want for example the students who are registered in the student table so in the attach php webpage I enter the student ID manual and might the number that I'm entering not in the origianal table for students for example I have 100 students registered so they will have from 1 to 100 number in their ID so if I write 500 in the loan it will accept and assign the the value to Bookoutonloan table but I want to change the way either I search by student name from stu ID number or what shall I do. Please I really need your help. Thanks
this is my SQL table -
CREATE TABLE `library`.`bookoutonloan` (
-
`borrowid` INT( 12 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
-
`stid` INT( 12 ) NOT NULL,
-
`bookid` INT( 12 ) NOT NULL,
-
`userid` INT( 12 ) NOT NULL,
-
`libraryid` INT( 12 ) NOT NULL,
-
`dateborrow` DATE NOT NULL ,
-
`datedueforreturn` DATE NOT NULL ,
-
`datereturned` DATE NOT NULL ,
-
`amountoffine` INT( 12 )
-
) ENGINE = MYISAM ;
-
ALTER TABLE bookoutonloan
-
ADD FOREIGN KEY (stid) REFERENCES studentorstaff(stid);
-
ALTER TABLE bookoutonloan
-
ADD FOREIGN KEY (bookid) REFERENCES books(bookid);
-
ALTER TABLE bookoutonloan
-
ADD FOREIGN KEY (userid) REFERENCES usersystem(userid);
-
ALTER TABLE bookoutonloan
-
ADD FOREIGN KEY (libraryid) REFERENCES librarybranch(libraryid);
-
-
This is the html with php code -
<?php
-
$submit = &$_POST["submitt2"];
-
$studid = $_POST["studid"];
-
$bookid = $_POST["bookid"];
-
$userid = $_POST["userid"];
-
$libraryid = $_POST["libraryid"];
-
$dateofloan = $_POST["dateofloan"];
-
$datereturn = $_POST["datereturn"];
-
$amountfine = $_POST["amountfine"];
-
-
if ($submit)
-
{
-
-
$connect = mysql_connect("localhost", "root", "");
-
mysql_select_db("library");
-
-
$queryreg = mysql_query(" INSERT INTO bookoutonloan VALUES('','$studid','$bookid','$userid', '$libraryid','$dateofloan','$datereturn','')
-
");
-
die("Loaned has been successed");
-
-
-
}
-
else
-
echo "please fill in <b>all</b> fields!";
-
?>
-
<html>
-
<body>
-
<form name="form1" method="post" action="loanbook.php">
-
<table width="37%" border="0">
-
<caption>
-
Loan Books to students
-
</caption>
-
<tr>
-
<td>Student ID:</td>
-
<td><input name="stuid" type="text" id="stuid" /></td>
-
</tr>
-
<tr>
-
<td>Book ID:</td>
-
<td><input name="bookid" type="text" id="bookid" /></td>
-
</tr>
-
<tr>
-
<td>User ID:</td>
-
<td><input name="userid" type="text" id="userid" /></td>
-
</tr>
-
<tr>
-
<td>Library ID:</td>
-
<td><input name="libraryid" type="text" id="libraryid" /></td>
-
</tr>
-
<tr>
-
<td>Date of Loan:</font></strong></td>
-
<td><input name="dateofloan" type="text" id="dateofloan" /></td>
-
</tr>
-
<tr>
-
<td>Date Due return:</td>
-
<td><input name="datereturn" type="text" id="datereturn" /></td>
-
</tr>
-
<tr>
-
<td>Amount of fine:</td>
-
<td><input name="amountfine" type="text" />
-
</tr>
-
<tr>
-
<td> </td>
-
<td><input type='submit' name='submitt2' value='Register' id='submitt2'></td>
-
</tr>
-
</table>
-
</form>
-
</body>
-
</html>
-
-
-
5  7553  
You've got a couple of issues right off the bat...
You should name the receiving columns in the query correctly
i.e. INSERT INTO bookoutonloan ( stid,bookid,...) VALUES ($studid, $bookid, ...)
Plus, you can't have a blank at the beginning of the values to be inserted.
VALUES ('', '$studid'…
That’ll try to put a char into an integer column (the auto-increment column as a matter of fact)
Also, if the conditional on $submit is true and after the query is executed (when fixed), the code just dies, but I guess that's what you wanted. - $queryreg = mysql_query( /* your original bad query here */
-
"INSERT INTO bookoutonloan VALUES (
-
'','$studid','$bookid','$userid','$libraryid','$dateofloan','$datereturn','')"
-
);
-
-
// Falls of the face of the earth.
-
die("Loaned has been successed");
The code should actually redirect the visitor somewhere else and not just fall off the face of the earth.
Homework's a bear isn't it?...! :-) Do you have anyone at school to work with?
[Reminds me of writing my first program...
Add 2 + 2 on a main frame using 80 column punched cards...
With all the JCL language to setup the environment first...
Those were the days... :-)]
After you've fixed these things, thought out your logic a bit better, write some more REAL code, come back with your results.
Thanks man for your reply actually I posted the wrong code by mistake and I've just checked it now. By the way the first two quotes in insert command "" it will work fine because there is borrowid will an increment by itself so no problem it will be fine and I'm already tried it, it works fine. but my problem is I really don't know how to think for this page and as I'm in the beginning of php and I don't have anyone to work with unless you are guys my last hope to find a soulution for my code. I'll explain more actually in this page I want to loan Student a book and I have in my database that for this page I post it up that I collect all the IDs from different tables as I'm showing it here in this link http://uploadpic.org/showpic-39097/libr.png it's only simple not a complete one just to see the other tables with the primary keys.
so I have here 5 tables and I'm working now for bookoutonloan table that I have 4 foreign keys and they R IDs but the first one is borrowid is primary key for this table and I want to make this page to be easy for user either by entering student ID and get his name because you know someone students might make mistake in their ID and if I have for example 100 students so their IDs will be from 1 to 100 but I tried to make a test for this loan like entering 400 and found that it success passing and it should check the student table that if the ID really exist there or not. Same thing with book it's difficult for user to memorize the ID for all books so wither I put drop down list to see all books and also it's difficult thing to do it. Anyway hope if you can really help I really need help and I couldn't find a solution by myself please stay with me.
This is the correct PHP code -
<?php
-
-
$submit = &$_POST["submitt2"];
-
-
$studid = $_POST["stuid"];
-
$bookid = $_POST["bookid"];
-
$userid = $_POST["userid"];
-
$libraryid = $_POST["libraryid"];
-
$dateofloan = $_POST["dateofloan"];
-
$dateduereturn = $_POST["dateofloan"];
-
$datereturned = $_POST["datereturn"];
-
$amountfine = $_POST["amountfine"];
-
-
if ($submit)
-
{
-
-
$connect = mysql_connect("localhost", "root", "");
-
mysql_select_db("library");
-
-
$queryreg = mysql_query(" INSERT INTO bookoutonloan VALUES('','$studid','$bookid','$userid', '$libraryid','$dateofloan','$dateduereturn','$datereturned','$amountfine')
-
");
-
die("Loaned has been successed! <a href='main.php'> return to Main page</a>");
-
-
-
}
-
else
-
echo "please fill in <b>all</b> fields!";
-
?>
-
<html>
-
<body>
-
<form name="form1" method="post" action="looaan.php">
-
<table width="37%" border="0">
-
<caption>
-
Loan Books to students
-
</caption>
-
<tr>
-
<td>Student ID:</td>
-
<td><input name="stuid" type="text" id="stuid" /></td>
-
</tr>
-
<tr>
-
<td>Book ID:</td>
-
<td><input name="bookid" type="text" id="bookid" /></td>
-
</tr>
-
<tr>
-
<td>User ID:</td>
-
<td><input name="userid" type="text" id="userid" /></td>
-
</tr>
-
<tr>
-
<td>Library ID:</td>
-
<td><input name="libraryid" type="text" id="libraryid" /></td>
-
</tr>
-
<tr>
-
<td>Date of Loan:</font></strong></td>
-
<td><input name="dateofloan" type="text" id="dateofloan" /></td>
-
</tr>
-
<tr>
-
<td>Date Due return:</td>
-
<td><input name="datereturn" type="text" id="datereturn" /></td>
-
</tr>
-
<tr>
-
<td>Amount of fine:</td>
-
<td><input name="amountfine" type="text" />
-
</tr>
-
<tr>
-
<td> </td>
-
<td><input type='submit' name='submitt2' value='Register' id='submitt2'></td>
-
</tr>
-
</table>
-
</form>
-
</body>
-
</html>
-
I'm still waiting for answer
please guys I really need a help
Sorry for not being unavailble, but I've been really swamped... Won't have any bandwidth for another couple of days...
My one recommendation though is to rewrite your problem description(s) using short, logical, bullet points and only write a narrative (long description) when it's really warranted.
I realize that english is not your first language, but for those of us who weren't requred to study multiple languages in school, it will allow us to help you more efficiently.
I'd also recommend learning how to use 'use case modeling' and the basis of 'standard flow charting' to assist you in solidifying your application logic & design and to help clear up your thinking when it comes to your programming in general.
An excellent "Use Case Modelling" tool called "Case Complete" is from Serlio software. http://www.casecomplete.com/. You can download it (only on Windows) and use it for 30 days for free during which time you can learn some new techniques. There are a number of free flow charting tools available on the web.
Sorry again, but I'm really burning the "midnight oil" at the moment.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Victor M. |
last post by:
Hello everyone.
I am a newbie to Oracle 8 so please be patient and thanks for your time.
The problem is the above mentioned error. I have two databases
successully created using SQL*Plus 8.03. They are as follows:
Create Table EMPLOYEES
(
FName VARCHAR(15) NOT NULL,
MINIT CHAR,
|
by: Andre |
last post by:
Hello
Can anyone help me translate this from access so that it can work in mssql
(i need to get next value, but cannot use identity as if row is deleted,
another must get new next column number which would be same as deleted one)
Access;
INSERT INTO table
SELECT
(IIF(code<>Null,MAX(code)+1,1) AS code,
0 AS usercode
FROM table
|
by: Philip Boonzaaier |
last post by:
I want to be able to generate SQL statements that will go through a list of
data, effectively row by row, enquire on the database if this exists in the
selected table- If it exists, then the colums must be UPDATED, if not, they
must be INSERTED.
Logically then, I would like to SELECT * FROM <TABLE>
WHERE ....<Values entered here>, and then IF FOUND
UPDATE <TABLE> SET .... <Values entered here> ELSE
INSERT INTO <TABLE> VALUES <Values...
|
by: SuffrinMick |
last post by:
Hi All
I have two tables: tblRecords and tblOptions.
tblRecords consists of RecordID (autonumber), Record (text) and Option
(text record of options chosen) fields
tbloptions consists of OptionID (autonumber) and Option (text) fields.
I want to use a form to add/update the records table.
|
by: trint |
last post by:
This:
string strSQL2 = "INSERT INTO tblTravelDetailMember(memberId, " +
" TravelDetailUplineId, " +
" rankId, " +
" TravelDetailId, " +
" CreatedDateTime, " +
" Operator) " +
"VALUES ('" + insertString2 + "', " +
" '" + insertString3 + "', " +
| | |
by: sonal |
last post by:
Hi all,
I hv started with python just recently... and have been assigned to
make an utility which would be used for data validations...
In short we take up various comma separated data files
for eg: area.txt, school.txt, students.txt.... and so on (ok?!?)
now,
1. area code used in the school.txt must be defined in the area.txt
(Primary key in area => area_code defined in area.txt
& Foreign key on school => area_code defined in...
|
by: nano2k |
last post by:
Hi
Shortly, I keep invoices in a table.
Occasionally, someone will fire the execution of a stored procedure
(SP) that performs several UPDATEs against (potentially) all invoices
OLDER than a date that is supplied to the SP as a parameter.
The SP is usually a lengthy process (it takes at least 30 mins).
The problem is that SQL server 2000 Dev Edition doesn't allow me to
insert new invoices that are "younger", while the SP is executing....
|
by: Wes Groleau |
last post by:
INSERT INTO X ...... ( A, B, C )
INSERT INTO Y ...... ( J, K, L )
If Y has a foreign key M which is the primary key D of X,
is there an easy and/or efficient way to have SQL Server
assign D, and tell us what it is so we can add M to the
list for Y ?
I know I can select D where A, B, C but I wondered about
other tricks.
|
by: jthep |
last post by:
Hi, I'm a newbie at this but how can I populate a table with data from other tables by using INSERT statements? Below is of what I have so far, I have to populate the PERSON_PROFILE table. I've tried using INSERT with SELECT and UPDATE commands which just dont work. I cant input data in one column at a time either since when I created the table, I specified all fields to be NOT NULL.
CREATE TABLE PERSON ( */this table was originally...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
