	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

07/03/2009 at 04:27PM PDT, ID: 24543237

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.8

insert data to three tables using one html form

Asked by colin0292 in PHP and Databases, MySQL Server, PHP Scripting Language

hey
im using phpmyadmin (MyISAM storage engine) and i have table called
prof_rating which includes
-comm_id
-prof_id ======> this field should link to another table called prof
-rate
-comment

prof table includes
-prof_id
-prof_name
-dept
-school_id ======> this field should link to another table called school

school table includes
-school_id
-school_name
-state
__________________________________________________
my question here: in my html form where any user could add review,this means i have one form that inserted into three different tables, how should i write the insert statement??
i try to insert data but got some error msg that says" Incorrect integer value: '' for column 'prof_id' at row 1"
also i have to check if the prof_name already exists then add the comment and rate.

i'm not sure if im doing it the right way coz of that msg besides my tables didn't get any data.
plz see the html form and php code

help plz

View the Solution FREE for 30 Days

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:

           
           
             ########HTML FORM#############
<form action="rate.php" method="post">
Professor name:
	<br>
<input type="text" name="prof_name">
	<br>
School/University:
	<br>
<input type="text" name="school_name">
	<br>
Department:
	<br> 
<input type="text" name="dept">
	<br>
rate 1-5:
<select name="rate">
    <option value="1">1</option>
    <option value="2">2</option>
    <option value="3">3</option>
    <option value="4">4</option>
    <option value="5">5</option>
</select>
	<br><br>
Your comments:<BR>
<TEXTAREA NAME="comment" COLS=40 ROWS=6></TEXTAREA>
	<br><br>
	<input type="submit" value="Submit">
	<input type="reset" value="Reset">
</form>
 
______________________PHP __________________________________
<?php
include 'config.php';
include 'opendb.php';
/* Check all form inputs using check_input function */
$prof_name   = check_input($_POST['prof_name'], "hey you..... Enter professor name.");
$school_name = check_input($_POST['school_name'], "Enter your school name.");
$dept		 = check_input($_POST['dept'], "Enter the department.");
$rate		 = check_input($_POST['rate']);
$comment     = check_input($_POST['comment'], "Enter your comment.");
 
 
$RSCount = mysql_query("SELECT COUNT(*) AS TotalRecords FROM prof WHERE prof_name = '{$_POST['prof_name']}'");
$CountRow = mysql_fetch_object($RSCount);
if ($CountRow->TotalRecords > 0)
{
	$RSProf = mysql_query("SELECT prof_id FROM prof WHERE prof_name = '{$_POST['prof_name']}'");
	$ProfRow = mysql_fetch_object($RSProf);
	$ProfIDToUpdate = $ProfRow->prof_id;
 
	$updateQuery = "UPDATE prof_rating SET rating = '{$_POST['rate']}' WHERE prof_id = '{$ProfIDToUpdate}'";
	@mysql_query($updateQuery) or die(mysql_error());
 
	$updateQuery = "UPDATE prof SET dept = '{$_POST['dept']}', school_id = '{$_POST['school_name']}' WHERE prof_id = '{$ProfIDToUpdate}'";
	@mysql_query($updateQuery) or die(mysql_error());
}
else
{
	$data= "INSERT INTO prof VALUES ('', '{$_POST['school_name']}', '{$_POST['dept']}', '{$_POST['prof_name']}')";
	@mysql_query($data) or die(mysql_error());
	$prof_id = mysql_insert_id();
	
	$todata= "INSERT INTO prof_rating VALUES ('', '{$prof_id}', '{$_POST['rate']}', '{$_POST['comment']}')";
	@mysql_query($todata) or die(mysql_error());
}
 
echo "<TD valign='top'><br /><center><b>You successed!";
echo "<br>";
 
 
 
/* Functions we used */
function check_input($data, $problem='')
{
    $data = trim($data);
    $data = stripslashes($data);
    /*$data = htmlspecialchars($data);*/
    if ($problem && strlen($data) == 0)
    {
        show_error($problem);
    }
    return $data;
}
 
function show_error($myError)
{
?>
    <html>
    <body>
 
    <b>Please correct the following error:</b><br />
    <?php echo $myError; ?>
 
    </body>
    </html>
<?php
exit();
}
?>

           
         

20091028-EE-VQP-87 - Hierarchy / EE_QW_3_20090701_SELECT_ZONES

1. Ray_Pas... 2,056,571
2. cxr 1,232,724
3. hielo 347,424
4. angelIII 317,162
5. al3cs12 285,771
6. Michael701 280,511
7. bportlock 257,437
8. gr8gonzo 246,267
9. profya 229,051
10. logudotcom 219,914
11. wuff1uk 213,320
12. BrianMM 211,960
13. thehagman 142,302
14. gamebits 141,942
15. shobinsun 138,579
16. RQuadling 130,730
17. Mahdii7 121,650
18. mplungjan 119,450
19. Hube02 115,519
20. routinet 102,525
21. ddrudik 101,262
22. agamal 100,643
23. fibo 98,578
24. ycTIN 94,812
25. TerryAtO... 93,365

1. Ray_Pas... 2,759,183
2. hernst42 2,557,533
3. hielo 2,363,165
4. Roonaan 2,131,418
5. cxr 1,472,454
6. angelIII 1,301,795
7. TeRReF 1,246,909
8. Squinky 1,065,477
9. Diablo84 1,046,676
10. RQuadling 953,974
11. glcummins 763,827
12. steelseth12 654,695
13. logudotcom 638,873
14. snoyes_jw 599,563
15. bportlock 587,696
16. yodercm 544,631
17. Michael701 542,692
18. routinet 542,090
19. gamebits 517,885
20. Zyloch 496,930
21. ddrudik 489,665
22. b0lsc0tt 476,997
23. nizsmo 470,054
24. ldbkutty 468,085
25. Batalf 452,611

insert data to three tables using one html form

Asked by colin0292 in PHP and Databases, MySQL Server, PHP Scripting Language

About this solution