PHP - How To Handle "lock Wait Timeout" Errors In Database-based Sessions?

I am getting the following error when using composer: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"?

Just started.  I am pretty sure composer.json wasn't changed.  journalctl doesn't show anything.  Maybe Doctrine related, however, nothing seems to help.

Any ideas?
 

[michael@devserver www]$ php -v
PHP 7.3.4 (cli) (built: Apr  2 2019 13:48:50) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.3.4, Copyright (c) 1998-2018 Zend Technologies
    with DBG v9.1.9, (C) 2000,2018, by Dmitri Dmitrienko
[michael@devserver www]$ composer -V
Composer version 1.4.2 2017-05-17 08:17:52
[michael@devserver www]$ yum info composer
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.us.oneandone.net
 * epel: mirror.rnet.missouri.edu
 * extras: mirror.us.oneandone.net
 * remi-php73: mirror.bebout.net
 * remi-safe: mirror.bebout.net
 * updates: mirror.us.oneandone.net
Installed Packages
Name        : composer
Arch        : noarch
Version     : 1.8.4
Release     : 1.el7
Size        : 1.8 M
Repo        : installed
From repo   : epel
Summary     : Dependency Manager for PHP
URL         : https://getcomposer.org/
License     : MIT
Description : Composer helps you declare, manage and install dependencies of PHP projects,
            : ensuring you have the right stack everywhere.
            :
            : Documentation: https://getcomposer.org/doc/

[michael@devserver www]$ composer update
Loading composer repositories with package information
Updating dependencies (including require-dev)


  [ErrorException]
  "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"?


update [--prefer-source] [--prefer-dist] [--dry-run] [--dev] [--no-dev] [--lock] [--no-custom-installers] [--no-autoloader] [--no-scripts] [--no-progress] [--no-suggest] [--with-dependencies] [-v|vv|vvv|--verbose] [-o|--optimize-autoloader] [-a|--classmap-authoritative] [--apcu-autoloader] [--ignore-platform-reqs] [--prefer-stable] [--prefer-lowest] [-i|--interactive] [--root-reqs] [--] [<packages>]...

[michael@devserver www]$

 

This topic has been moved to Linux.

http://www.phpfreaks.com/forums/index.php?topic=318175.0

I am currently creating a form and I want to populate a drop down selection menu with data from two fields in a form. For example, I want it to pull the first and last name fields from a database to populate names in a drop down menu in a form. I want the form to submit to the email address of the person selected in the drop down. Is this possible to do? The email is already a field in the record of the person in the database.

Can anyone give me some pointers or advice on how I should go about setting up the "Select" box drop down? I am not sure how to code it to do what I am wanting. Any links to relevant help would be appreciated too.

Thanks in advance!

I've been trying to simplify this code, let alone make it work.  It's a loop to change the different question checkboxes to "checked" if certain degree_ids are found.  All of the examples i have looked at are very strange and I'm not sure how to go about this, thought it seems to be a common question.  Everyone seems to have their own way.  Any advice would be greatly appreciated.

for($i =1; $i <= $arraycount; $i++){
$query = "SELECT degree_id FROM `user-degree` WHERE `user_id` = '".$user_id."' AND degree_id = '".$i."'";
$result = $conn->query($query) or die(mysql_error());
$row = mysqli_fetch_array($result) ;

echo $row['degree_id'];

if(!$y){
$y = 0;
}

if ($row['degree_id'] == 1){
$q4[0] = 'checked';
}
if ($row['degree_id'] == 2){
$q4[1] = 'checked';
}
if ($row['degree_id'] == 3){
$q4[2] = 'checked';
}
if ($row['degree_id'] == 4){
$q4[3] = 'checked';
}
if ($row['degree_id'] == 5){
$q4[4] = 'checked';
}
if ($row['degree_id'] == 6){
$q4[5] = 'checked';
}
if ($row['degree_id'] == 7){
$q4[6] = 'checked';
}
if ($row['degree_id'] == 8){
$q4[7] = 'checked';
}
if ($row['degree_id'] == 9){
$q4[8] = 'checked';
}
}

