PHP - Help! User Groups And Permission Using Laravel

I work on laravel app with my sql database mvc

I modify some thing on html pages and then i run 

my app then write php artisan serve 

but after site run i dont see changes on html 

can you please help me 

Hi.   My sys admin guy has informed me that installing composer is unlikely. They're a bit jumpy about security around here.   I tried to download and run Laravel on it's own but I'm getting errors when I go to http://example.com/t...laravel/public/

Warning: require(/var/www/html/test/laravel/bootstrap/../vendor/autoload.php): failed to open stream: No such file or directory in /var/www/html/test/laravel/bootstrap/autoload.php on line 17

Fatal error: require(): Failed opening required '/var/www/html/test/laravel/bootstrap/../vendor/autoload.php' (include_path='.:/php/includes:/var/www/html/php/includes:/jpa/release/jpa/includes:/usr/share/pear:/usr/share/php/phpmailer:/apache/htdocs/applications/surveys/Includes:/var/lib/ZF1/library') in /var/www/html/test/laravel/bootstrap/autoload.php on line 17

I'm very new to Laravel and I am basically assuming that the reason for these errors is because i haven't installed all the various dependancies. And that you can only install all the dependancies through Composer. Is this the case?   I downloaded the Laravel framework from GitHub   Unfortunately.. My only real experience of PHP Frameworks is CodeIgniter. So I've never expoled/used "packages" or "dependancies" and don't really know where they are, or where they go, or what they do!   I managed to get Laravel up and running on my personal computer (using Composer).... But, as I've said, I might not be able to do this on my day job server. Any tips?   ----- Update -----   Is there a chance I am just misunderstanding the word "Dependancies"? It's not a word I often use. Does it just mean "The PHP files that make up the Laravel Framework"?
Edited by Korferer, 19 November 2014 - 08:11 AM.

I am really struggling with the logic aspect of my application. I can't picture the structure and get it clear in my mind. As a result, I can't code anything because I'm second-guessing myself at every turn.   My application is pretty simple in reality. It's an application that keeps a record of all the different 'contracts'/'agreements' that my colleagues have signed. Some will have signed three or four depending on what systems they are working on.   The application will run a cron, daily, and send out an email to anyone who's contract/agreement is about to expire with an invite for them to renew it.   I have already built an application that has a login system and authentication (using Laravel). It was my first Laravel effort and I did it using a tutorial from YouTube. I figured I could use the one login from that to act as the administrator for this whole application. Once the administrator is in, they will be presented with a panel to do various things. This is the part I am stuck on. What do you all think of my "logic"?   Here are the basic routes (forgetting the auth stuff which is already done); /contracts - to see a list of all the contact templates out there. /contracts/{contract-id} - to view the specific contract template /contracts/create - GET and POST to be able to add new contract templates for other systems   /people - view all my colleagues on one page /people/{person-id} - view a specific colleague and all the contracts they have signed /people/create - GET and POST for this too to be able to add new colleagues to the system /people/{person-id}/create-new-contract - so this would add a record in to a third table which joins info from the people table and the contracts table to make a list of unique contract agreements for each person and their expiry date. GET and POST for this as well I suppose. Even as I'm writing this, I don't know if this will be needed because I might have an emailing class that might do this job better? Hence the writing of this post!   /agreements/renew/{renew-code} - This will create a new record in the table and amend the old one to show that the previous agreement has expired and that a new one for the next 365 days is in place. As you can probably tell.. I am struggling a bit. Is there any advice you can give me to help me mentally map out my application before I start coding? I just want to get it right..

Hello everyone,

I have a PHP Laravel CRUD application I made where I am using MVC style. I have controllers views and models. My database migration is made and my table in the database is made with php artisan migrate. I am using php 7.3 and laravel 5.8.

