Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
NEED ASP CODE
- Thread starter LinuxGuy
- Start date
what do u neeed? an insert code?
insertion of two fields into one table using 1 ASP page
All the best!
> need more info?
:: don't click HERE ::
Code:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
Dim MM_MYSQL_STRING
MM_MYSQL_STRING = "driver={MySQL ODBC 3.51 Driver}; database=DB_NAME;server=server_NAME;uid=user;pwd=pass;option=16386;"
%>
<%
if(Request.Form("tfUSERNAME") <> "") then Command1__varUser = Request.Form("tfUSERNAME")
if(Request.Form("tfNAME") <> "") then Command1__varName = Request.Form("tfNAME")
%>
<%
set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_MYSQL_STRING
Command1.CommandText = "INSERT INTO database_name.table_name(Field1,Field2) VALUES ('" + Replace(Command1__varUser, "'", "''") + "','" + Replace(Command1__varName, "'", "''") + "') "
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()
set Command1= Nothing
%>
<html>
<head>
<title>MySQL Insert </title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form action="MySQL1.asp" name="form1">
<p>UserName:
<input name="tfUSERNAME" type="text" id="tfUSERNAME">
</p>
<p>Name:
<input name="tfNAME" type="text" id="tfNAME">
</p>
<p>
<input type="submit" name="Submit" value="Submit">
<input type="reset" name="Submit2" value="Reset">
</p>
</form>
</body>
</html>insertion of two fields into one table using 1 ASP page
All the best!
> need more info?
:: don't click HERE ::
"so you need all that code!!!???"
--> I am not looking to start a thread on ASP vs. PHP
ALL the code above is not necessary to perform an acutal SQL insert
anyhow.....take it or leave it!
> need more info?
:: don't click HERE ::
--> I am not looking to start a thread on ASP vs. PHP
ALL the code above is not necessary to perform an acutal SQL insert
anyhow.....take it or leave it!
> need more info?
:: don't click HERE ::
sleipnir214
Programmer
Chacalinc:
Play nice. Once you remove all the extraneous openings and closings of the ASP tags and then convert the script to equivalent PHP, the PHP script only around 6 lines shorter. And most of that's probably fixed overhead that would not scale for a longer script.
Anyway, you missed the central issue. The reason to choose PHP over ASP when using MySQL is that PHP uses MySQL-native communications libraries, versus ASP and ODBC. The ODBC subsystem can really slow down database access.
Want the best answers? Ask the best questions: TANSTAAFL!!
Play nice. Once you remove all the extraneous openings and closings of the ASP tags and then convert the script to equivalent PHP, the PHP script only around 6 lines shorter. And most of that's probably fixed overhead that would not scale for a longer script.
Anyway, you missed the central issue. The reason to choose PHP over ASP when using MySQL is that PHP uses MySQL-native communications libraries, versus ASP and ODBC. The ODBC subsystem can really slow down database access.
Want the best answers? Ask the best questions: TANSTAAFL!!
I agree with you sleipnir, reviewing the code, it's not too much different.
In addition, as i said to lebisol, I don't want to start a thread on ASP vs. PHP. But, that I love of PHP is portability betweend servers (Win/Ux).
Talking about this... how is the comuncation between PHP and Oracle? via ODBC or like with MySQL?
(sorry for use this thread, but this will be the only question).
In addition, as i said to lebisol, I don't want to start a thread on ASP vs. PHP. But, that I love of PHP is portability betweend servers (Win/Ux).
Talking about this... how is the comuncation between PHP and Oracle? via ODBC or like with MySQL?
(sorry for use this thread, but this will be the only question).
it is all good!I am bit tired of posts this vs. that.....but what the sleipnir214 pointed out is where it all matters (besides the DB design skills)
ODBC was never really intened to be used on the web sooo as said performance sufferes in this combo
The way I see it...it depends on the project and "customers"
I agree that PHP + MySQL is the way to go...
All the best!
> need more info?
:: don't click HERE ::
sleipnir214
Programmer
Chacalinc:
PHP can use native communications libraries to communicate with the DB++, FrontBase, Informix, Interbase, Ingres II, SQL Server, mSQL, MySQL, Oracle, and PostgreSQL database servers. Outside of that, you have to use ODBC.
Keep in mind, however, that a lot of the libraries aren't bundled with PHP because they are proprietary.
Want the best answers? Ask the best questions: TANSTAAFL!!
PHP can use native communications libraries to communicate with the DB++, FrontBase, Informix, Interbase, Ingres II, SQL Server, mSQL, MySQL, Oracle, and PostgreSQL database servers. Outside of that, you have to use ODBC.
Keep in mind, however, that a lot of the libraries aren't bundled with PHP because they are proprietary.
Want the best answers? Ask the best questions: TANSTAAFL!!
oh yes, I agree with you lebisol with "depend"... in fact, it's not clever to use Oracle with PHP if you have IAS.
My question is not pointing out whether PHP or ASP is better with Oracle, just curious about PHP with Oracle. If I want to do something with Oracle in Web environment, I will use IAS, and client/server it could be better VB or some Visual...
Cheers.
My question is not pointing out whether PHP or ASP is better with Oracle, just curious about PHP with Oracle. If I want to do something with Oracle in Web environment, I will use IAS, and client/server it could be better VB or some Visual...
Cheers.
sleipnir214
Programmer
"IAS"?
Want the best answers? Ask the best questions: TANSTAAFL!!
Want the best answers? Ask the best questions: TANSTAAFL!!
- Status
