SQL Insert Query is Fine ! But can't store data in Mysql in PHP? -


this question exact duplicate of:

all code working fine !!!!
data storing in table can't store in table. !!!
seems structure of table wrong !!!
please review query , table structure, maybe structure wrong !!!

this insertion query, through insert data database !!!

except table, saves in every other table, structure of table different 1 !!!

insert query !!!

$insert = "insert companey (name,city,cell,phone,fax,adress,service,subservice1,subservice2,email1,email2,email3,lat,lng,img1,category,description,company_url,rurl,password,recomend,img2,img3,img4,img5,img6,ser,subser,reserve,ask,appoin) values ('$name','$city',null,'$phone',null,'$adress','$scat1',null,null,'$email',null,null,'$lat','$lon',null,'$cate',null,null,null,'$password',null,null,null,null,null,null,null,null,null,null,null)"; $insert_run = mysqli_query($conn , $insert); if($insert_run){   echo "<script> alert('company insert successfully') </script>"; } else{      echo "<script> alert('company not insert successfully') </script>";  }

sql table structure 

-- -- database: `critica_critica` --  -- --------------------------------------------------------  -- -- table structure table `companey` --  create table `companey_info` (   `id` int(30) not null,   `name` varchar(33) not null,   `city` varchar(33) not null,   `cell` varchar(33) not null,   `phone` varchar(33) not null,   `fax` varchar(33) not null,   `adress` varchar(33) not null,   `service` varchar(33) not null,   `subservice1` varchar(33) not null,   `subservice2` varchar(33) not null,   `email1` varchar(33) not null,   `email2` varchar(33) not null,   `email3` varchar(33) not null,   `lat` varchar(33) not null,   `lng` varchar(33) not null,   `img1` varchar(33) not null,   `category` varchar(33) not null,   `description` varchar(250) not null,   `company_url` varchar(33) not null,   `rurl` varchar(30) not null,   `password` varchar(33) not null,   `recomend` varchar(33) not null,   `img2` varchar(33) not null,   `img3` varchar(33) not null,   `img4` varchar(33) not null,   `img5` varchar(33) not null,   `img6` varchar(33) not null,   `ser` varchar(33) not null,   `subser` varchar(33) not null,   `reserve` varchar(33) not null,   `ask` varchar(33) not null,   `appoin` varchar(33) not null ) engine=myisam default charset=utf8;  -- -- dumping data table `companey` --  insert `companey` (`id`, `name`, `city`, `cell`, `phone`, `fax`, `adress`, `service`, `subservice1`, `subservice2`, `email1`, `email2`, `email3`, `lat`, `lng`, `img1`, `category`, `description`, `company_url`, `rurl`, `password`, `recomend`, `img2`, `img3`, `img4`, `img5`, `img6`, `ser`, `subser`, `reserve`, `ask`, `appoin`) values (3, 'oxelösunds rör ab', 'oxelösund', '0155-304 25', '000444', '0155-304 79', 'torggatan 24 61330 oxelÖsund', 'rör, rördelar, sanitetsgods - d', 'rörarbeten, vvs', 'värmepumpar, -växlare, -regulat', 'info@ox-ror.se', 'carolina@ox-ror.se', 'mehtabjani4310@gmail.com', '58.6673741', '17.1064219', 'chrysanthemum.jpg', 'badrum', 'this , company belong if need andfjks jfksadjf kjfkasdfj d', 'https://www.reco.se/', 'http://www.kaknastornet.se/om-', 'bz+ko,#a', '', 'errornext.png', 'desert.jpg', 'dahlstore1.jpg', 'dahlstore1.jpg', 'dahlstore1.jpg', '', '', 'on', '', ''), (4, 'insulander ab, byggnadsfirma g', 'strängnäs', '0159-35 00 60', '070-834 30 52', '', 'vältstigen 4 64541 strÄngnÄs', 'kakel, klinker ', 'byggmästare, byggnadsentreprenö', 'fasader', 'info@insulandersbygg.se', '', '', '59.3506313', '17.031865', '', 'badrum', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');  -- -- indexes dumped tables --  -- -- indexes table `companey` -- alter table `companey`   add primary key (`id`);  -- -- auto_increment dumped tables --  -- -- auto_increment table `companey` -- alter table `companey`   modify `id` int(30) not null auto_increment, auto_increment=647;

table name companey_info , trying insert in companey.

check once.

and if it's issue resolve using proper table name.


Comments

Post a Comment

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

i've set bento/ubuntu-16.04 vagrant box using php 5.6, , getting following error quite few times when try , run shell script: "uncaught reflection exception: class domdocument not exist". i've tried adding following top of script (not together), each no success: "sudo apt-get install php5.6-xml", "sudo apt-get install php5-xml", "sudo apt-get install php-dom" i've tried resetting server "sudo service apache2 restart". does have suggestions?
Read more

vue.js - Create hooks for automated testing -

Image
qa guys complained can't automate frontend testing. because our html looks same outside. lazy hack did this <template> <div :role="$options.name"> ... </div> </template> <script> export default { name: 'vmcomponentname' } </script> which takes name script , applies html. in browser get: <div role="vmcomponentname"> ... </div> line :role="$options.name" goes in every component. is there dry er solutions? please share. additional details i'll explain in details looking for. imagine have vmusercreate form creates user. test case can create user . to automatically test without role, have use following selector: .wrapper > .wrapper > .wrapper > .submit-button the test extremely brittle (will break lot). if use roles can use [role="vmusercreateform"] .submit-button selector. many folds less brittle. so basically, i'm ...
Read more

Add new key value to json node in java -

i have json file : { "id":1, "name":"abc", "addressdetails": { "city":"newyork" } } i wanted add 1 more key-value ("pincode" : "414141") node 'addressdetails'. i tried using : objectmapper mapper = new objectmapper(); jsonnode root = mapper.readtree(new file("d://test.json")); objectnode node = mapper.createobjectnode(); node.with("addressdetails").put("pincode", "414141"); but it's not getting added, there way can ? you can try you should modify file path objectmapper mapper = new objectmapper(); objectnode nodes = mapper.readvalue(new file("d:\\test.txt"), objectnode.class); nodes.with("addressdetails").put("pincode", "414141"); mapper.writer().writevalue(new file("d:\\test.txt"), nodes);
Read more