Prikazi cijelu temu 13.06.2017 20:47
Gjoreski Van mreze
Administrator
Registrovan od:02.02.2009
Lokacija:Ohrid Makedonija


Predmet:Re: Php Mssql
Koliki sam ja laik za ovaj HTML i PHP ja mislim da je ovo VRH .

Ovo mi sad radi ovako

PreuzmiIzvorni kôd (PHP):
  1. <?php
  2. $myServer = "ALEKSANDAR\SQLEXPRESS";
  3. $myUser = "";
  4. $myPass = "";
  5. $myDB = "RezervaciiSQL";
  6.  
  7. //connection to the database
  8. $dbhandle = mssql_connect($myServer, $myUser, $myPass)
  9.   or die("Couldn't connect to SQL Server on $myServer");
  10.  
  11. //select a database to work with
  12. $selected = mssql_select_db($myDB, $dbhandle)
  13.   or die("Couldn't open database $myDB");
  14.  
  15. $pNaziv="test";        //$_POST['txtNaziv'];
  16. $pIC="test IC";        //$_POST['txtIC'];
  17. $pDIC="test DIC";      //$_POST['txtDIC'];
  18. $pUlica="Test Ulica";  //$_POST['txtUlica'];
  19.  
  20. $query="INSERT into tblWeb_Prijava([pNaziv],[pIC],[pDIC],[pUlica]) VALUES('$pNaziv','$pIC','$pDIC','$pUlica')";
  21. mssql_query($query,$dbhandle );
  22.  
  23.  
  24.  
  25.  
  26. mssql_close($dbhandle);
  27. ?>

Ali iz HTML nece
PreuzmiIzvorni kôd (PHP):
  1. <?php
  2. $myServer = "ALEKSANDAR\SQLEXPRESS";
  3. $myUser = "";
  4. $myPass = "";
  5. $myDB = "RezervaciiSQL";
  6.  
  7. //connection to the database
  8. $dbhandle = mssql_connect($myServer, $myUser, $myPass)
  9.   or die("Couldn't connect to SQL Server on $myServer");
  10.  
  11. //select a database to work with
  12. $selected = mssql_select_db($myDB, $dbhandle)
  13.   or die("Couldn't open database $myDB");
  14.  
  15. $pNaziv=$_POST['txtNaziv'];
  16. $pIC=$_POST['txtIC'];
  17. $pDIC=$_POST['txtDIC'];
  18. $pUlica=$_POST['txtUlica'];
  19.  
  20. $query="INSERT into tblWeb_Prijava([pNaziv],[pIC],[pDIC],[pUlica]) VALUES('$pNaziv','$pIC','$pDIC','$pUlica')";
  21. mssql_query($query,$dbhandle );
  22.  
  23. mssql_close($dbhandle);
  24. ?>
Evo i HTML a

PreuzmiIzvorni kôd (Text):
  1. <HTML>
  2. <HEAD>
  3. <TITLE>WEB PRIJAVA</TITLE>
  4. </HEAD>
  5. <BODY>
  6. <H2>WEB ZAHTEV ZA PRIJAVA </H2>
  7. <FORM METHOD="POST" ACTION="upisi.php">
  8. <table>
  9. <TR>
  10. <TD>Naziv:</td>
  11. <TD> <INPUT name="txtNaziv" type="text"> </TD>
  12. </TR>
  13.  
  14. <TR>
  15. <TD>IC:</td>
  16. <td> <INPUT name="txtIC" type="text" > </TD>
  17. </TR>
  18.  
  19. <TR>
  20. <TD>DIC:</td>
  21. <td> <INPUT NAME="txtDIC" TYPE="text"> </TD>
  22. </TR>
  23.  
  24. <tr>
  25. <td>Ulica: </td>
  26. <td><INPUT name="txtUlica" type="text"> </td></tr>
  27.  
  28. <BR>
  29. <tr>
  30. <td>
  31. <input name="submit" type="submit" value="Posalji zahtjev">
  32. </td>
  33. </tr>
  34. </table>
  35. </FORM>
  36. </BODY>
  37. </HTML>
Ovaj post je ureden 1 puta. Posljednja izmjena 14.06.2017 02:35 od strane Gjoreski.