Questions tagged as 'mysql'

Tagged questions
1
answer

Problem with different encodings between databases

I'm creating an application that needs to grab some data that is in a SQL Server database with iso-8859-1 encoding, and insert into a MySQL database with utf-8 encoding. Some words with accents are giving error when inserting into MySQL datab...
asked by 04.08.2015 / 14:29
2
answers

Convert a date and send to the bank

The code is all working, the problem is the date, I want to get the date of a jformatedtextfiel ## / ## / #### in the txt_data case and send it to the bank, I'm in the basics of java, I'm hooked on this code there are days and I researched a lot...
asked by 05.08.2015 / 17:37
1
answer

Save php array to mysql database [duplicate]

I need to save an array in a field in the database table and I would like to know how best to do this if using serialize() and unserialize() or json_encode() and json_decode() . I know you have other alternativ...
asked by 02.09.2015 / 04:18
1
answer

upload multiple images

I know I already have some posts on this, but as I would just like to add to the code and not redo. In the code below, I need to add a way that the upload supports several images and as I still do not handle much I even went to the php site but...
asked by 29.08.2015 / 01:26
3
answers

Exchange PostgreSQL connection for MySQL connection

I found a project made in PHP OO to be used in PostgreSQL with this connection file. <?php class BD { public function __construct() { pg_connect("host=localhost port=5432 user=usuario password=senha dbname=nome_do_BD...
asked by 06.09.2015 / 14:33
1
answer

Upload form image with AJAX / PHP / MySQL

I'm redoing a form for a site that needs to upload an image, but I'm not able to upload and need your help. I already researched and could not find the answer ... Function: function fBlog_Send(){ $.ajax({ type:"GET", url:"ad_BL_Include...
asked by 26.08.2015 / 03:12
1
answer

Search in mysql database

I have to do a search in a table, I have to pass up 3 parameters to filter my search, this is my method: public List<Motores> pesquisaMotores(String serie, String marca, String modelo) { PreparedStatement comando = null; ResultSe...
asked by 23.10.2015 / 20:07
2
answers

Select PHP in tables with special characters

For some reason the DBA put "ç" on behalf of Mysql database tables and now I can not do select in those tables from php: $conn = new mysqli($servername, $username, $password, $dbname); $sql="select * from Tbl_login"; $result = $conn->query(...
asked by 23.10.2015 / 16:01
2
answers

Sort by join field with linq in MySql (C #, MVC)

I have the following query: query = from p in db.pessoa join f in db.pessoa_origem on p.Pessoa_Origem_Id equals f.Id join s in db.pessoa_status on p.Pessoa_Status_Id equals s.Id join c in db.contato on p.Id equals c.Pes...
asked by 24.07.2015 / 22:54
3
answers

Return the id of a table in another table

I have a clients table containing CLIENT_ID, CLIENT_NAME, and another table containing CLIENT_APROVED. The approval table is populated with SOME clients of the clients table but only the NAMES of the clients. I wanted to replace the name with...
asked by 03.07.2015 / 19:41