Troxy Posted October 21, 2008 Report Share Posted October 21, 2008 Tatad man ir skripts php veidaa,nekur nevareeju atrast tadu primitivu darbibu ka uztaisiit insert ieksh mssql bazes vienu nabaga rindinju kadam nav kads piemeers?vai kaads manuaalis? Link to comment Share on other sites More sharing options...
bubu Posted October 21, 2008 Report Share Posted October 21, 2008 Vai tad parasts INSERT teikums nelīdz? INSERT INTO tabule (lauks1, lauks2) VALUES("value1", "value2") Link to comment Share on other sites More sharing options...
andrisp Posted October 21, 2008 Report Share Posted October 21, 2008 Lūdzu, izmanto pieturzīmes. Ja nemāki komatus izmantot, tad kaut vai sadali visu vienkāršos teikumos. Link to comment Share on other sites More sharing options...
Troxy Posted October 21, 2008 Author Report Share Posted October 21, 2008 Vai tad parasts INSERT teikums nelīdz? $con = mysql_connect("localhost","sa","sa"); if (!$con) { die('Could not connect: ' . mysql_error()); } //izvelas datubazi, kur saglabasies kods mysql_select_db("kods", $con); //ievada datubaze kodu mysql_query("INSERT INTO kods (kods) VALUES ('$randcode')"); mysql_close($con); Link to comment Share on other sites More sharing options...
andrisp Posted October 21, 2008 Report Share Posted October 21, 2008 Tev mysql vai mssql vajag ? Runā par vienu, bet kodu pavisam par citu. Nu - un tas kods nestrādā ? Link to comment Share on other sites More sharing options...
Gints Plivna Posted October 21, 2008 Report Share Posted October 21, 2008 (edited) 1) "sa","sa" un mysql_connect komplektā izskatās traki aizdomīgi. 2) INSERT INTO kods (kods) VALUES ('bla') ir universāla sintakse vismaz 3 dbvs Oracle, MySQL un SQL Server un es domāju, ka vēl milzums citām. Gints Plivna http://datubazes.wordpress.com P.S. Un 3šā lieta: mysql_select_db("kods", $con);//ievada datubaze kodu mysql_query("INSERT INTO kods (kods) Vai tad tiešām datubāzi, tabulu un tās lauku ir jāsauc kods? Vai tad neviena cita vārda vairāk nav? :) Edited October 21, 2008 by Gints Plivna Link to comment Share on other sites More sharing options...
Maris-S Posted October 22, 2008 Report Share Posted October 22, 2008 Lietotājs 'sa" pilnīgi noteikti ir mssql nevis mysql, Tu izmanto nepareizās funkcijas, Tev ir jāizmanto mssql paredzētās funkcijas. Link to comment Share on other sites More sharing options...
Recommended Posts