My current project consist of a MySQL table having 22 fields already. I want to add a new field namely Permanent address. In the front-end, it’s a textarea in which the user will fill the following data with either newlines or comma-separated as per the standard of here. First string will be House name,…
Tag: mysql
DELETE rows with prepared query in PHP and MySQL [closed]
Closed. This question needs debugging details. It is not currently accepting answers. Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem. This will help others answer the question. Closed 8 years ago. Improve this question This …
MySQL show all rows and sum at the end
I’ve read through about 20 different answers regarding this question, but either I’m mis-understanding the answers, or its just not clicking. Here is my situation: I have a table that lists ingredients for a recipe. Columns in the table are: ingredient_id, ingredient_title, ingredient_oz, ingredie…
Laravel: getting a single value from a MySQL query
I’m trying get a single value from MySQL database using laravel but the problem I’m getting an array . this is my query result in MySQL command line: my laravel function: expected $data value is a string with value= Admin but what i get is : [{“groupName”:”Admin”}] Answer E…
Laravel – Multiple User Logins Under One Main User Account
My application has the structure of monthly subscriptions that give you a single “admin” account login responsible for billing. Under that main user account, there can be numerous employees, some, …
issues printing last error message in php
I am trying to connect to a MySQL database using PHP, but I am getting 32767 error reporting in the console. I tried to show the error message using echo error_reporting() but it is not showing the …
phpMyAdmin: secret passphrase?
I am using MAMP and every time I login to phpMyAdmin, I am getting the following error/warning message: the configuration file now needs a secret passphrase (blowfish_secret). I have not messed around with any of this settings before. Can someone please clarify this error. Here is the info on my db server: Se…
Prepared statement inside while loop generated by prepared statement
So I was just wondering if this is a good practice or not, or for some reason does this type of code affect the speed and functionality of a system ? The first statement could generate 50 or more data, that means that another 50 or more statement will be produced, is this bad? Thanks for the answers. Answer E…
MySQLI Fetch Database Column
I have database table options, where am using it as a dedicated table to store information. I have never heard of this type of table query and have never tried it. I saw on WordPress database so thought to try my own. Here’s database table This is what am trying now This is inside my database class file…
How is it possible to run an ftp server, using php?
I would like to host az FTP server on: mywebsite.domain/ftpserver.php The XAMPP server runs on my computer. The php is important, because I would like to authenticate the users using their passwords in the mysql database, and their directory’s name is also stored in the database. Or if there is a free f…