There are data of the form:

849591":"D139888907960162"W","76561198306866","ul":"XH5ApeknCRvCo04DEVlxkKgpZAJA7cW5moWfqPv7IE_2b6T9tvw2FG3_UcYPBdwVraVu2-15eBmnVl7z5iuyjsDymLt,"m":"имя_1","n:"netore,"t":"k","p":Ρ†Π΅Π½Π°_1,"s:],"":10851801",{"84946454","D112565269884","W","b","m":"имя_2",tmvHYjsSre":","p":Ρ†Π΅Π½Π°_2,"],"13982816",{"i84992193","028189599611207","by":"765611006866","ul":"XH5YQknCRvCo04DEVlxkKgLQJf2PLacDBA5ciJlY20k_jkI7fUhFR--NshtibkcvtybnmrjlbhjdreUd1drYFnR_QK2x73qg5G-uczMyntmvHYjsSrezhbh0wY1gghbdtn","m":"имя_3","0pqMjr0Ipoan sa"H5YQkk","p":Ρ†Π΅Π½Π°_3,"s":[],"wl":"3

I need the data name and price . They can be obtained by a regular for two variables:

price

 "p":(.*?),

name

 "m":"(.*?)"

either immediately

 "m":"(.*?)".*?"p":(.*?),

I need to stuff this data into a sql query like INSERT INTO test_table VALUES ('name', 'price', NOW ());

 Dim conn As New MySqlConnection("Server=127.0.0.1;User id=root;password=test_pwd;database=test_db") Dim cmd As New MySqlCommand Try conn.Open() cmd.Connection = conn cmd.CommandText = "INSERT INTO `test_table` VALUES ('имя', 'Ρ†Π΅Π½Π°', NOW());" End Try

But here is the right place on vbscript I do not go: (

  • Sound version of MySQL - in this case it is important. And instead of NOW (), it was necessary to correctly set the default value of the date-time field. - Akina
  • MySQL version 5.5. By the way, the default value of the data datetime column is NOT NULL, it turns out you can not fill it with the NOW () command? - Seryoga Bulygin
  • Version 5.5 - you are unlucky ... too old. We'll have to parse hands. And the field with such a definition does not have a default value. Need to change to data DATETIME DEFAULT CURRENT_TIMESTAMP - Akina

0