Let me remove a way to create an insert statement for a Now the problem is in the database that these names are not released. Column names are only columns 1 column 2 etc. It looks like One more thing - when such a table is created then it will have different values, so I can not work hard to relate. Apart from this, these tables are made from importing Excel spreadsheets from front end (website). So I came up with a line of line 1 and a duplicate; 2 spreadsheets have so much that now when you import them the database looks like this So now I have some context for those values that will need to be inserted. Now there will be next steps involved. So in summary I can not insert the answer in the right column that represents the question without the correct information. I personally think that changing the column name to edit To give a slightly better understanding of this problem, I currently use The following should create an associative array that maps column names to column numbers In database schema: You can use it when preparing a database's future query. If you do not know how many columns you have, you can: in
PHP Need SQL db and I'm having trouble understanding the logic I convergence statement I will get from the data that I'm getting in the
JSON . Includes questions and answers in the
JSON The table in which I am inserting them is the problem on the front end (the website) contains column names that represent the questions and it looks like this .
Date | Address City | Zip
column1 | Column2. Column 3 Column 4
id | Column1 Column2. Column 3 Column 4 1 | Date | Address City | Zip
PHP would be a better option although I am very new to
PHP and
SQL It is also unaware that it is possible. Any help is appreciated
PHP I am posting.
$ json = secure ($ _ POST ['evaluation']); / * $ Json = '{"Info": ["Date: 6-22-13", "Phone Number: (555) 555-5555", "Address: 304 N. Scott'sthithad RD.", "City: SCOTTSDALE" , "Zip: 85251", "state: ag"]} '; * / $ Data = json_decode ($ json, true); $ Archive = array (); Forex Currency ($ data ['info'] as $ piece) {$ info = explode (':', $ piece); $ Collection [] = array ('question' = & gt; $ info [0], 'answer' => $ info [1]); } Echo '& lt; Pre & gt; '; Print_r ($ archive); Echo '& lt; / Pre & gt;
$ stmt = $ db- & gt; Prepare ('Column 1, Column 2, Column 3, ... from table where id = 1' is selected); $ Result = $ stmt-> carry about (); $ Data = $ result-> Get (PDO :: FETCH_ASSOC); $ Col_map = array_flip ($ data);
$ stmt = $ db- & gt; Prepare ('Select from table * where id = 1'); $ Result = $ stmt-> carry about (); $ Data = $ result-> Get (PDO :: FETCH_ASSOC); Not set ($ data ['id']); // Remove the `id` column, which does not conform to the column N pattern $ col_map = array_flip ($ data);
No comments:
Post a Comment