"BACK" or REFRESH: Preventing database interaction / code execution
how to prevent database interaction / code execution when user presses back or refresh button?
can i detect?
can i disable back/refresh?

I am creating a new forum software known as Iforum, it will  use php and a database. I just started this yesterday and I all ready have the registration/login system up and working as well as connected to the database.  I have selected the CKeditor for my forum (I was initially thinking of using the TinyMCE editor) I can't seem to figure out how when you click the "Post New Thread Button" How to send the information to the database and then carry the user back to the thread. (I am good with php, html, and CSS but I am not great with databases
Any suggestions?

Hi, I currently have an if, elseif, else program that starts off with

Code: [Select]
if( $v_name == "" || $v_msg == "" )
echo "something"
how do I turn this into a switch?

but the very next elseif I have

Code: [Select]
elseif( strcspn( $_REQUEST['msg'], '0123456789' ) == strlen( $_REQUEST['msg'] ) )
echo "something"

is it possible to turn this into a switch with 2 different strings like that to evaluate?

This topic has been moved to PHP Installation & Configuration.

http://www.phpfreaks.com/forums/index.php?topic=347922.0

I have a registration form on my website and after Registration I want the user to activate first his account. I don't have problem on sending this email to the user. What I want to appear is like this..

GoodDay "username",

Blah Blah!

how can you actually do that? I know that you can do that through session variables but the thing is email's can't accept scripts on sending emails. how can I get the value from a session variable for example and convert it to plain html text so that i can OUTPUT it to the email.. HELP PLEASE!

<?php

require_once('upper.php');

require_once('database.php');

echo $error_msg='';

if(isset($_POST['submit']))

{

$LoginId=mysqli_real_escape_string($dbc,trim($_POST['LoginId']));

$Password1=mysqli_real_escape_string($dbc,trim($_POST['Password1']));

$Password2=mysqli_real_escape_string($dbc,trim($_POST['Password2']));

$Name=mysqli_real_escape_string($dbc,trim($_POST['Name']));

$Age=mysqli_real_escape_string($dbc,trim($_POST['Age']));

$BloodGroup=mysqli_real_escape_string($dbc,trim($_POST['BloodGroup']));

if(!isset($_POST['Sex']))

{

echo 'Please enter Sex<br>';

}

else{

$Sex= mysqli_real_escape_string($dbc,trim($_POST['Sex']));

}

$Qualification=mysqli_real_escape_string($dbc,trim($_POST['Qualification']));

$ContactNumber=mysqli_real_escape_string($dbc,trim($_POST['ContactNumber']));

$Email=mysqli_real_escape_string($dbc,trim($_POST['Email']));

$Address=mysqli_real_escape_string($dbc,trim($_POST['Address']));

$AboutYourself=mysqli_real_escape_string($dbc,trim($_POST['AboutYourself']));

//$countCheck=count($_POST['checkbox']);

//echo $countCheck;

//$checkbox=$_POST['checkbox'];

//$countCheck=count($checkbox);

    if(empty($LoginId)){echo 'Please enter Login Id';}

    elseif(empty($Password1)){echo 'Please enter Password';}

    elseif(empty($Password2)){echo 'Please confirm Password';}

    elseif($Password1!==$Password2){echo 'Password didn\'t match';}

        elseif(empty($Name)){echo 'Please enter Name';}

        elseif(empty($Age)){echo 'Please enter Age';}

        elseif(!isset($_POST['Sex'])){}

        elseif(empty($Qualification)){echo 'Please enter Qualification';}

        elseif(empty($ContactNumber)){echo 'Please enter Contact Number';}

        elseif(empty($Email)){echo 'Please enter Email';}

        elseif(empty($Address)){echo 'Please enter Address';}

        elseif(empty($AboutYourself)){echo 'Please enter About Yourself';}

        elseif(!isset($_POST['checkbox'])){ echo 'You have to register at least one activity.';}

        else

        {

        require_once('database.php');

        $query="select * from registration where LoginId='$LoginId'";

        $result=mysqli_query($dbc,$query);

        if(mysqli_num_rows($result)==0)    

        {        

        $checkbox=$_POST['checkbox'];

        $countCheck=count($_POST['checkbox']);

        $reg_id=' ';

        for($i=0;$i<$countCheck;$i++)

        {

        $reg_id=$reg_id.$checkbox[$i].',';

        }

        $query="insert into registration (LoginId,Password,Name,Age,BloodGroup,Sex,Qualification,ContactNumber,Email,Address,AboutYourself,Activity)values ('$LoginId',SHA('$Password1'),'$Name','$Age','$BloodGroup','$Sex','$Qualification','$ContactNumber','$Email','$Address','$AboutYourself',',$reg_id')";

        $result=mysqli_query($dbc,$query) or die("Not Connect");

        

        echo ' Dear '.$Name.'.<br>Your Account is waiting for approval<br>';



        //header('Location: index.php');

        //    header('Location: Registration.php');

        }

        else

        {

        echo 'Dear '.$Name. ', <br> An account already exist with login-id<b> '.$LoginId.'</b> <br>Please try another login-id';

        }}    

}        

