mysql - PHPMyAdmin Query error in php #1064 -

- 

  & lt;? Php // Facebook की तरह Facebook को प्राप्त करें FACEBOOK SERVERS functionFacebookLikes ($ url) {$ query = "Link_stat WHERE url = 'से like_count चुनें' ' $ Url। "'"; $ S = file_get_contents ("https://api.facebook.com/method/fql.query?query="। Urlencode ($ क्वेरी)। "& Amp; format = json"); preg_match ( "# (\" like_count \ "): ([0-9] *) #", $ s $ ar); अगर (isset ($ AR [2])) $ AR [2]; और नल वापसी; } Mysql_connect ('localhost', 'root', '') या मर (mysql_error ()); Mysql_select_db ('odrinhasedm') या मर (mysql_error ()); $ Query = mysql_query ("नॉम, पार्टैकाओ से यूआरएल चुनें") या मरने (माइस्किल_अर ()); जबकि ($ res = mysql_fetch_array ($ query)) {$ पसंद = "http: // [ip] / evento-odrinhas-edm-open-air /"। $ Res ['url']; $ Links = $ res ['url']; $ Contador = readFacebookLikes ($ पसंद); //echo'<tr><td>'.$res['nome'].'</td><td>'.$contador.'</td></tr> '; $ Query1 = "अपग्रेड करें प्रतिभागी सेट पसंद = $ contador WHERE url = $ links"; Mysql_query ($ query1) या मर (mysql_error ()); }? & Gt;

यह क्वेरी 1 काम क्यों नहीं कर रहा है? (PHPMyAdmin errror # 1064)

मेरे पास एक प्रोजेक्ट है जो प्रति उपयोगकर्ता एक पृष्ठ बनाता है और प्रत्येक पृष्ठ की अपनी पसंद की फ़ायरफ़ॉक्स जैसी प्रणाली है, अब मेरे पास उस डेटा को प्राप्त करने और इसे दिखाने के लिए एक तरीका है तालिका, लेकिन मैं उस डेटाबेस को सॉर्ट करने के लिए उस डेटा को मेरे डेटाबेस में सम्मिलित करना चाहता हूं। क्या मेरे डीबी के मूल्यों को जोड़ना आसान है या तालिका को सीधे php में सॉर्ट करना है?

मेरे पास एक क्वेरी है जो काम कर रही है और इसकी यूआरएल को PHP फाइल में खींच रहा है, तो मैं एक और क्वेरी का निर्माण करना चाहता हूं "अद्यतन" के साथ डेटाबेस में डेटा डालें।

मुझे लगता है कि url एक स्ट्रिंग है तो आपके पास मूल्यों के आसपास उद्धरण होना चाहिए: 

  UPDATE participacao सेट पसंद = $ contador WHERE url = '$ links'

Comments

Post a Comment

Popular posts from this blog

java - org.apache.http.ProtocolException: Target host is not specified -

-
I have written a simple httprequest / response code and I am getting this error below: I used to type in my classpath httpclient, httpcore, common -Codecs and general logging. I am very new to Java and I do not know what's going on here. Please help me. code: import org.apache.http.client.HttpClient; Import org.apache.http.client.methods.HttpGet; Import org.apache.http.HttpResponse; Import org.apache.http.impl.client.HttpClientBuilder; Import org.apache.http.Header; Import org.apache.http.HttpHeaders; Public class UnshorteningUrl {public static zero main (string [] args throws exception {HttpGet request = zero; HTTP Client Client = HTTP ClientBuilder.credit (). Build (); Try {Request = New HTTP Gate ("trib.me/1lBFzSi"); HttpResponse httpResponse = client.execute (request); Header [] header = httpResponse.getHeaders (HttpHeaders.LOCATION); // Preconditions.checkState (headers.length == 1); String new url = header [0] .getValue (); System.out.println ("new url...
Read more

c# - Chart control: Design messed Up after clearing and re-adding Y-Values -

-
Image
The day was struggling with this. I have three series on a chart that looks like this. Note: I am using vanof control. They are being added on the basis of input from the calculation. I am using this code to add value to each series. this.chart1.Series ["green"]. Points. AddY (greenvalue); This.chart1.Series ["totalsaving"] Points.AddY (totalsavingvalue). This.chart1.Series ["blue"] Points.AddY (bluevalue). I have set series properties like this. Both green and totalsaving are set to StackedColumn, the blue chart is set to the column for type. I started then To do is a button that brings the user back to the input field and then I am using this code to clear the series values ​​on the start code. chart 1. Series ["totaling"]. Points. clear (); Chart1.Series ["green"] Points.Clear () .; Chart1.Series ["blue"] Points.Clear () .; The same calculation click above is being calculated for the calculation of th...
Read more

javascript - Bootstrap Modal won't close, previously appended to Body using JQuery -

-
So I go to all the difficulties to get a modal and working text box, then I close it Go to the AJAX success event, but nothing seems to work I'll try. var id; Var refundarm = ''; Var Token = $ ("Meta [name = 'CSRF-Token']"). Attr ('content'); $ ('[Data-Toggle =' Model ']'). Find ID from ('click', function (e) {var checkEventCount = 1; var prevTarget; // Models href attribute ID = $ (this) .attr ('href'). (/ [^ 0-9.] / G, ""); $ ('# new_refund_modal' + id) .on ('show.bs.modal', function (e) {if (prevofarget == 'undefined' || (CzechEventCount == 1 & amp; Amp; e.target! = PrevTarget)) {prevTarget = e.target; CzechEventContent ++; E.Pravant Default (); $ (E.T. ('$'), ('$'), () () () () (Value)) = Refund Amount (Refund amount = $ (this) .val ();}});} And if (e.target == Navigate & amp; amp; Number == 2) {checkeventcount--;}});}); $ ('Refund-deposit-BTN...
Read more