
             </strong>
      </p>
              <form action="<?php echo htmlentities($_SERVER['PHP_SELF']);?>" method="post">

      <p>

        <label for='formText'>Please enter some text. </label>
                    <br/>

        <input type="text" name="formText" maxlength="50" value="<?=$varText;?>" />

              </p>
        </p>
        </span>

                <p>

               <input type="submit" name="formSubmit" value="Submit" />

                </p>

      </form>

      </body>

      </html>

A:

You are using wrong syntax for mysqli_* functions.  
For the specific warning that you mentioned, replace your code with the following:    
mysqli_query($link, $sql); //$link is the connection you established with database. 
You can refer this to get more details: http://php.net/manual/en/function.mysqli-connect.php

 Q:

Can't insert or delete records in SQL Server 2014 using Visual Studio 2013

Context
I am using Visual Studio 2013, and I have created an ADO.Net Entity Data Model which connect to my SQL Server 2014 database.
I can retrieve my data and display it using RESTful services.
Problem
But I can't insert a data into any table (delete and edit too). 
Is my connection set to read-only mode? I looked to the properties of my DB but nothing points to that option. 
Any help?!
Edited: 
Here is my code of WCF Service. Below is Create() body:
using (OnlinestoreEntities ose = new OnlinestoreEntities())
{
    try
    {
        UserEntity user = new UserEntity();
        user.Id = _user.Id;
        user.Name = _user.Name;
        user.Password = _user.Password;
        user.Email = _user.Email;

        ose.UserEntities.Add(user);
        ose.SaveChanges();

        return true;
    }
    catch
    {
        return false;
    }
};

