PHP - Questions About "new Thread, New Reply" Mysql Database - Php

Hi guys

I'm struggling a bit, I need to replace a word that occurs multiple times in text with an array("up","down","forward","backwards") of words.


$find = "left";
$replace = array("up","down","forward","backwards");
$text = "left left left left";

echo str_replace($find,$replace,$text);


The Output is: array array array array

Did try this with a foreach statement as well, but no luck. Is there a better way of doing this? 

Thanks

cant work out this mysql syntax error
"operation":"medupdate","medid":"","name":"ibo","medyear":"5","medmonth":"21","medday":"1","recuser":1,"SuccFail":"fail","SuccFailMessage":"error occured 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 '''WHERE med_id=' at line 2","ResultData":""}

Code: [Select]
$sql="update metodology set med_description='".$req['name']."',
  med_year='".$req['medyear']."', med_month='".$req['medmonth']."', med_day='".$req['medday']."', med_recorddate= now(), med_recorduserid= 1'";
  $sql.= " WHERE med_id=".$req['medid'];

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've already made fully working create topic, etc; what would I need to make to reply to a thread?

I've gotten this so far...
<?php
$result = mysql_query("SELECT id FROM b ORDER BY id DESC");
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
    printf("<a href='reply.php?id=%s'>Reply</a><hr><br /><br />", $row[0]);
}

mysql_free_result($result);
?>
reply.php?id=%s (%s equaling the thread id) when I click it, it does bring me to the appropriate page, but I don't know where to go from there. Any help? 
any other info you might need just ask

"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'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';
}
}

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!

Hello All,

I have a custom session.set_save_handler to handler sessions for my application. It seems to work fine. The database table is of type innodb. I see some errors in my log file of the nature, "(1205) Lock wait timeout exceeded; try restarting transaction".

I have a class which contains the session handler callbacks and have made it a singleton class.

 session_set_save_handler(
        array($this, "db_open"),
        array($this, "db_close"),
        array($this, "db_read"),
        array($this, "db_write"),
        array($this, "db_destroy"),
        array($this, "db_gc")
        );

In my "db_read" method, I am doing a "SELECT FOR UPDATE" on the row with the session id. So, while performing load testing on my app. which has a lot of ajax calls, I noticed the "lock wait timeout" errors.

How do I resolve this problem? Any suggestions?

1) Should I catch these errors and issue a explicit "commit" in the read or write methods?
2) Should I specify a higher timeout value for "innodb_lock_wait_timeout"?

Thanks

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!

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 was wondering how to write something like this:

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

I am confused where to put ( ) and '

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