Click here to Skip to main content
15,921,028 members
Home / Discussions / Linux, Apache, MySQL, PHP
   

Linux, Apache, MySQL, PHP

 
Questionhow to get hard disk Serial Number using php on server side Pin
Lakshmanan Duraisamy26-Jul-17 23:15
Lakshmanan Duraisamy26-Jul-17 23:15 
AnswerRe: how to get hard disk Serial Number using php on server side Pin
Richard MacCutchan26-Jul-17 23:35
mveRichard MacCutchan26-Jul-17 23:35 
AnswerRe: how to get hard disk Serial Number using php on server side Pin
Jochen Arndt27-Jul-17 0:09
professionalJochen Arndt27-Jul-17 0:09 
SuggestionRe: how to get hard disk Serial Number using php on server side Pin
Richard Deeming27-Jul-17 1:31
mveRichard Deeming27-Jul-17 1:31 
QuestionPHP connecting to vb.Net Pin
Member 1296881918-Jul-17 19:48
Member 1296881918-Jul-17 19:48 
AnswerRe: PHP connecting to vb.Net Pin
Richard MacCutchan18-Jul-17 20:49
mveRichard MacCutchan18-Jul-17 20:49 
QuestionTrying to create a secure login script, just have a few questions. Pin
BlackMagix14-May-17 4:40
BlackMagix14-May-17 4:40 
AnswerRe: Trying to create a secure login script, just have a few questions. Pin
Superolmo10-Jul-17 9:09
Superolmo10-Jul-17 9:09 
QuestionSorting array and adding position numbers while/after sorting Pin
Member 131868238-May-17 4:15
Member 131868238-May-17 4:15 
QuestionHelp Pin
Member 1302311826-Apr-17 3:40
Member 1302311826-Apr-17 3:40 
AnswerRe: Help Pin
Jochen Arndt26-Apr-17 3:58
professionalJochen Arndt26-Apr-17 3:58 
GeneralRe: Help Pin
Member 1302311826-Apr-17 4:14
Member 1302311826-Apr-17 4:14 
GeneralRe: Help Pin
Jochen Arndt26-Apr-17 4:43
professionalJochen Arndt26-Apr-17 4:43 
GeneralRe: Help Pin
Member 1302311826-Apr-17 4:55
Member 1302311826-Apr-17 4:55 
GeneralRe: Help Pin
Jochen Arndt26-Apr-17 5:01
professionalJochen Arndt26-Apr-17 5:01 
QuestionHow To Add More Than One Entry On A Single Cell/Array ? Pin
Member 129567898-Apr-17 14:17
Member 129567898-Apr-17 14:17 
AnswerRe: What is the difference between web development and Web designing? Pin
ZurdoDev21-Mar-17 1:48
professionalZurdoDev21-Mar-17 1:48 
QuestionWhere do I put my jquery and AngularJS libraries in wordpress? Pin
samflex17-Feb-17 8:14
samflex17-Feb-17 8:14 
QuestionTrying to connect categories and users through pivot table i Laravel Pin
Duško Oljača3-Feb-17 1:21
Duško Oljača3-Feb-17 1:21 
I have users and categories tables and pivot table categorie_users in database. In controller I make that every user can create your own categories and I make check if some category exist and if logged user have that category, he can't create new category with same name and that works fine. So next what I want is 'else' - if category exist and logged user don't have that category but he want to create it - in that case I want to connect that category which already exist and that user. Other words - I want to, let's say, category 'Music' to be just one category with that name for all future users. This is so complicated so any suggestions will appreciate. Thanks.
This is my CategoriesController.php

       public function store(Request $request)
    {
		$user = Sentinel::getUser();
		
		$category = Categories::where('name', $request->name)->get();
		
		foreach ($category as $cat){
			$user = CategorieUser::where('categorie_id',$cat->id)->where('user_id', $user->id);
		}
		
		if($category->count() > 0){
			if($user->count() > 0){
				return redirect()->route('categories.index');
			}
			else{

				/*THIS IS THAT 'else' FROM ABOVE QUESTION*/

			}
		}
		else{
			$categories = new Categories();
			$categories->name = $request->name;
			$categories->sections_id = $request->sections_id;
			$categories->save();
			$categories->users()->sync([$user->id]);
		}		
		session()->flash('success', "New category '{$categories->name}' has been created.");
		return redirect()->route('categories.index');
    }

    
And this is my model Categories.php

       <?php

        namespace App\Models;

        use Illuminate\Database\Eloquent\Model;

        class Categories extends Model
        {
	       protected $table = 'categories';

          public function sections()
          {
            return $this->belongsTo('App\Models\Sections');
          }
	
	      public function users()
          {
            return $this->belongsToMany('App\Models\Users', 'categorie_user','categorie_id','user_id');
         }
	
       }
This is model Users.php
        
        <?php

        namespace App\Models;

        use Illuminate\Database\Eloquent\Model;

        class Users extends Model
        {
	         protected $table = 'users';


	      public function categories()
		  {
			return $this->belongsToMany('App\Models\Categories', 'categorie_user','user_id','categorie_id');
		  }
	
      }

And this is pivot model CategorieUser.php (which I must create that I can go through foreach loop) 

       <?php

        namespace App\Models;

        use Illuminate\Database\Eloquent\Model;

        class CategorieUser extends Model
        {
            protected $table = 'categorie_user';
	
	
	      public function categories(){
		   return $this->belongsTo('App\Models\Categories', 'categorie_id');
	      }
	
        }

AnswerRe: Trying to connect categories and users through pivot table i Laravel Pin
Afzaal Ahmad Zeeshan3-Feb-17 2:10
professionalAfzaal Ahmad Zeeshan3-Feb-17 2:10 
QuestionOutputting ROW QUERY result to main program Pin
ELMAGLAYA16-Jan-17 21:19
ELMAGLAYA16-Jan-17 21:19 
AnswerRe: Outputting ROW QUERY result to main program Pin
Richard MacCutchan16-Jan-17 21:53
mveRichard MacCutchan16-Jan-17 21:53 
QuestionHow to fix this error $_SESSION:Notice: Undefined offset: 0 Pin
ELMAGLAYA4-Jan-17 18:45
ELMAGLAYA4-Jan-17 18:45 
AnswerRe: How to fix this error $_SESSION:Notice: Undefined offset: 0 Pin
Jochen Arndt4-Jan-17 22:16
professionalJochen Arndt4-Jan-17 22:16 
GeneralRe: How to fix this error $_SESSION:Notice: Undefined offset: 0 Pin
ELMAGLAYA16-Jan-17 21:33
ELMAGLAYA16-Jan-17 21:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.