Jump to content

Matar

Members
  • Posts

    102
  • Joined

  • Last visited

Everything posted by Matar

  1. Matar

    encrypt data by md5

    hi justsomeguy its long time so i must make an encryption algorithem and decryption algorithem ???!!!or what i can do to solve this problem ?anyway i need to save encrypted data and when request decrypte this data thank you matar
  2. hi all iam trying to add jpg picture to sqlserver2005 database with vb.net2005 interface . so the question is sqlserver can store the image it self in the database ??i dont need to save the path of image . matar
  3. Matar

    encrypt data by md5

    hi man no i dont mean that if i save md5("dog") in the database i want when the user request this value to show it without md5 encryption . thank you
  4. Matar

    encrypt data by md5

    hi all i work with project thats need encrypt the data using md5 when insert the data to the database "i make this "but i need anthor thing i need when the user request the data from the database ,the data showen without md5 ??who i can make this ??matar
  5. Matar

    Login Problem

    hi all thank you for replay i make all thing you said and the problem is still the code ***<?phpif(!isset($user)||!isset($pass)){echo "error1";}elseif(empty($user)||empty($pass)){echo "error2";}else{$user = $_POST['user'];$pass = $_POST['pass'];$con = mysql_connect("localhost","root","");mysql_select_db("log", $con);$sql = mysql_query("select * from info where username = '$user' AND password = '$pass'",$con);$row = mysql_num_rows($sql);if($row > 0){ while($row = mysql_fetch_array($sql)){ session_start(); session_register('user'); echo "welecom $user <br />";} } else{ echo "Incorrect Login";}}?>****can any one copy and paste this script and try it db name is logtable name is info the field in the database username char(20)password char(20) ******i was try this code without "where" and its work like this select * from info but when is user select * from info where user = '$user' and password = '$pass' not work **** thank u all matar
  6. Matar

    Login Problem

    hi this script is simple example ... i don't care about mysql_connect parmeterbecause i work on local host The problem is when i using where cluse when i edit select statement to "select * from info " it is work , but when i using where the script work as empty table although i fill it with users data .
  7. Matar

    Login Problem

    hi all i make a login script but i have a problemwhen i login with my user and password the script show me invalid login but my login info is corret !!!!this is the code ****<?phpif(!isset($user)||!isset($pass)){echo "error1";}elseif(empty($user)||empty($pass)){echo "error2";}else{$user = ($_POST['user']);$pass = ($_POST['pass']);$con = mysql_connect("localhost");mysql_select_db("log", $con);$sql = mysql_query("select * from info where username = '$user' AND password = '$pass'",$con);$row = mysql_num_rows($sql);if($row > 0){ while($row = mysql_fetch_array($sql)){ session_start(); session_register('user'); echo "welecom $user <br />";} } else{ echo "Incorrect Login";}}?>
  8. Matar

    Web Spider

    hi thank you man ,,, but the link not work " not authroized to view this page " matar
  9. I think this link will help you http://particletree.com/features/degradabl...orm-validation/visit it matar
  10. Matar

    Web Spider

    hi any one know about web spider thats used in search enginei am trying to make a search engine using php and mysql but i don't know anything about web spider any have a script to get the page content for exmaple small program when i give it the url , he will get the metatag information or get the h1 text ..etc kindly regardsmatar
  11. Matar

    vb.net with access

    hi am sorry for this late i make jesh but the data also added just to the dataset not to the orginal database ... pulpfiction ... there is no error the poroblem is that the data i add to the database via vb.net interface just inserted to the dataset so when i close the application no data added to orginal database ... thank you all matar
  12. Matar

    vb.net with access

    hi am trying to insert a data into access database with vb.net interface (2005)the porplem is the adding is completed succeful in the dataset only not in the real database this is the code **** Dim conn As New OleDb.OleDbConnection("Provider=Microsoft.jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "\Nwind.mdb") Dim sql As String = String.Empty sql = "INSERT INTO Categories (CategoryID,CategoryName,Description)" & "values('" & txtid.Text & "','" & txtname.Text & "','" & txtdes.Text & "')" conn.Open() Dim command As New OleDb.OleDbCommand(sql, conn) command.ExecuteNonQuery() conn.Close()*********what's UP ?
  13. Matar

    Exam Script

    hi all i am working with vb6 to make an mulitble choice exam the qustions and answers are saved in access database and i show it in labeles and i put optionsbuttons to select the truth answer how i can know which option he select and how i will calc the true answers and the false ???
  14. hi i try your comment and still the same error this is the code<%@ Import Namespace="System.Data.SqlClient" %><script runat =server > Sub page_load() Dim oSQLConn As SqlConnection = New SqlConnection() oSQLConn.ConnectionString = "Data Source=(local);Initial Catalog=pubs;User ID=sa;password=secret;Trusted_Connection=yes;" oSQLConn.Open() End Sub</script>this is the error :An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
  15. hi if i understand you this link will help you to change the page text and some effects without re ftp it http://www.fckeditor.net/this link for the desgin i donoo if you dont know about hotscript its a huge site contaian thounds of script and theres asp.net user mangment scripts .www.hotscripts.comMaTaR
  16. iam trying to connect asp.net with sql server database ,but there are a problem firstly this my code <%@ Import Namespace="System.Data.SqlClient" %><script Runat="Server">Sub Page_Load Dim conPubs As SqlConnection conPubs = New SqlConnection( "Server=localhost;uid=sa;pwd=secret;database=pubs" ) conPubs.Open()End Sub</Script>and this is the error :An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)i setup the surface area to allow the remote connection with tcp/ip and still the same error ?plz help
  17. hi i want to know how to display a data thats stored in access database wiht editing control add,delete,updatedo u have any idea about that ??thx
  18. hi pulpfiction its long time ,,, i do it like your comment and still errors ****i will i ask you if you know about asp.net datagrid if you know plz post me a replay ...****best wishesMaTaR
  19. hi i solve this error the error was because of a resrved word in the sql command this word is resreved in the ado and they are ( name , section ,user)so to a void this duplication we must put the field name between []so the code will be like that ***Sub ins(ByVal obj As Object, ByVal e As EventArgs) Dim dbconn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=" & Server.MapPath("db1.mdb")) Dim cmd As New System.Data.OleDb.OleDbCommand cmd.CommandType = System.Data.CommandType.Text cmd.CommandText = "INSERT INTO vic([username],[pass],[firstname],[section],[address]) VALUES('" & username.Text & "','" & pass.Text & "','" & firstname.Text & "','" & sec.Text & "','" & adr.Text & "')" cmd.Connection = dbconn dbconn.Open() cmd.ExecuteNonQuery() dbconn.Close()****its work very will thank you frinds*****but know i am trying to make a delete button this is the code *****Sub del(ByVal obj As Object, ByVal e As EventArgs) Dim dbconn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=" & Server.MapPath("db1.mdb")) Dim cmd As New System.Data.OleDb.OleDbCommand cmd.CommandType = System.Data.CommandType.Text cmd.CommandText = "DELETE * FROM vic where [username] = '"&username.text&"'" cmd.Connection = dbconn dbconn.Open() cmd.ExecuteNonQuery() dbconn.Close()******in the runtime its add a recored not delete what going on ?
  20. hi this is my code ******Sub ins(ByVal obj As Object, ByVal e As EventArgs) Dim dbconn, sql, dbcomm dbconn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=" & Server.MapPath("db1.mdb")) dbconn.Open() sql = "INSERT INTO vic (user,pass,name,section,address) VALUES('" & use.Text & "','" & pass.Text & "','" & name.Text & "','" & sec.Text & "','" & adr.Text & "')" dbcomm = New OleDbCommand(sql, dbconn) dbcomm.ExecuteNonQuery() dbconn.Close()******this is the error : Syntax error in INSERT INTO statement********what is that ?
  21. hi thank u i miss this line dbcomm.Connection = dbconn;but i put and the script still have a proplem i donoo what is the proplem ?
  22. hi firstly this my code *********Dim dbconn, sql, dbread, dbcomm dbconn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=" & Server.MapPath("db1.mdb")) dbconn.Open() sql = "INSERT INTO vic (user,pass,name,section,address) VALUES('" & use.Text & "','" & pass.Text & "','" & name.Text & "','" & sec.Text & "','" & adr.Text & "')" dbread = dbcomm.ExecuteReader() vic.DataSource = dbread vic.DataBind() dbread.Close() dbconn.Close()*****its still problem ,, Insert syatex error !!!!!!!***so can you slove this problem please .
  23. hi i am trying to insert a values into access database by asp.net the user will fill the field and when click add it will keep in the db but there are some errors in insert values this is the script <script runat="server"> Sub ins(ByVal obj As Object, ByVal e As EventArgs) Dim dbconn, sql, dbcomm, dbread dbconn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" & Server.MapPath("db1.mdb")) dbconn.Open() sql = "INSERT INTO vic (name, section,age,address) VALUE('name.text', 'section.text','age.text','address.text')" dbcomm = New OleDbCommand(sql, dbconn) dbread = dbcomm.ExecuteReader() vic.DataSource = dbread vic.DataBind() dbread.Close() dbconn.Close()end sub any one can slove this proplem ?
  24. hi thank you all issues is resloves
  25. hi im trying to connect an access database with asp.net there are no error but win i run the page i see a blank page , this is the script <%@ Import Namespace="System.Data.OleDb" %><script runat="server">sub Page_Loaddim dbconn,sql,dbcomm,dbread dbconn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source = " & "C:\Inetpub\wwwroot\webdata\log.mdb")dbconn.Open() sql = "SELECT * FROM stu"dbcomm=New OleDbCommand(sql,dbconn)dbread=dbcomm.ExecuteReader()end sub</script><html><body><form id="Form1" runat="server"><asp:Repeater id="customers" runat="server"><HeaderTemplate><table border="1" width="100%"><tr><th>user</th><th>pass</th></tr></HeaderTemplate><ItemTemplate><tr><td><%#Container.DataItem("user")%></td><td><%#Container.DataItem("pass")%></td></tr></ItemTemplate><FooterTemplate></table></FooterTemplate></asp:Repeater></form></body></html>why ??
×
×
  • Create New...