Tag: mysql

Cannot send data to database using Ajax and Laravel

I am trying to insert data to database through Ajax And Laravel. But when I click the submit button, nothing happens at all. I tried to see if the javascript is reachable at the first using “Alert” and yes it is. But the part of $ajax is not reachable at all. Here is the code: Html: Javascript: for the controller

searching in large tables in laravel

laravel mysql php

I have some items from a table and I want to search for each item’s id in other 4 tables (that currently have around 5k-6k rows but will be larger in the future). I have to search through all tables (as above) and if I don’t find the item in one of the tables, I keep searching in the others.

Laravel 8 – How do I fetch data from database and add it in VCard?

laravel laravel-8 mysql php phpmyadmin

I am trying to make vCard for each of my users. I want to fetch data from database to the vCard such as: username, first name, last name, phone number, etc. As I don’t have much experience using Laravel, I want to know is it possible to add data to this code: I tried using {{ $user->email }}, {{ $user->username

Should you use prepared statments on LIMIT

mysql php prepared-statement sql

One day I was googling to understand when a prepared statment should be used. As I searched online many claimed that you should use always prepared statments. Now the question I have is… does this also count for LIMIT? I mean it is possible (I tried) but is it really that rational? Same question on ORDER BY too. Answer When

Laravel Migration Error: SQLSTATE[42000]: Syntax error or access violation: 1091 with mysql

laravel laravel-9 laravel-migrations mysql php

I am learning migration in Laravel. I have created a migration file and migrations seems to work fine from command line. But inside my mysql file the username column is not created after migration. Migration file: users table in mysql database: No username column created And when refresh my migration it gives me the below error Option1 : I tried

Add New Record Value, & Previous Record Value MySQL

mysql php

I am busy creating a new table in my DB, and have some issues populating the correct values. The table consists of a number of columns Using the UPDATE ON DUPLICATE KEY, is not an option here, as I need to keep each and every record, however, adding only the previous value to the new record. Existing Query: How do

Laravel Eloquent where statement returns no attributes

laravel mysql php sql where-clause

So from my previous post, I was advised to start using Eloquent models, which I did. My end goal, is to print out specific gifts, that belongs to that specific box. Migrations: gift_items: gift_campaigns: Pivot table: Controller: Error that I receive using this way: Seems like the updated version is trying to call the gift_campaigns table id, instead of the

I’m trying to get a single value (an email address) from a html input to mysql using php

mysql php

This is what’ve done so far but it gives giving me HTTPs 500 error or a syntax error in insert into value line Answer During the test phases, you can add the following code to the beginning of the file and find out the reason for the errors.

code event[] calendar in laravel 8 not working

javascript laravel-8 mysql php

I created a calendar with laravel 8 and PHP 8,it is running ok in php 7 but I have to upgrade to php 8 because of the demands of the times I have successfully saved data in the database but the data in mysql does not appear in the calendar, even though I have used event[], I have checked that

How to delete file in my database Laravel

laravel mysql php

How do I delete files in the database, because when I click delete the data in the folder is deleted, but the data in the file_rekap tables don’t want to be deleted, but the ones in the rekap table are deleted RekapController: Model rekap and file_rekap and script in my rekap_blade How ti fix it ? Answer If you want