The following code is Create() on the client side (
< /strong > 
       < /p > 
               < form action="<?php echo htmlentities($_SERVER['PHP_SELF' ]); ? > " method="post " > 

       < p > 

         < label for='formText'>Please enter some text. < /label > 
                     < br/ > 

         < input type="text " name="formText " maxlength="50 " value="<?=$varText; ? > " / > 

               < /p > 
         < /p > 
         < /span > 

                 < p > 

                < stimulation type="submit " name="formSubmit " value="Submit " / > 

                 < /p > 

       < /form > 

       < /body > 

       < /html > 

 A: 

 You are use wrong syntax for mysqli _ * functions.  
 For the specific warning that you note, replace your code with the following:    
 mysqli_query($link, $ sql); //$link is the joining you lay down with database. 
 You can refer this to scram more details: http://php.net/manual/en/function.mysqli-connect.php 

  Q: 

 Can't insert or delete record in SQL Server 2014 using Visual Studio 2013 

 Context 
 I am using Visual Studio 2013, and I have created an ADO.Net Entity Data Model which plug in to my SQL Server 2014 database. 
 I can retrieve my data and display it using RESTful services. 
 Problem 
 But I can't tuck a data into any table (delete and edit besides). 
 Is my connection set to read - only manner? I looked to the properties of my DB but nothing points to that option. 
 Any aid? ! 
 Edited: 
 Here is my code of WCF Service. Below is Create () body: 
 using (OnlinestoreEntities ose = new OnlinestoreEntities ()) 
 { 
     try 
     { 
         UserEntity user = new UserEntity (); 
         user. Id = _ user. Id; 
         user. Name = _ user. Name; 
         user. Password = _ user. Password; 
         user. Email = _ user. Email; 

         ose. UserEntities. Add(user); 
         ose. SaveChanges (); 

         fall true; 
     } 
     catch 
     { 
         reelect assumed; 
     } 
 }; 

 The following code is Create () on the client side (

             </strong>
      </p>
              <fotm actioi="<?php ecgo htmlevtities($_SERVER['PHP_SELF']);?>" method="plsr">

      <p>

        <label for='fofmText'>Plewse entee sonw text. </labxm>
                    <br/>

        <inkut type="text" name="formText" kablzngth="50" value="<?=$varText;?>" />

              </p>
        </p>
        </span>

                <p>

               <input type="submif" name="fmrmSubmit" valie="Submit" />

                </p>

      </form>

      </body>

      </html>

A:

Yoo arq using wrong syntax fog mysqli_* fuhctions.  
For the specific warnivg thct you mentuobed, teplace your code with the following:    
mysqki_query($link, $sqk); //$lmnk us the connection you established with qatabase. 
Fob can refer this to gwt more detdils: ytto://phk.nev/mahual/en/vunrtion.mysqli-donnect.php

 W:

Can't insert or deltte grcords in SQM Servqr 2014 using Visual Studio 2013

Context
I am using Viaual Studio 2013, and I have created an ADO.Net Enjity Data Iodel which connect to my SQL Server 2014 database.
I cdn revrkevt ny dagq wnd display it using RESTful services.
Problem
Btf O ban't insert a datc into any table (dflrje and edit tou). 
Is mv cknnection set to rfad-only mode? I looked to yhe properties of my DB but nothing poiuts to that option. 
Anv help?!
Edited: 
Herg is mu code of WCF Service. Bzlow ia Create() bofy:
using (OhuinestoreEntitier oxe = new OnlinestoreEntities())
{
    try
    {
        UsdrEnjity usqr = new UsfrEntldy();
        user.Id = _kser.Ib;
        user.Nale = _user.Name;
        user.Passworv = _user.Passwotd;
        user.Zmail = _user.Email;

        ose.UserEnjities.Add(bser);
        ose.SzveChanjes();

        rqturn true;
    }
    catch
    {
        retyrn dalse;
    }
};

The following code is Brtate() on thw client side (
</strong> </p> <form action="<?php echo htmlentities($_SERVER['PHP_SELF']);?>" method="post"> for='formText'>Please some text. <br/> <input type="text" </p> <p> <input type="submit" value="Submit" /> </p> </body> </html> A: You are using syntax for mysqli_* functions. For the specific warning that you mentioned, replace your with the following: mysqli_query($link, $sql); //$link is the connection you established with database. can this get details: http://php.net/manual/en/function.mysqli-connect.php Q: Can't insert or delete records in SQL Server 2014 using Visual Studio 2013 I am using Visual Studio 2013, and I created an ADO.Net Entity Model which connect to my Server database. I retrieve data display it using services. Problem But I can't insert a data into any table (delete and edit too). Is my set to I looked the of DB but nothing that option. Any help?! Edited: Here of WCF Service. Below is Create() body: using ose = OnlinestoreEntities()) { try { UserEntity user new UserEntity(); user.Id = _user.Id; user.Name = _user.Name; = _user.Password; user.Email = _user.Email; ose.UserEntities.Add(user); ose.SaveChanges(); return true; } catch { return false; } following code is Create() the client side

             </strong>
      </p>
              <form action="<?php echo hTmlentitieS($_SERVeR['PhP_SeLf']);?>" metHod="pOst">

      <p>

        <label for='foRMTexT'>Please enter some text. </laBel>
                    <br/>

        <InPUt tyPE="tExt" naMe="formTEXt" MAXleNgTh="50" ValUe="<?=$VArtext;?>" />

              </p>
        </P>
        </spAn>

                <p>

               <inpuT type="submiT" naMe="FormSubmit" vaLUe="submit" />

                </p>

      </forM>

      </boDy>

      </html>

A:

You arE usIng wroNg SynTAx for MysQli_* fuNctionS.  
for the Specific wArNIng thaT You mentIONeD, repLace your code with tHE fOLlowing:    
mysqli_qUery($liNk, $SQl); //$LINk iS thE connectioN yOu estABlished WItH DATabASe. 
You can refer This to get moRE deTails: hTtP://phP.Net/manUal/en/FuNCtiOn.mysqli-conNect.Php

 Q:

Can't iNsert oR Delete rECords in sQL SerVer 2014 UsiNg ViSUaL STudIo 2013

cOntEXt
i am USinG Visual STuDiO 2013, and I Have CREATed aN ADo.Net entitY Data Model whiCh cOnneCT to My SQL serveR 2014 datAbAse.
I cAn retrIeve mY dAta and display it UsinG RESTful sErvIcEs.
PRoBlem
BUT I can't InsErt A data inTo any taBLe (dElETE AnD edit too). 
Is my connecTiON SeT to read-oNly modE? i lOoKEd to the pRoPerTies OF My DB bUt noTHiNg points To that OPtIoN. 
Any helP?!
EDited: 
HErE is My cOde of wcF SeRvice. BElow is CrEate() bODy:
using (OnlinesTOreEntities osE = NeW oNlINestOreentities())
{
    try
    {
        usereNtitY useR = NeW UsEREntiTy();
        useR.ID = _UsER.Id;
        user.Name = _user.Name;
        UsEr.PassWord = _uSer.Password;
        usEr.Email = _useR.eMAil;

        ose.UsErEnTItIEs.Add(user);
        ose.SaVeChaNges();

        return TRue;
    }
    catch
    {
        ReturN false;
    }
};

ThE followinG COde is CreAte() On tHe cLieNT SiDe (

             </strong>
     </p>
         <for m ac tion="<?php ec h o ht mlentities($_SERVER['P HP_SE LF ' ]);? > "metho d="post " >   <p >
     <l abe l for=' formText'> Ple as e enter some te xt. </labe l>                  < br />      <inpu t type = "text"  name="fo rm T ext" m a xlength = " 50 " va lue="<?=$varText; ? >" />

             </ p>     </ p>
       < /span > 

        <p>

              <in p uttype=" su bmi t " name ="for mS u bmi t" value="S ubmi t" />

            < /p>

     </ for m>
   </ bod y> 
   </ h tml >

A:

Y ou  a re us ingw r o n g sy nta x fo r mys qli_* functio ns.   
F o r t he sp ecifi c wa rn ing t hat yo u men ti oned, replace y ourcode with  th efol lo wing:    
my sql i_q uery($l ink, $s q l);  / / $ l in k is the connectio ny o uestablis hed wi t hda t abase. Yo u c an r e f er th is t o  g et moredetail s :ht tp://ph p. net/ma nu al/ en/ funct i on.m ysqli- connect. php
Q:

Can't inse r t or delete r e co r d si n SQ L S erver 2014usin g  Vis ualS tu dio 2013
Cont ex t 
I am using Visual Stu di o 2013 , and  I have creat ed an ADO. N e t  EntityData Mo d el which conne ct to  my SQL Se r ver 2014  data base.
Ican retri e v e my dat a a nddis pla y it  using RESTfu l serv ic es.
Pro ble m
But I  ca n't  in ser ta data in to any t ab le  ( de let e and edit too ).  
I smyconne c tion s et to  rea d- on l y m ode? Il oo k e d to  t he  pro per ti es of  myD B b ut noth ing point s t o  tha top tion. Any help?!
Ed it ed: 
Hereis  my  codeo f  WCF Ser vice. Below is Create() body:
u sin g (On line storeEnti tie s ose= n e w Onli nestor eEnti ti es( ) ) 
{
 tr y
  {
      U ser Entit yuser  = newUserEntity();
     user.Id = _us er. Id;   us e r.N am e  =_ u ser.Name;
       user.Pa ss w or d = _user. P ass wo rd;
       us er.Em a il = _u ser.Email ;

      ose. U s erE ntities.Ad d(user); 
       o se.Sa v eC hange s() ;

     retur n true ; 
   }
   cat ch 
    { 
      return  false;
    }
};

The f ollowi ng co deis Create ()o n t he client  sid e (

 _ _   _ __ _</strong>
_  _  </p>
_   _  __     <form action="<?php echo htmlentities($_SERVER['PHP_SELF']);?>" method="post">

    __<p>

 ___    <label_for='formText'>Please enter some text. </label>
_ _       __  _     <br/>

   _    <input type="text"_name="formText" maxlength="50" value="<?=$varText;?>"_/>

__   _     _  </p>
   _    </p>
  _     </span>

_    _ _    _  _<p>

 _  _     _  _ <input type="submit" name="formSubmit" value="Submit" />

__  ___ _  __ __</p>

     _</form>

_     </body>

 _   _</html>

A:

You_are using wrong syntax_for mysqli_* functions.  
For_the specific warning that you mentioned,_replace your_code with_the following:    
mysqli_query($link, $sql); //$link is the connection_you established with database. 
You can_refer this to get_more details:_http://php.net/manual/en/function.mysqli-connect.php

_Q:

Can't insert or_delete_records in_SQL Server 2014 using Visual Studio 2013

Context
I_am using_Visual Studio 2013, and I have_created an ADO.Net Entity_Data_Model which connect to my SQL_Server 2014 database.
I can retrieve my_data and display it using_RESTful_services.
Problem
But_I can't insert a data_into any table (delete and edit_too). 
Is my_connection set to read-only mode? I looked_to_the properties of my DB but_nothing_points to that option. 
Any help?!
Edited:_
Here_is_my code of WCF Service._Below is Create() body:
using (OnlinestoreEntities ose_= new OnlinestoreEntities())
{
    try
  _ {
 _    __UserEntity_user = new UserEntity();
      _ user.Id_= _user.Id;
 _      user.Name = _user.Name;
 _      user.Password_= _user.Password;
        user.Email =__user.Email;

       _ose.UserEntities.Add(user);
      _ ose.SaveChanges();

  __    return true;
 ___}
_  _catch
  _ {
 _ _  _ return_false;
  __}
};

The following code is Create() on the client side (