?>



<html>





<body>



<?php

echo $error_msg; ?>



<form action='<?php echo $_SERVER['PHP_SELF'];?>' method='post'>

<div class="registration_and_activity">



<table border="0" width="400">

<tr><td colspan="2">

<h3>New User?</h3></td></tr>

<tr><td width="120">

Enter Login id</td><td><input type='text' name='LoginId' value='<?php if(!empty($LoginId))echo $LoginId;?>' /></td></tr>

<tr><td>

Enter Password</td><td><input type='password' name='Password1' value='<?php if(!empty($Password1))echo $Password1;?>' /></td></tr>

<tr><td>

Confirm Password</td><td><input type='password' name='Password2' value='<?php if(!empty($Password2))echo $Password2;?>' /></td></tr>

<tr><td>

Enter Name</td> <td><input type='text' name='Name' value='<?php if(!empty($Name))echo $Name;?>' /></td></tr>

<tr><td>

Enter Age</td><HEAD>

   <SCRIPT language=Javascript>

      

      function isNumberKey(evt)

      {

         var charCode = (evt.which) ? evt.which : event.keyCode

         if (charCode > 31 && (charCode < 48 || charCode > 57))

            return false;



         return true;

      }

      

      

     

   </SCRIPT>

   </HEAD>

<td><INPUT onkeypress='return isNumberKey(event)' type='text' name='Age' value='<?php if(!empty($Age))echo $Age;?>'/></td></tr>



<tr><td>

Enter Blood</td><td><input type='text' name='BloodGroup'value='<?php if(!empty($BloodGroup))echo $BloodGroup;?>' /></td></tr>



<tr><td>

Enter Sex</td><td><input type='radio' name='Sex' style='width:16px; border:0;' 'value='Male' />Male   <input type='radio' name='Sex' style='width:16px; border:0;' 'value='Female' />Female</td></tr>



<tr><td>

Enter Qualification</td><td><input type='text' name='Qualification' value='<?php if(!empty($Qualification))echo $Qualification;?>' /></td></tr>



<tr><td>

Enter Contact Number </td><td><input onkeypress='return isNumberKey(event)'type='text' name='ContactNumber' value='<?php if(!empty($ContactNumber))echo $ContactNumber;?>' /></td></tr>



<tr><td>

Enter Email</td><td><input type='text' name='Email' value='<?php if(!empty($Email))echo $Email;?>' /></td></tr>



<tr><td>

Enter Address</td><td><input type='text' name='Address' value='<?php if(!empty($Address))echo $Address;?>' /></td></tr>





<tr><td>

About Yourself :</td></tr>

