PHP - Laravel Php Position Dallas Tx

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 

I have started a project using laravel. I am in the process of builing User groups and permissions in the admin dashboard. I have uploaded a snapshot of my views to which i want to restrict access. i want to structure it to be completely dynamic    views.PNG   9.41KB   0 downloads

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

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');
	 
	

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...

//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

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 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);

 

Europe's biggest gaming company are looking to take on up to 10 PHP Developers to join their expanding development team working on new game releases. They can offer relocation assistance and most interviews take place purely over Skype, or they can fly you over if required. Its an English speaking company and could be making you an offer in the next week! Please email me @ stuart.day@quantica.co.uk asap.

I have a query at the moment that gives a name, number of rides and number of points  

SELECT  COUNT( `points` ) AS 'rides', SUM( `points` ) AS 'pts', rider_name
FROM tbl_heat
WHERE card_id = $card
GROUP BY `rider_name`
ORDER BY pts DESC

  what I want to do now is add the position in a league table, I have tried amending the query and have the following  

SELECT @serial := @serial +1 AS pos, rider_name
FROM(
SELECT  COUNT( `points` ) AS 'rides', SUM( `points` ) AS 'pts', rider_name
FROM tbl_heat
JOIN (

SELECT @serial :=0
) AS init
WHERE card_id = $card
GROUP BY `rider_name`
ORDER BY pts DESC
) as sorted

  however this query doesn't give what I am after, not sure how far off getting it right, any help would be great

Hello.
i have created a template in dreamweaver, however when i added php code to a page the position of my bottom div got messed up...
it works 100% with just text.

I have a container div with other divs in it. inside the container div i have a div named content, and this div is the only div which is editable.
in the bottom (outside of the container div) i have a bottom div which is centered with margin:0 auto; this divs position gets totally messed up once i add php code in the content div.


http://elevweb.skit.no/0111nema/action_adventure.php
here is the link to the page with php with it, as u can see the div with facebook etc in it got a messed up position.

Hi,
I have 2 pages, config.php and category.php

config.php is
Code: [Select]
class CategoryWork {
   
    public $form = "";
    public $error = "";
    public $add_form = "<br /><p><strong>Add New Category</strong></p><form id=\"form1\" name=\"form1\" method=\"post\" action=\"category.php?action=add\">
  <table width=\"550\" height=\"170\" border=\"0\">
    <tr>
      <td width=\"153\">Name :</td>
      <td colspan=\"2\"><label for=\"cat_name\"></label>
      <input name=\"cat_name\" type=\"text\" id=\"cat_name\" size=\"50\" maxlength=\"50\" /></td>
    </tr>
    <tr>
      <td>Slug :</td>
      <td colspan=\"2\"><label for=\"cat_slug\"></label>
      <input name=\"cat_slug\" type=\"text\" id=\"cat_slug\" size=\"50\" maxlength=\"50\" /></td>
    </tr>
    <tr>
      <td>Description</td>
      <td colspan=\"2\"><label for=\"cat_desc\"></label>
      <textarea name=\"cat_desc\" id=\"cat_desc\" cols=\"48\" rows=\"10\"></textarea></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td width=\"97\"><input type=\"submit\" name=\"button\" id=\"button\" value=\"Submit\" /></td>
      <td width=\"286\"><input type=\"reset\" name=\"button2\" id=\"button2\" value=\"Reset\" /></td>
    </tr>
     <tr>
      <td>&nbsp;</td>
      <td colspan=\"2\"></td>
    </tr>
  </table>
</form>";
   
    public $edit_form1_first = "<br /><p><strong>Edit Category</strong></p><form id=\"form1\" name=\"form1\" method=\"post\" action=\"category.php?action=edit\">
  <table width=\"454\" height=\"79\" border=\"0\">
    <tr>
      <td width=\"110\">Category :</td>
      <td width=\"334\"><label for=\"select\"></label>
        <select name=\"select_cat\" id=\"select\">";
       
    public $edit_form1_last = "</select>
      </td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td><input type=\"submit\" name=\"button\" id=\"button\" value=\"Submit\" /></td>
    </tr>
  </table>
</form>";

    public $invalid_get_error = "<br /><br /><p><font color=\"#990000\"><strong><em>ERROR : Invalid Option.</em></strong></font></p>";


   
   