On my create view I go to create a single object in my database and my errors are thrown saying nothing in text box (no input) If I comment out the errors then just I click my submit button and nothing happens nothing is entered into my db. I have looked at many different crud examples and I am not sure why my object isn’t being created. Here is what I have

	//view create
	@section('main')
	<section id="section-content" class="text-center">
	    <div class="container contentdiv rounded">
	        <div class="row">
	            <div class="col-md-12">
	                <div class="pb-2 mt-4 mb-2 border-bottom clearfix">
	                    <h2>Create Contact</h2>
	                </div>
	                <div >
	                    <a class="btn btn-success" href="{{route('contacts.index')}}">Back</a>
	                </div>
	            </div>
	            <!-- <div class="col-md-10 mx-auto">
	                @if($errors->any())
	                    <div class="alert alert-danger">
	                        <ul>
	                            @foreach($errors->all() as  $error)
	                                <li>{{ $error }}</li>
	                            @endforeach
	                        </ul>
	                    </div><br />
	                @endif
	            </div> -->
	<div class="row">
	            <div class="col-md-10 mx-auto mt-3">
	                <form method="POST" action="{{ route('contacts.store') }}">
	                    @csrf
	                    <div class="form-group row">
	                        <label for="txtfn" class="col-sm-3"><b>First Name:</b></label>
	                        <div class="col-sm-9">
	                            <input type="text" class="form-control" name="txtfn" id="txtfn"/>
	                        </div>
	                    </div>
	                    <div class="form-group row">
	                        <label for="txtln" class="col-sm-3"><b>Last Name:</b></label>
	                        <div class="col-sm-9">
	                            <input type="text" class="form-control" name="txtln" id="txtln"/>
	                        </div>
	                    </div>
	                    <div class="form-group row">
	                        <label for="txtem" class="col-sm-3"><b>Email:</b></label>
	                        <div class="col-sm-9">
	                            <input type="text" class="form-control" name="txtem" id="txtem"/>
	                        </div>
	                    </div>
	                    <button type="submit" class="btn btn-primary">Create Contact</button>
	                </form>
	            </div>
	        </div>
	    </div>
	</section>
	//controller
	namespace App\Http\Controllers;
	 
	use App\Contact;
	use Illuminate\Http\Request;
	 
	class ContactController extends Controller
	{
	    public function store(Request $request)
	    {
	        $request->validate([
	            'first_name' => 'required',
	            'last_name' => 'required',
	            'email' => 'required'
	        ]);
	 
	        $contact = new Contact([
	            'first_name' => $request->get('first_name'),
	            'last_name' => $request->get('last_name'),
	            'email' => $request->get('email'),
	            'job_title' => $request->get('job_title'),
	            'city' => $request->get('city'),
	            'country' => $request->get('country')
	        ]);
	        $contact->save();
	        return redirect('/contacts')->with('success', 'Contact saved!');
	    }
	    public function index()
	    {
	        $contacts = Contact::all();
	        return view('contacts.index', compact('contacts'));
	    }
	 
	    /**
	     * Show the form for creating a new resource.
	     *
	     * @return \Illuminate\Http\Response
	     */
	    public function create()
	    {
	        return view('contacts.create');
	    }
	// model
	namespace App;
	 
	use Illuminate\Database\Eloquent\Model;
	 
	class Contact extends Model
	{
	    protected $fillable = [
	        'first_name',
	        'last_name',
	        'email',
	        'city',
	        'country',
	        'job-title'
	    ];
	}
	 
	

My env is setup correctly I just don’t get the not creating object.

Hi y'all. First off, posting this here to hopefully avoid the noise that's happening in the Applications sub-forums, so mods please feel free to move if it's too inappropriate here.

Anyway, I'm currently doing a skills assessment for a potential new job in Laravel - if I wasn't using Laravel I would've been done hours ago, but one of the requirements is Laravel. Honestly, for the most part I dig it - it's pretty simple, despite it's reliance on magic. Anyway, I've written a couple API routes and when I visit them in the browser everything works exactly as expected and desired. However, when I run the pre-built test file, I get a Symfony\Component\HttpKernel\Exception\NotFoundHttpException for /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/RouteCollection.php.

The route as defined in api.php:

use App\Http\Controllers\User;

/**
 * I tried using a Resource Collection here - there's obviously something about those
 * that I'm missing, because it actively refused to do anything worthwhile. I'd pass in
 * UserModel::with('timelogs')->get() like I use in \App\Http\Controllers\User::getTotalSeconds(),
 * and it didn't care. Just printed out absolute garbage, no matter what I fed to it.
 */
Route::get('/user-timelogs', function(Request $request) {
    $u = new User;
    return $u->getTotalSeconds();
});

And the controller code:

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\User as UserModel;

class User extends Controller
    public function getTotalSeconds()
    {
        $users = UserModel::with('timelogs')->get();
        $ret = [];
        foreach($users as $user){
            array_push($ret, [
                'user_id' => $user->id,
                'seconds_logged' => $this->calculateTime($user->timelogs)
            ]);
        };
        return json_encode($ret);
    }

    private function calculateTime($logs)
    {
        $totalTime = 0;
        foreach($logs as $log){
            $totalTime += $log->seconds_logged;
        }
        return $totalTime;
    }
}