<tr><td colspan="2"><textarea rows='10' cols='40' name='AboutYourself' value='<?php if(!empty($AboutYourself))echo $AboutYourself;?>' /></textarea></td></tr>

<tr><td>



<?php echo"

<tr><td colspan='2'><b>Select fields for which you want to register</b></td></tr>";



require_once('database.php');

$query="select * from activity";

$result=mysqli_query($dbc,$query);

while($row=mysqli_fetch_array($result)){

$Title=$row['Title'];

$ActivityId=$row['ActivityId'];

echo "<tr><td>$Title</td>";

//echo $ActivityId;

[B]echo "<td><input type='checkbox' name='checkbox[]' value=$Title [/B]style='width:14px; text-align:right;'/></td></tr>";//value=$ActivityId tells ActivityId variable extracts with name="checkbox"

echo "<br/>";

}

echo "<tr><td colspan='2' align='center'><input type='submit' value='Register' name='submit' style='background:url(./images/button_img2.png) no-repeat 10px 0px; width:100px; padding:3px 0 10px 0; color:#FEFBC4; border:0;'/></td></tr><br>";

    

echo " </td></tr></table>



</div>



</form>

</body>

</html>";

require_once('lower.php');

?>

In above code when $Title="Fire" or any single word, it inserts in database properly but when $Title="Terrist Attack" or any data more than one word it inserts only the first word "Terrist".
I want to insert the whole "Terrist Attack " as it is in database.........
What i should do??????????/
Plzzzzzzzzzzz help Anyone????????????

I was wondering how to write something like this:

if (table1.column1 + table2.column2 > table3.column3  then .....

I am confused where to put ( ) and '

If I run this:
mysql_query("CREATE DATABASE IF NOT EXISTS `{$this->db['db']}`", $this->tdb);

Will mysql_query() return true or false if the database already exists?

I can not run this on my server due to permissions.

I'm hoping someone can shed a bit of light on what is wrong with my code here as I've been playing around with it for a few hours and haven't solved the riddle!


 $fp=@fopen("test.txt","r") or die ("Cannot open the file, not there!");

 while ($line=@fgets($fp, 1024)) {
 $list = explode("\n", trim($line)); 
 sort($list);
 $count = count($list);
 for($i=0;$i<$count;$i++){
 print "<option>".$list[$i];
 }}
 @fclose($fp) or die ("Still open!!!");
 ?>
</select>
</form>

my text file looks like this
Canada
Brazil
US
Mexico

I'm trying to explode that text file into an array, sort it, and populate the options box. This isn't working, and all the different iterations I've tried are yielding no success either...   

Been just trying to test out some basic code that utilizes gd.  In Chrome i receive a blank page.  In firefox I get "The image "image.php" cannot be displayed because it contains errors".  There is no whitespace before or after the php tags, which seems to cause this error sometimes. 
 
$image = imagecreate(200,20);
$background = imagecolorallocate($image, 0, 0, 0);
$foreground = imagecolorallocate($image,255,255,255);
imagestring($image, 5, 5, 1, "Test", $foreground);
header("Content-type: image/jpeg");
$imagejpeg($image);

I am just following a tutorial, and at this point in the tutorial i should get at least some garbled text, if not an image.

I looked at other common causes.  gd2 is un-commented in php.ini.

phpinfo shows:
GD Support   enabled
GD Version   bundled (2.0.34 compatible)
FreeType Support   enabled
FreeType Linkage   with freetype
FreeType Version   2.4.3
GIF Read Support   enabled
GIF Create Support   enabled
JPEG Support   enabled
libJPEG Version   6b
PNG Support   enabled
libPNG Version   1.2.46
WBMP Support   enabled
XBM Support   enabled
gd.jpeg_ignore_warning  0   0

I have not found any other solutions to try, or maybe I have made an error is checking these solutions.  Any advice with be great!  Thank you for your time.

Hello,

If i have a title like "It's Wonderful!" it always gets displayed as "It?s Wonderful!" and the ? is always in a black diamond.

How can i get it to show a ' properly?

Thanks