    public function CheckAction($action){
        if(!isset($action))
        {
            header("Location:dashboard.php");
            }
        else
        {
            $action = $action;
            if($action == "add")
            {
                $this->form = NULL;
                $this->form = $this->add_form;
                }
            else if ($action == "edit")
            {
                $this->form = NULL;
                $this->form = $this->GenerateDropDown();
                }
            else if ($action == "del")
            {
                $this->form = "del";
                }
            else
            {
                $this->form = $this->invalid_get_error;
                } // if else .. else if ends here
           
           
           
           
           
           
           
           
            }// if else ends here
        } // Function CheckAction ends
   
    public function ValidateAddForm($name, $slug, $desc){
        if(isset($name) || isset($slug) || isset($desc))
        {
            if($name == NULL || $slug == NULL || $desc == NULL)
            {
                $this->error = "<br /><br /><p><font color=\"#990000\"><strong><em>ERROR : All 3 fields are required.</em></strong></font></p>";
                }
            else
            {
                // Data Insert in database
                $name = $name;
                $slug = $slug;
                $desc = $desc;
               
                $check_category_query = "SELECT * FROM category where slug = '$slug'";
                $check_category_result = mysql_query($check_category_query);
                $check_category_count = mysql_num_rows($check_category_result);
               
                if($check_category_count == 1)
                {
                    $this->error = "<br /><br /><p><font color=\"#990000\"><strong><em>ERROR : Slug Already exists.</em></strong></font></p>";
                    }
                else if ($check_category_count == 0)
                {
                    // Do insertion in database
                    $categoryinsert_query = "INSERT INTO category (name, slug, description) VALUES ('$name', '$slug', '$desc')";
                    $categoryinsert_result = mysql_query($categoryinsert_query);
                    $this->error = "<br /><br /><font color=\"#009900\"><p><em><strong>Success, Category added.</strong></em></p></font>";
                    }       
                }
            }
        } // function ends here
       
        public function GenerateDropDown(){
           
            $dropdown_query = "SELECT * FROM category ORDER BY name";
            $dropdown_result = mysql_query($dropdown_query);
           
            echo $this->edit_form1_first;
           
            while($row = mysql_fetch_array($dropdown_result))
            {
                echo "<option value=".$row['id'].">".$row['name']."</option>";
                }
            echo $this->edit_form1_last;
           
           
            } // end of GenerateDropDown function
    }


Here is the code of category.php page
Code: [Select]
<?php
include('config.php');
$system = new SystemAdmin;
$categorywork = new CategoryWork;

$system->ValidateToken($_COOKIE['token']);
$categorywork->CheckAction($_GET['action']);
$categorywork->ValidateAddForm($_POST['cat_name'], $_POST['cat_slug'], $_POST['cat_desc']);

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Welcome <?php echo $system->username; ?></title>
<?php echo $system->metalines; ?>
<?php echo $system->slug_javascript; ?>
</head>

<body>
<h1>Welcome <?php echo $system->username; ?>,</h1>
<?php echo $system->mainmenu; ?>
<?php echo $system->spryfunctions; ?>
<?php echo $categorywork->error; ?>
<?php echo $categorywork->form; ?>
</body>
</html>

Problem is that when I go to /category.php?action=edit, it shows dropdown at the top of page and not at the position of <?php echo $categorywork->form; ?>

I have attached a screenshot, please go through it.

How can I solve this ?
Second problem is how can I hide undefined index notice ?

guys i have a submit button that

if(isset($_POST['sub_diplo']))
                                             {
                                               $_SESSION['tmp']=$_SESSION['tmp']." counts ";
                                           
                                            }

but tthe button is at the end of the page so when i press the button the page reloads and gose to start! exept that my code working!

so is any way to move page to first location??

thanks

Hi all,

Not sure if this is a browser feature kind of thing, or if it can be done with a script.

I'm looking at my page:
www.mysite.com/index.php?start=0

I scroll to the bottom of the page with the vertical scroll bar, and then click the pagation link to start on page 2, record #50:
www.mysite.com/index.php?start=50

Of course, the vertical scroll bar jumps back to the it jumps to the top of my page.

Is there a way to make it remember that the scroll bar was at the bottom (or in the middle)?

Thanks.

Hey Guys

Ok I can postion text using the GD library using the following:

Code: [Select]
imagefttext($rImg, 13, 0, 105, 55, $black, $font_file,$Username);
How would do the same using an image?  For example

Code: [Select]
whateverfunction($rImg, 13, 0, 105, 55,$ImagePath);
Thanks a million.