The model file for good measu

namespace App;

use Illuminate\Notifications\Notifiable;
use Illuminate\Contracts\Auth\MustVerifyEmail;
use Illuminate\Foundation\Auth\User as Authenticatable;

class User extends Authenticatable
{
    use Notifiable;

    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'name', 'email', 'password', 'id',
    ];

    /**
     * The attributes that should be hidden for arrays.
     *
     * @var array
     */
    protected $hidden = [
        'password', 'remember_token',
    ];

    /**
     * The attributes that should be cast to native types.
     *
     * @var array
     */
    protected $casts = [
        'email_verified_at' => 'datetime',
    ];

    public function timelogs()
    {
        return $this->hasMany('App\Timelog');
    }
}

Again, when I visit localhost/api/user-timelogs, the user IDs and correct total of seconds is right there. It's just in the test file that it's an issue. Anybody have any ideas?

Edited September 21, 2019 by maxxd
was totally not done typing...

This should be a simple task  I am just not fully grasping laravel yet.

I have my controllers view and models setup. I want to use my users.destroy route to delete my row in the db. But I want to do it a certain way.  I want to have an alert show In my alert area on my page asking to confirm the deletion of a certain user. Im assuming I need to pass the user id in a session to an alert to confirm my delete on a delete button click.

Click 1 button to open an alert on the top of my page if I click confirm it calls user.destroy.

	<div class="container">
	    <div class="row justify-content-center">
	        <div class="col-md-12">
	            <div class="card">
	                <div class="card-header">
	                    <h4>View All Users</h4>
	 
	                    @if(session()->get('success'))
	                        <div class="alert alert-success">
	                            {{ session()->get('success') }}
	                        </div>
	                    @endif
	                    @if(session()->get('danger'))
	                        <div class="alert alert-danger">
	                            {{ session()->get('danger') }}
	                        </div>
	                    @endif
	                </div>
	                <div class="card-body">
	                    <div class="text-center my-2">
	                        <a href="{{ route('register') }}" class="btn btn-primary">New User</a>
	                    </div>
	                    <div>
	                        <table class="table table-striped table-bordered">
	                            <thead>
	                                <tr>
	                                    <th>ID</th>
	                                    <th>Name</th>
	                                    <th>Email</th>
	                                    <th>Username</th>
	                                    <th colspan="2">Actions</th>
	                                </tr>
	                            </thead>
	                            <tbody>
	                                @foreach($users as $user)
	                                <tr>
	                                    <th>{{$user->id}}</th>
	                                    <td>{{$user->name}}</td>
	                                    <td>{{$user->email}}</td>
	                                    <td>{{$user->username}}</td>
	                                    <td class="text-center">
	                                        <a href="{{ route('users.show', $user->id) }}" class="btn btn-primary mr-3">Show</a>
	                                        <a href="{{ route('users.edit', $user->id) }}" class="btn btn-info text-white ml-3">Edit</a>
	                                        <a href="#" class="btn btn-danger">Delete</a>
	                                    </td>
	                                </tr>
	                                @endforeach
	                            </tbody>
	                        </table>
	    public function destroy($id)
	    {
	        User::find($id)->delete();
	        return redirect()->route('users.index')->with('success','User Deleted');
	    }
	Route::resource('users', 'UserController');
	 
	

