how do you write it in PHP?

[mivec]

dear all,
in asp...it's written like this:
DBRecordset("ExamCode") = request.form("genexamcode")

        how do u write this line in PHP?

pls advice...thanking you in advance...

[AstroTeg]

request.form("genexamcode") in PHP would be something like: $_POST['genexamcode']

I'm not sure if request.form() is only for POST requests and/or GET requests. PHP sees a difference in these and to handle a GET request, you just use $_GET['genexamcode'] instead.

DBRecordset() is part of an ASP/MS object. I'm assuming its part of ADO's record set object. The assignment here implies you're attempting to store the form value back to the record set. I haven't played with the ADO library for PHP much, but you might check there since you'll probably be pretty comfy with its syntax. Without the ADO library, you'd have to manually build an update query and execute it to update the data in the database.

[mivec]

anyone,
u see....i want to insert these few values into the database:

$eventTitle = $GET["txtEvetitle"];
$eventDate = $GET["txtDate"];
$eventDescription = $_GET["txtaDescription"];

using insert fuction:
$query = "insert into tblNews (title,date,contents) values ('$eventTitle','$eventDate','$eventDescription')";
mysql_query($query) or
die (mysql_error());

is it correct?can anyone pls correct me...i am a newbie in PHP

[Norman_Graham]

Hi Mivec

Looks fine - fire it off and see what happens.

I agree with AstroTeg about the DBRecordset() method. It's simply a DB query in PHP and you can approach the ASP syntax by using ADOdb so that the code would be something like:

$resultset = $this->result;

... or similar. Check out ADOdb if you prefer. You can also write a very simple class to address MySQL only and get the same result. You can probably find loads of ready-made examples either here or at hotscripts.com

Either way, converting this type of ASP to PHP should be unproblematic.

HTH

Norm

[mivec]

norm,
i hv tried the code and it works....but not fully....the data is not entering the database though...there is no error....picture is uploaded but data not entered to the database...let me show u the whole code that i wrote....

code:

<?php
include("dbconnect.php");

$eventTitle = $GET["txtEvetitle"];
$eventDate = $GET["txtDate"];
$eventDescription = $_GET["txtaDescription"];

/$query = "insert into tblNews (title,date,contents) values ('$eventTitle','$eventDate','$eventDescription')";
mysql_query($query) or
die (mysql_error());/

if(!file_exists("catalog")){
mkdir("catalog");
}
$uploaddir = "catalog/";

// check file
checkfile($FILES['file']['tmp_name'],$FILES['file']['size'],$FILES['file']['type'],50000);
$done;

// copy file if no error occured
if(!isset($error)){
$date = date("YmdHis");
$done = copy($FILES['file']['tmp_name'],$uploaddir.$date.'.jpg');

	if ($done){
	echo("done");
}
else{
	echo("not done");
}

}
else{
echo($error[0]);
}
?>

note that the $done thing was just suppose for a testing purposes.....so can u tell me what is wrong?the data doesn't seem to enter the database....

thanx,....

[mivec]

anyone,
need a little help on the code on top.....it doesn't seem to work....pls help....thanks

[Xoid]

Check your code you've commented out the insert code:

i.e.
/$query = "insert into tblNews (title,date,contents) values ('$eventTitle','$eventDate','$eventDescription')";
mysql_query($query) or
die (mysql_error());/

try this instead:

$query = "INSERT INTO tblNews (title,date,contents) VALUES
('".addslashes($eventTitle)."','".addslashes($eventDate)."','".addslashes($eventDescription)."')";