I am new to Laravel. I am trying to insert some data into the table of the database at a particular time, say 12 am. What I have tried is: QuoteController.php use IlluminateHttpRequest; use AnomalyStreamsPlatformHttpControllerResourceController; use GuzzleHttpClient; use AppRating; use DB; //use IlluminateSupportFacadesDB; class QuoteController extends ResourceController { public function sendMessage(Request $request) { //dd($request->all()); $current_date ..
Category : database
KreaitFirebaseExceptionInvalidArgumentException The path of a URI with an authority must start with a slash "/" or be emptyenter image description here Sourc..
// how should i join these 4 tables users, pages, category, products using relationships intead in controller. //I also prefer calling these functions from corresponding models using respective function names but not database column names in view. Thanks in advance. These are my models //models class User extends Authenticatable{ use HasFactory, Notifiable; protected $fillable = ..
I am looking for some advice please as to the best way to configure my laravel database. The Software is for a Garage who fix cars etc. The Garage Admin will raise a new job on the system, then Engineers will be assigned the job. Once an Engineer views the job he can open a ..
I’m creating a desktop application of laravel and i want to connect my live server database in my locally deployed laravel project guide me for this thank you Sourc..
I have deployed my first Laravel blog into Heroku. I have added ClearDB as the remote database for Heroku. The problem is it comes out error 500 as in the link below: https://laravel-raj-blog.herokuapp.com/blog How do I properly set my database to enable login, post blog, register function work properly? Sourc..
I’m trying to save multiple Label Text of Checkboxes. First, I’m saving chechbox value in a column of database table. But other than that, I have to save Label of each those checkbox checked in another column of table. My table: Schema::create(‘restaurant_offers’, function (Blueprint $table) { $table->increments(‘id’); ……. $table->string(‘additionalOptions’)->nullable(); $table->string(‘additionalOptionsSum’)->nullable(); …… }); My blade: <label ..
Are OTP supposed to store in session or database. Can anyone please tell the flow of OTP. As Far as i understood, when a user submits the necessary field the user details and the otp gets stored in database, and after register another form opens to enter otp and then the registration finally success. But ..
I’m using Laravel but I’m trying to make paypal integration with php codes, I have created the Paypal Checkout SDK V1.0.1 by compiling : composer require paypal/paypal-checkout-sdk 1.0.1 so here is my PaypalTransaction.php(inside the SDK folder): <?php namespace Sample; require __DIR__ . ‘/vendor/autoload.php’; //1. Import the PayPal SDK client that was created in `Set up ..
Im working on multi language project using Laravel 8.0 and the idea of the website is that when the user is registering, after selecting the country the language is changed base on the language is chose by the user for all the pages. I have use the https://github.com/mcamara/laravel-localization package to change the language. The CreateNewUser.php ..
I’m learning to write web on Laravel, but I still don’t know how to connect jquery to database MySql,I want to know how to pass 1 or 0 to database. so I need some advice from anyone who knows. I’m sorry, my English grammar is not good. What I have written at the outset is ..
as you see on the diagram : the task belong to a user and a project on the same time. the user and project can have multiple tasks. how can i use laravel relationships to create a task? Sourc..
I need help in a very simple thing, I have 3 tables, users, brands, appliances, brands and products have many to many relations No While registering user, i want to give option to user to select their preferred brands and then save then, after suces, user is created, My confusion is in this case, Do ..
I’m working on a project using OctoberCMS and for the database I want to use MongoDB. but i have problem while migrating. when the migrate collection fails. please help so i can solve the problem. thank you. Sourc..
I have a issue when I try to model the database and return the data with laravel api resources. The rules are: A product belongs to many countries and a country can have many products. (Relationship many to many, here I have no problem) A product can have many presentations depending on the country. (Here ..
i have taken the id and mobile_num from users table.i have to insert that id name in this table as user_id,mobile_num,and status(0,1) into another table(wc_sms_status).sendSMSFunction is working fine. public function SendBulkSms() { $usersNumber = User::select(‘id’,’mobile_num’)->whereIn(‘id’, [5,6,7,8])->get(); foreach($usersNumber as $userNumber) { if (!$userNumber->mobile_num) { $this->sendSmsFunction($userNumber->mobile_num); DB::table(‘wc_sms_status’)->insert([ [‘user_id’ => ‘id’], [‘mobile_num’ => ‘mobile_num’] // set the status=1 ..
For example when I click on a button it takes me to the destination link and has the slug of that button for example(127.0.0.1:8000/product-categories/test1 and the second button is 127.0.0.1:8000/product-categories/test2…) only the slug changes, and My case is to activate each class of the span whenever I’m on it page. My Code: @foreach ($categories as ..
I’m trying to implement a polymorphic relation in my application while still taking advantage of foreign keys. I have 2 user types: Admin and User. Both of them can leave comment on a post. Here’s a brief description of my comment table: id – The id of the comment id_admin – FK of admin table, ..
I am writing a project for, let’s say, a company that maintains multiple real estate projects throughout the city. In this way, they have: Real Estate Project (typically a group of apartment houses with single main address). Single apartment house in the group (project), that has it’s own address. Single apartment inside the house. So, ..
I’m Using this code to click on Buttons to access their informations without loading the page, But Therefore I can’t receive the Database datas, <div class="itemss"> <span id="span-TEST1" class="item" data-name="TEST1" onclick="btnClick(this)">TEST1</span> <span id="span-TEST2" class="item" data-name="TEST2" onclick="btnClick(this)">TEST2</span> <span id="span-TEST3" class="item" data-name="TEST3" onclick="btnClick(this)">TEST3</span> <span id="span-TEST4" class="item" data-name="TEST4" onclick="btnClick(this)">TEST4</span> <span id="span-TEST5" class="item" data-name="TEST5" onclick="btnClick(this)">TEST5</span> <span id="span-TEST6" class="item" data-name="TEST6" ..
I am currently doing a local project, using MAMP with PHP version 7.4.21 and I can’t seem to run my system because the database is not configured correctly. Here’s my .env APP_NAME=Laravel APP_ENV=local APP_KEY= APP_DEBUG=true APP_URL=http://localhost:8888/VMLM LOG_CHANNEL=stack LOG_LEVEL=debug DB_CONNECTION=vmlm DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=laravel DB_USERNAME=root DB_PASSWORD= and here’s my database.php connections’ => [ ‘sqlite’ => [ ‘driver’ ..
I’m intending to delete a Category in my database , I have succeeded doing that by using Livewire Components but im trying to make it with using Controllers. This is my Controller.php: <?php namespace AppHttpControllers; use IlluminateHttpRequest; use Brian2694ToastrFacadesToastr; use AppModelsStaff; use AppModelsUser; use AppModelsCategory; use LivewireWithPagination; use HaruncpiLaravelIdGeneratorIdGenerator; use DB; class CategoriesController extends Controller ..
I get this error Undefined variable $image (View: C:xampphtdocsLaravelresourcesviewsformformadd.blade.php) , $image is undefined. The variable is not declared but I have declared $image inside my controller. This is my Controller that Im using: FormController.php: <?php namespace AppHttpControllers; use IlluminateHttpRequest; use Brian2694ToastrFacadesToastr; use AppModelsStaff; use AppModelsUser; use AppModelsProduct; use AppModelsCategory; use IlluminateSupportStr; use CarbonCarbon; use LivewireWithFileUploads; ..
For Attribute i can make two table 1 is attributes and another is attribute_values For attributes table Schema::create(‘attributes’, function (Blueprint $table) { $table->bigIncrements(‘id’); $table->string(‘attributeName’)->unique(); $table->timestamps(); }); For attribute_values table Schema::create(‘attribute_values’, function (Blueprint $table) { $table->bigIncrements(‘id’); $table->unsignedBigInteger(‘attributeId’); $table->string(‘value’)->unique(); $table->timestamps(); }); I want to show like: Under Size: L, S, M, XL etc Under Color: Red, Green ..
I am trying to display categories in table. Here is what table structure I want to use in view file. Category | Parent Category Shirts Clothes Watch NA Here is my Database table structure As you can see, parent category column contains ID of Parent category. SO if I fetch and display data in ..
Web Development Company
Free Hosting Company