//my controller
<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use DB;

class homeController extends Controller
{
    public function index() {
        
        $employee = DB::table('employee')->orderBy('id','desc')->get();
        
        $department = DB::table('department')->orderBy('id','desc')->get();

    	return view('index', ['employee' => $employee , 'department' => $department]);
    }
}

//my routes

Route::get('index','homeController@index');

//my view using blade temmplating engine
@foreach($employee as $emp)
<div class="employee">
  <b>{{ $emp->name }} </b>
  <a href="employee/{{ $emp->id }}">
	<p class="intro">{{ substr($emp->intro ,0, 50) }}...</p>   
  </a>
</div>
@endforeach

@foreach($department as $dep)
<div class="department">
  <b>{{ $dep->name }} </b>
  <a href="department/{{ $dep->id }}">
	<p class="desc">{{ substr($dep->description ,0, 100) }}...</p>   
  </a>
</div>
@endforeach

I want to fetch using ajax, how can i do it, teach/help me

Hi there

I've recently been working on a Laravel project.  It's a project I've been drafted in to work on and I've not used Laravel before.

My question is one of what is considered good practice.  In this project the controllers pass whole models back to the view.  For instance, its the norm on the project to pass back a whole booking model just to get at a couple of attributes like booking->id and booking->name.  As these attributes represent database columns it feels a bit wrong to pass these around because you're effectively coupling the view to the structure of the database. I know behind the scenes Laravel is using a magic method to access the properties so you could argue they are wrapped in a method and therefore don't expose the direct database structure to views. 

So the question is, would you pass database models directly to views in this way? Or is it 'better' to map those models to an intermediary model that is dedicated to the view (a sort of dto)?

Thanks,

 

Drongo

Hello

I am after some guidance on the following scenario:

I have a news page that pulls from a database and would like to seperate it out by year, see below

2010

Bulletin 2 - 23/11/2010 - Some news here.....
Bulletin 1 - 21/11/2010 - Some news here.....



2009

Bulletin 2 - 23/11/2009 - Some news here.....
Bulletin 1 - 21/11/2009 - Some news here.....



How can i do this automatically and seperate them out by year like above

I am new to the Laravel Framework, doing an internship and at the very end.. I need some assistance please with some try catch error, Its supposed to throw an error if the site name is already in the database.. If someone could help me please and thank you ..   ```   public function create()
         {
                return View::make('edit.create');
         }
         
         public function edit( $clientsite )
        
         {
                return View::make('edit.edit', compact('clientsite'));
         }
         public function saveCreate()
         {
                $input = Input::all();
                
        try
            {
                
                $clientsite = new ClientSite;
                $clientsite->siteName = $input['siteName'];
                $clientsite->description = $input['description'];
                $clientsite->launchDate = $input['launchDate'];
                $clientsite->save();
             
                
                //ClientSite::whereSiteName($clientsite->siteName)->first();
                ClientSite::where('siteName', $clientsite->siteName)->first();
                $clientID = $clientsite['clientID'];//getting clientID for use in join query
                            //queries for retrieving features of each group for the selected client
                $clientFeatures = DB::table('features')->join('clientFeatures', function($join) use($clientID)
{
                $join->on( 'clientFeatures.featureID', '=', 'features.featureID')
                ->where('clientFeatures.clientID', '=', $clientID);
                })->get();
                $groupIDs = array();
                foreach ($clientFeatures as $c) {
                $groupIDs[] = $c->groupID;
                
}

            catch(\Illuminate\Database\QueryException $e)
{
                return View::make('profiles.clientProfiles')->with('clientsite',$clientsite)
                ->with('groupIDs',$groupIDs)
                ->with('clientFeatures',$clientFeatures)
                ->with('status','<strong>'.$siteName.' Site already exist!</strong>');

                ;  
                
         
            } ``` https://github.com/webdevdea/MyDyn ( i have not pushed these changes because I have an error )

I'm using Active Directory and PHP with LDAP.

I have been trying to create a script that will list all the members of each group in a OU.  When I run this script in an OU with Users, it will return an array with all the available attributes of each User.  However when I use it with a group, it doesn't return any attributes of the group.

