update mysql database with lots of varabiles in the query

316 Contributor

i need to update a database table using variables in unusual places here are the update statements

Expand|Select|Wrap|Line Numbers

 
mysql_query("UPDATE 'grades' SET '$class' = '$grade' WHERE student='$student'");

mysql_query("UPDATE 'assignments' SET '$class' = '$grade' WHERE student='$student'");

mysql_query("UPDATE 'comments' SET '$class' = '$grade' WHERE student='$student'");

now i was just showed by ron how to recive post stuff and that is where the variables come from so i am not even sure if i am getting the variables from the other page. i did try to display all of those variables but with my php skills the echo options might have their own problems so here is the rest of the code

Expand|Select|Wrap|Line Numbers

 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<title>Untitled Document</title>

<?
 
session_start(); // Use session variable on this page. This function must put on the top of page.

if(!session_is_registered("teacher")){ // if session variable "username" does not exist.

header("location:login.php"); // Re-direct to index.php

}
 
?>

<?

// Connect database.

$host="localhost"; // Host name.

$db_user="rcadmin"; // MySQL username.

$db_password="nsds2004"; // MySQL password.

$database="RCA"; // Database name.

$RCA = mysql_pconnect($host, $db_user, $db_password) or trigger_error(mysql_error(),E_USER_ERROR);

 mysql_select_db($database, $RCA);

 $login=$_POST('login');

 $class=$_POST('job_select');

 $grade=$_POST('job_select');

 $assignment=$_POST('job_select');

 $comments=$_POST('job_select');

//this section updates the database

$grade = "grade";

$assignments = "assignments";

$comments = "comments";

$student = "student";

$class = "class";

if (isset($_POST['grade']))

  $grade = strip_tags($_POST['grade']);

if (isset($_POST['assigments']))

  $assignments = strip_tags($_POST['assignments']);

if (isset($_POST['comments']))

  $comments = strip_tags($_POST['comments']);

if (isset($_POST['student']))

  $student = strip_tags($_POST['student']);

if (isset($_POST['classs']))

  $class = strip_tags($_POST['classs']);
 
mysql_query("UPDATE 'grades' SET $class = '$grade' WHERE student='$student'");

mysql_query("UPDATE assignments SET '$class' = '$grade' WHERE student='$student'");

mysql_query("UPDATE comments SET $class = '$grade' WHERE student='$student'");

?>

 </head>
 
<body>

<?

    echo $grade, "<br />";

    echo $assignments , "<br />";

    echo $comments , "<br />";

    echo $student , "<br />";

    echo $class , "<br />";
 
?>

</body>

</html>

Jan 17 '07 #1

Subscribe Reply

1987

tolkienarda

316

Contributor

never mind i am stupid

Jan 18 '07 #2

Similar topics

10548

PHP/MySQL "UPDATE" question

by: Mark | last post by:

A beginner in this area, I have been able to read a record from a MySQL database and populate an HTML form (wow!). Now, my goal is to allow the user to edit the contents of the form and then update the record in MySQL. The problem is, as soon as the "Update" button (type="submit") is pressed, all of the data disappear from the form. How...

PHP

5273

How can I retrieve, edit, and update text?

by: Bob Kaku | last post by:

I'm trying to retrieve a text value from a MySQL database, put it into an updateable form, allow edits, and send back the edited text back into the MySQL database. I've been able to successfully retrieve the text and put it into the editable form, using htmlspecialchars function. But, I can't find a way of accepting the edited text and...

PHP

1798

php or mysql

by: alex | last post by:

Hi. I am making a page that lots of data on the first page that I want links displayed in a random order. If lots of people are looking at it, would I be better using a page that uses arrays and shuffle(), or would I be ok to use mysql. If there are over a hundred visitors a day, would mysql be making the site slow? I don't know much about...

PHP

11453

update mysql blob with another blob using php

by: sime | last post by:

Hi, I have a blob field in a mysql database table. I want to copy a blob from one record to another. I am having trouble transferring the data via a php variable. Maybe I need to addslashes or convert to Hex or something. I've tried a few things but can't quite get it. Here is simplified code. mysql_select_db($dbname, $connection);

PHP

3161

server notify client to update MySQL table

by: whitemoss | last post by:

Hi, I've made some changes to my coding..but unfortunately, there were errors when compiling it..dunno how to solve it..hope anyone can help me...the errors: client.c: In function senddata: client.c:147: error: incompatible implicit declaration of function UpdateStatus client.c:37: error: previous implicit declaration of UpdateStatus was...

C / C++

2718

Makeing multiple MySQL queries in a single query.

by: Daz | last post by:

Hi. I am trying to select data from two separate MySQL tables, where I cannot use join, but when I put the two select queries into a single query, I get an error telling me to check my syntax. Both of the queries work fine when I use them to query the MySQL server directly. My guess is that the MySQL extension only expects a single resource...

PHP

2668

have to "actions" or run two types of queries (select,and update) on the same form?

by: eholz1 | last post by:

Hello PHP programmers. I had a brilliant idea on one of my pages that selects some data from my mysql database. I first set the page up to display some info and an image, just one item, with a row of data, etc. then I thought it would be nice to do a select, and perhaps an update (the title of the image) on the same page.

PHP

3411

php vs mysql speed

by: Ciaran | last post by:

Hi All, Is it faster to have mySql look up as much data as possible in one complex query or to have php do all the complex processing and submit lots of simple queries to the mysql database? Cheers, Ciarán

PHP

4273

PHP page won't update mysql record

by: stantron | last post by:

Setup: I only have one database with one table in it. The first page has a form that adds a record (w/ 6 fields in it) to the mySQL database's lone table via PHP. This works fine. I also have a PHP table that displays all records in my database on this same page. This too works fine. I have my table set up so that there is a 7th field, called...

PHP

7920

What is ONU?

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...

General

7849

Changing the language in Windows 10

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...

Windows Server

8347

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

7973

The easy way to turn off automatic updates for Windows 10/11

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...

Windows Server

5718

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...

Microsoft Access / VBA

5394

Couldn’t get equations in html when convert word .docx file to html file in C#.

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...

C# / C Sharp

3844

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

3879

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2358

transfer the data from one system to another through ip address

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

C# / C Sharp