Can you please help me in that error.

<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
class CoffeeEntity
{
    public $id;
    public $name;
    public $type;
    public $price;
    public $roast;
    public $country;
    public $image;
    public $review;
    
    function __construct($id, $name, $type, $price, $roast, $country, $image, $review) {
        $this->id = $id;
        $this->name = $name;
        $this->type = $type;
        $this->price = $price;
        $this->roast = $roast;
        $this->country = $country;
        $this->image = $image;
        $this->review = $review;
    }

}


?>

Select all Open in new window

I am trying to pass in the value ASC to the database for a query but the error I get is:

Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''ASC''
Here is what I am sending via Ajax for testing:

var sort = 'ASC';
$.ajax({
        url: url + '/Admin/test',
        type: 'POST',
        dataType: 'json',
        data: {sort: sort}
    })

Select all Open in new window

Controller:

    $data = [

        'sort' => $_POST['sort']
    ];

$reminders = $this->Model->Sort($data);

Select all Open in new window

DB Query:

$this->db->query("SELECT fields
FROM tables
ORDER BY name :sort ");
$this->db->bind(":sort", $data['sort']);
$results = $this->db->resultSet();
return $results;

Select all Open in new window

Hello
I want to free my future site's visitors from having to fill out the form before submitting their name, e-mail and a phone No. Basically, in most cases it won't be needed for them to also add more information in the form's text box. But the default (current) status is that they must at least type a single word before they're allowed to submit the form. I'll attach screenshot to better clarify the issue and also provide a link to a live site where you can see it in a real life situation.

https://www.profilecreations.co.za/index.php/products/desktop-stationery/blockpads/pvc-blockpad-detail

It's a Joomla's Virtuemart shop. Latest Joomla version and VM3 working together. In a product detail page there's an "Ask A Question" button. After it's clicked, you get a contact form, in which one can input their contact info and fill out the text box below and press "Send your question" button just below. My goal is just to directly contact the potential client by using their e-mail or a phone number. I don't need them to necessarily provide me with more information in that text box rectangle.  What I know so far is that there's a Virtuemart controller PHP file that makes sure that the required text box is filled out before the form's submission. This one: components/com_virtuemart/controllers/productdetails.php I'll also attach it to this post. It must be modified so that there wouldn't be a requirement of filling out that text box befere one can submit the form. Here's the …

I want to be able to insert a user into the user table Laravel creates by default as a result of "php artisan auth." Basically, I'm adding a column to that table that gives my user administrative privileges.

I've got it done, for the most part, but there's one thing that keeps alluding me: I want to be able to create a "request" file where I can document some validation rules. When I do that, I get some errors and I'll elaborate on that in just a minute.

The one thing I've found recently is that when you look at the User model, you see this:

<?php

namespace App;

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

class User extends Authenticatable
{
    use Notifiable;

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

    /**
     * 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',
    ];
}

Select all Open in new window

From what I gather, "authenticatable" is going to invoke some validation rules by default. On top of that, when you look at the Controller that is made by the "auth" command, you see this:

Select all Open in new window

…

Here's the error:

Too few arguments to function App\Http\Controllers\UserController::store(), 0 passed and exactly 1 expected

Here's my Controller:

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\User;
//use App\Http\Requests\CreateUserRequest;

class UserController extends Controller
{
	
	  public function __construct() {
        $this->middleware('checkRole: admin');
    }
	
    public function index()
    {
        $users = User::all();
		return view('admin/listUsers', compact('users'));
    }

   public function insertUser() {
        return view('admin.insertUser');
    }

   public function store($request)
    {
		$user = new User;
		if($input('admin_yes')=="Y") {
			$user->admin=1;
		}
		else {
			$user->admin=0;
		}
		$user->id = $request->input('user_id');
		$user->name=$request->input('name');
		$user->email=$request->input('email');
		$user->password = Hash::make($request->input('password'));
		$success='User was successfully created!';
		
		if($user->save()) {
			return View::make('/admin/displayUser')
			->with('user', $user)
			->with('newUser', 'Here\'s the user you just entered!')
			->with('adminPermissions', 'yes');
		}
    }

    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return 

Select all Open in new window

…

I'm working on some code and I'm trying to pop the hood on the login logic.

I'm trying to track down the URL that's actually handling the SELECT that will query the database and I keep seeing this:

$_SERVER['LOGIN_URL']

I see it referenced in the code, but I've yet to locate where it's actually defined.

Having googled it, I get the impression that this is a fairly common piece of syntax.

What is it and were do you find it?

I have been struggling for 2 days on trying to resolve a problem and need help. I am using localhost, Win10 and Wampserver.
My goal is to use pdftotext class for php and composer. I have been trying to follow the instructions at URL:

https://php-xpdf.readthedocs.io/en/latest/

Select all Open in new window

The first problem was trying to install composer. I already have curl installed, PHP 5.6.25 installed but when I tried installing using their curl example :

# Install composer
curl -s http://getcomposer.org/installer | php
# Upgrade your install
php composer.phar install

Select all Open in new window

it errored out.
So I installed Composer from the URL:

https://getcomposer.org/doc/00-intro.md

Select all Open in new window

and selected 'developer' and from the cmd line, I executed composer -v. It appears to be installed correctly. (In my previous attempts, I used the option of everyone but thought better of it so I uninstalled it, reboot my computer and installed using developers mode.
The next step was to download the pdftotext.
I unzipped it to my project folder, made a folder ""php-xpdf/php-xpdf" and moved the contents of the bin32 to "php-xpdf/php-xpdf"
 folder in my project folder.
I noticed that the folders in the Vendor folder, log,monolog,php-console,psr all have a composer.json file.
This is URL for the xpdf:

http://www.xpdfreader.com/download.html

Select all Open in new window

My project path is:

c:\wamp\www\PDFConvert

Select all Open in new window

My Vendor folder path is:

c:\wamp\www\PDFConvert\Vendor

Select all Open in new window

This is the original coding snippet recommended to me:

Select all Open in new window

…

Hi Experts

Could you point why this Laravel's method doesn't correctly save a new  needed column?

<?php

//  The method signature have to receive one more parameter:    $cnpj_grupo
    private function gravarRevenda($codigoFilial, $divisaoRevenda, $tamanhoRevenda, $razaoSocial, $cnpj,        $cnpj_grupo,      $gerente, $consultor){
       
   // Previous method call 
    //private function gravarRevenda($codigoFilial, $divisaoRevenda, $tamanhoRevenda, $razaoSocial, $cnpj, $gerente, $consultor){
     

      $hierarquia = Hierarquia::where('identificador',$divisaoRevenda)->first();
      $tamanho_revenda = TamanhoRevenda::where('identificador',$tamanhoRevenda)->first();
      $tipoparticipante = Tipoparticipante::where('identificador','REVENDA')->first();
      $revenda = User::where('login',$cnpj)->first();

      if (empty($revenda)){
          $revenda = new User();
          $revenda->login=$cnpj;
          $revenda->dataNascimento='1980-01-01';
          $revenda->tipoparticipante_id=$tipoparticipante->id;
          $revenda->statusparticipante_id=3;
          $revenda->sexo_id=3;
          $revenda->created_at=Carbon::now();   
      }

      if($codigoFilial != null && $codigoFilial != '')
        $revenda->numero_filial=$codigoFilial;

      $revenda->name=$razaoSocial;
      
      $revenda->cnpj=$cnpj;
      
      // EF Jan 2020
      file_put_contents('debug.log', 'CNPJ Grupo gravarRevenda =  '.$cnpj_grupo.PHP_EOL, FILE_APPEND);
      
	  //  *******  

Select all Open in new window

…

1) I have a mysql query which works fine in PHP my admin .
2) The reuslt is a table with first and last name .
3) I am not allowed to create new tables so have all the info in the meta_data.
4) I wrote a mysql query which does what I want ,
5) In PHP I am able to run the queries with test vars (meaining without the mysql vars).

6 )The Question :
How do I pass in one variable a mysql query with multiple rows.
7) my php code loop which works with single sql statmens is(this is just the loop part as code is large:
(note this code works as it's requesting a set id).

$mysqli;
	/* check connection */
$getTodaysEventsFromLastPostID ="SELECT * FROM wp_postmeta WHERE post_id =267";
	if (mysqli_connect_errno()) {
		printf("Connect failed: %s\n", mysqli_connect_error());
		exit();
	}
	$QueryVar1= $mysqli->query("SELECT @post_id:= post_id FROM wp_postmeta WHERE meta_key LIKE 'etimeclockwp-in%'");
	$QueryVar2 =$mysqli->query("SELECT @uid:= meta_value FROM wp_postmeta WHERE  meta_key ='uid';");
	$totalQuery=$mysqli->query("SELECT  @post_id,@uid;");
	$query = $getTodaysEventsFromLastPostID ;
	$result = $mysqli->query($query);

	while($row = $result->fetch_array())
	{
		$rows[] = $row;
		//print_r($row);
	}

	foreach($rows as $row)
	{
		echo $row['0']."<br>";
	}

	/* free result set */
	$result->close();

	/* close connection */
	$mysqli->close();

Select all Open in new window

7 )Pure mysql query is:

SELECT @surname:= meta_value FROM wp_postmeta WHERE meta_key = 'etimeclockwp_surname' AND post_id=@uid;
SELECT @name:= meta_value FROM wp_postmeta WHERE meta_key = 'etimeclockwp_name' AND post_id=@uid;
SELECT @name,@surname;

Select all Open in new window

Dear Experts,

I use PHP and get the data like below.

$obj  = json_decode($server_output);

echo $output= $obj->result;

//the out put is:
{"CancelReturnCode":0,"CancelReturnData":"VPS-50026","ReferenceCode":"991770","Jcode":"123456","TimeStamp":"13.01.2020 15:17:37"}
 
 How can I get the result of the Jcode? thank you

Can you please tell me how to i fix that error?  Thanks.

SOMETHING IS WRONG HERE: function mysqli_fetch_all($result, MYSQLI_ASSOC)

Warning: mysqli_connect(): (28000/1045): Access denied for user 'HarrisK'@'ip-107-180-46-230.ip.secureserver.net' (using password: YES) in /home/hfll4ovlkhjz/public_html/config/db_connect.php on line 3
Connection error: Access denied for user 'HarrisK'@'ip-107-180-46-230.ip.secureserver.net' (using password: YES)
Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in /home/hfll4ovlkhjz/public_html/index.php on line 6

Fatal error: Uncaught Error: Call to undefined function mysqli_fetch_all() in /home/hfll4ovlkhjz/public_html/index.php:8 Stack trace: #0 {main} thrown in /home/hfll4ovlkhjz/public_html/index.php on line 8

Select all Open in new window

<?php
	include('config/db_connect.php');
	// write query for all pizzas
	$sql = 'SELECT title, ingredients, id FROM pizzas ORDER BY created_at';
	// get the result set (set of rows)
	$result = mysqli_query($conn, $sql);
	// fetch the resulting rows as an array
	$pizzas = mysqli_fetch_all($result, MYSQLI_ASSOC);
	// free the $result from memory (good practise)
	mysqli_free_result($result);
	// close connection
	mysqli_close($conn);
?>

<!DOCTYPE html>
<html>
	
	<?php include('templates/header.php'); ?>

	<h4 class="center grey-text">Pizzas!</h4>

	<div class="container">
		<div class="row">

			<?php foreach($pizzas as $pizza): ?>

				<div class="col s6 m4">
					<div class="card z-depth-0">
						<img src="img/pizza.svg"class="pizza">
						<div class="card-content center">
							<h6><?php echo htmlspecialchars($pizza['title']); ?></h6>
							<ul class="grey-text">
								<?php foreach(explode(',', $pizza['ingredients']) as $ing): ?>
									<li><?php echo htmlspecialchars($ing); ?></li>
								<?php endforeach; ?>
							</ul>
						</div>
						<div class="card-action right-align">
							<a class="brand-text" href="details.php?id=<?php echo $pizza['id'] ?>">more info</a>
						</div>
					</div>
				</div>

			<?php endforeach; ?>

		</div>
	</div>

	<?php include('templates/footer.php'); ?>

</html>

Select all Open in new window

Can you please tell me why its not showing a create button next to databases?  Thanks.