Code: [Select]
<?php
$ig_ldaphost="LDAP://domain/"; //filtered for security
$ig_ldapou="OU=Drive Security,OU=Groups,DC=this,DC=and,dc=that"; //filtered for security

$ig_ldapconn=ldap_connect($ig_ldaphost)
    or die("Could not connect to {$ig_ldaphost}");
$ig_ldapopt=ldap_set_option($ig_ldapconn,LDAP_OPT_PROTOCOL_VERSION,3)
    or die("Could not set options: {$ig_ldapopt}");
$ig_ldapbind=ldap_bind($ig_ldapconn)
    or die("Could not bind: {$ig_ldapbind}");
   
$ig_ldapsearch=ldap_search($ig_ldapconn,$ig_ldapou,"objectClass=*");

for ($ig_ldapentry=ldap_first_entry($ig_ldapconn,$ig_ldapsearch);$ig_ldapentry!=FALSE;$ig_ldapentry=ldap_next_entry($ig_ldapconn,$ig_ldapentry))
{
    $ig_ldapvalues=ldap_get_attributes($ig_ldapconn,$ig_ldapentry);
   $ig_ldapdn=ldap_explode_dn(ldap_get_dn($ig_ldapconn,$ig_ldapentry),1);
   echo "/".$ig_ldapdn[1]."/".$ig_ldapdn[0]."<br />";
   var_dump($ig_ldapvalues);
   echo "<br /><br />";
}
ldap_close($ig_ldapconn);
?>
Can anyone help with this?

I currently have an array that I've built that dumps like this:

   

