Jump to content

wanbinn

Members
  • Posts

    6
  • Joined

  • Last visited

wanbinn's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. good day,i m on an assignment where i was required to link a web based form and mysql.requirements:1. data need to be entered into the database using the form created.2. a page to show what has been keyed in into the database.3. using dreamweaver and asp vbscripthowever i have difficulty with the code.may be someone can show me how to program this thing. any help will be very much appreciated.(i've done with my database)thank you.
  2. wanbinn

    i need a form..pls

    good day,i m on an assignment where i was required to link a web based form and mysql.requirements: 1. data need to be entered into the database using the form created. 2. a page to show what has been keyed in into the database. 3. using dreamweaver and asp vbscripthowever i have difficulty with the code.may be someone can show me how to program this thing. any help will be very much appreciated.(i've done with my database)thank you.
  3. i am trying to connect a form with mysql using IIS server. however i failed and the internet browser indicates that there is an error in my code(where i highlighted).database name:human_diseasestable name:collectorcolumns:collectorID, collectorname, diseaseID, collectiondate,locationbelow is the code i hav written,pls help.thanks.*************************************************************<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /><title>Untitled Document</title><style type="text/css"><!--.style1 {font-size: 56px}.style2 {font-size: 24px; }.style3 {font-size: 14px; }--></style><script LANGUAGE="JavaScript">function goToURL() { window.location = "/addcollector.asp"; }</script></head><% Set mConn = Server.CreateObject("ADODB.Connection") Set mCmd = Server.CreateObject("ADODB.Command") Set sql = Server.CreateObject("ADODB.Recordset") Set sql2 = Server.CreateObject("ADODB.Recordset") Set sql3 = Server.CreateObject("ADODB.Recordset") mConn.ConnectionString = "server=127.0.0.1;driver=MySQL;db=human_diseases;uid=root" mConn.Open%><body><h1 align="center" class="style1">Human Diseases</h1><p align="center">Current Record(s) </p><%collectorid=request.form("Collector ID")collectorname=request.form("Collector Name")diseaseid=request.form("Disease ID")collectiondate=request.form("Collection Date")location=request.form("Location")mCmd.ActiveConnection = mConn mCmd.CommandType = 1 'Text' mCmd.CommandText = "INSERT INTO collector (collectorID, collectorname, diseaseID, collectiondate,location) VALUES ('"&collectorid&"','"&collectorname&"','"&diseaseid&"','"&collectiondate&"','"&location&"')" sql.Open mCmd,,1,1 curreccollector() %> <%function curreccollector%><div align="center"> <table width="674" border="1"> <tr bgcolor="#CCFF66"> <td width="28">No.</td> <td width="98">Collector ID </td> <td width="189">Collector Name </td> <td width="105">Disease ID </td> <td width="105">Collection Date </td> <td width="109">Location</td> </tr> <%mCmd.ActiveConnection = mConn mCmd.CommandType = 1 'Text' mCmd.CommandText = "SELECT * FROM collector" 'Opening the record set based on the Query from mCmd' sql2.Open mCmd,,1,1 num=1 Do Until sql2.EOF collectorid=sql2.Fields("collectorID") collectorname=sql2.Fields("collectorname") diseaseid=sql2.Fields("diseaseID") collectiondate=sql2.fields("collectiondate") location=sql2.fields("location") %> <tr bgcolor="#339999"> <td><%=num%></td> <td><%=collectorid%></td> <td><%=collectorname%></td> <td><%=diseaseid%></td> <td><%=collectiondate%></td> <td><%=location%></td> </tr> <% sql2.MoveNext num=num+1 Loop sql2.Close %> </table> <% mCmd.CommandText = "SELECT COUNT(*) as vol FROM collector" sql3.Open mCmd,,1,1 sql3.movefirst do while not sql3.eof x=sql3("vol").value sql3.movenext loop %> Current record : <%=x%> </div></td> </tr> <% End Function%> </div><p align="center"> </p> <p align="center"><input type="button" name="Button" value="Add Record" onClick="goToURL()"> <input type="button" name="Button" value="Exit Window" onclick="java script:window.close()"> </p></body></html>
  4. good day, i have installed apache server and mysql server. but error occur when i tried to run mysql.this is the error message:connection failed:1251- client does not support authentification protocol requested by server;consider upgrading mysql clientcan anyone please tell me what happen and how i can overcome this problem?thank you.
  5. Hi, good day,Can someone please tell me how to create a page where one can posts their pictures (something like friendster where users post on their picture from files)?thankz..
  6. good day, I am trying to develop a web site where students are allowed to post their university's or institution's activities. here is my question:1. when information are posted, how am i going to handle those post? am i going to receive information from them and post the information on my own?( what if there are plenty of post?) or should i use some kind of software to help me in handling it?
×
×
  • Create New...