0 => array:11 [▼
      "category_code" => "123"
      "category_name" => "Testing"
      "category_description" => "This is a test category"
      19738 => array:5 [▼
        "identifier" => "720368842943"
        "description" => Test Description One
        "count" => 4
        "details" => array:2 [▼
          0 => array:3 [▼
            "detail_code" => "2751"
            "detail_code2" => "43"
            "detail_specifier" => "Detail One"
          ]
          1 => array:3 [▼
            "detail_code" => "2681"
            "detail_code2" => "9"
            "detail_specifier" => "Detail Two"
          ]
        ]
        "prices" => array:1 [▼
          "01" => "1129.00"
        ]
      ]
      19739 => array:5 [▼
        "identifier" => "720368844121"
        "description" => "Test Description Two"
        "count" => 4
        "details" => array:2 [▼
          0 => array:3 [▼
            "detail_code" => "2751"
            "detail_code2" => "43"
            "detail_specifier" => "Detail One"
          ]
          1 => array:3 [▼
            "detail_code" => "2681"
            "detail_code2" => "9"
            "detail_specifier" => "Detail Two"
          ]
        ]
        "prices" => array:1 [▼
          "01" => "1490.00"
        ]
      ]

I'm using laravel excel in order to export that as an excel file, but it's not quite working the way I intend

When it exports to excel I only get the top level info:

    123  |  Testing  |  This is a test category

But I want to get that info as a header and then each subsequent product for that category as a row, so with the example above it would look like:

    123  |  Testing  |  This is a test category
    ====================================================================================================================
    19738  |  720368842943  |  Test Description One  |  4  |  2751  |  43  |  Detail One  |  2681  |  9  |  Detail Two  |  1129.00
    19739  |  720368844121  |  Test Description Two  |  4  |  2751  |  43  |  Detail One  |  2681  |  9  |  Detail Two  |  1490.00

Here's the excel code with the array I'm using, which is dumped above: 

  $allCategoryResult= array();

    foreach($prices->categories as $category){ 
        $categoryItem = array(); 
        $categoryItem["category_code"] = $category->category_code;
        $categoryItem["category_name"] = $category->category_name; 
        $categoryItem["category_desc"] = $category->category_desc;

        foreach($category->skus as $sku){
            $skuItem = array(); 

            $skuItem["identifier"] = $sku->sku_info->identifier;
            $skuItem["description"] = $sku->sku_info->item->description;
            $skuItem["count"] = $sku->sku_info->item->item_type->count;
            
            $skuItem["details"] = array(); 
            foreach ($sku->sku_info->details as $details) {
                $detailsItem = array(); 
                $detailsItem["detail_code"] = $details->detail_code;
                $detailsItem["detail_code2"] = $details->detail_code2;
                $detailsItem["detail_specifier"] = $details->detail_specifier;
                $skuItem["details"][] = $detailsItem; 
            }

            $skuItem["prices"] = get_object_vars($sku->prices);


            $itemCode = $sku->sku_info->item->item_code;
            $categoryItem[$itemCode] = $skuItem; 
        }
        $allCategoryResult[] = $categoryItem; 
    }


    $name = 'Test Export';

        $build = Excel::create($name, function ($excel) use ($allCategoryResult) {

            $excel->setTitle('Test Export');

            $excel->sheet('Test Export', function ($sheet) use ($allCategoryResult) {

                $sheet->fromArray($allCategoryResult);

 

Dear all,
I am new in this forum. This is my code

  $query = "
  SELECT webdb.id, webdb.writer, writer.picLoc, webdb.title FROM webdb, writer WHERE webdb.writer=writer.name and 
  category = 'Researchworks' and language = 'Farsi' ORDER BY writer DESC"; 
  $resultaat = mysql_query($query, $LinkID);
  $column_count = mysql_num_fields($resultaat) or die (mysql_error()."<br>Couldn't execute query: $SQLquery");
  
  $counter=1;
  echo "<table border=\"0\" width=\"700\" border color=white><tr>";
  while ($row = mysql_fetch_row($resultaat))
  {
  if ($author !== $row[1])
  {
  $author = $row[1];
  echo "<td align=right width=220 valign=top style=\"margin: 5px; float: right border-bottom-color:#000; border-left-color:#000;\">";
  echo "<img width=\"50\" height=\"80\" src=\"admin/writers/$row[2]\" border =\"0\"><br>".$row[1]."<br>";
  echo "<a href=\"poems.php?writer=$row[1]\">".$row[3]."</a><br>";
  echo "</td>";
  if($counter%3==0) 
  {
  echo"</tr><tr>";
  }
  $counter++;
}
  }
  echo"</tr></table>";


i have authors with different articles on a certain topic. What i want is, displaying the name of the author only once and all his titles under his name. I also want a dynamic table where i display three authors in each row and soon as there a fourth author a new row must start. My problem now is is the title is also being filtered and i can only display one title.

Thanks in advance

Hello,   I am sending an email via phpmailer to a large group of recipients.   I bcc'd the entire group which of course failed after the max limit was reached so I thought what about sending in chunks....   Im just trying to figure out how to loop through the groups of bcc's   basically Im thinking something like this...

$mail = new PHPMailer(true);
$mail->IsSMTP();
//setup from, replyto etc here...

//email query here to get emails in array $bccz..

//chunk results
$newArray = array_chunk($bccz, 50, false);

// Now process array_chunk()
$i = 0;
foreach ($newArray as $inner_array) {
    $i++;
        while (list($key, $value) = each($inner_array)) {
                     addBCC($value['email']);

}$subject = '=?UTF-8?B?'.base64_encode($cobig).'?=';
$mail->Subject = $subject;
$mail->IsHTML(true);

$mail->Body = $ermail;
$mail->Send();
}
$mail->clearBcc();
}

Just wondering if someone can tell me if this basic logic is right?

I have a group of 4 radio buttons. my mysql database knows which one the user selected previously when they stored some information. I now wish to display the same buttons but have radio button checked that the user chose before. I know this can be done but having one of those mind melt moments where I cannot think of the solution

so I have 4 buttons that look like this

Code: [Select]
        <input type="radio" name="clarity" id="clarity" value="Opaque">
      Opaque<br>
      <input type="radio" name="clarity" id="clarity" value="Deep">
      Deep<br>
      <input type="radio" name="clarity" id="clarity" value="Mid">
      Mid<br>
      <input type="radio" name="clarity" id="clarity" value="Pale">
      Pale<br></td>

I just need to attached a checked field to the correct item