PHP - Trouble Getting My "naughty Words" Function To Work

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

$query  = "SELECT * FROM name_list WHERE Name= '$_POST[Name]' ";
$result = mysql_query($query);
while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
if ( ($row['Name']) == $_POST['Name'] ) 
      echo "ERROR";
  else echo "rest of the code";
  }


So this code compares (or it should) the name entered by the user in the form to the list of names already in database. If the user enters a name in the form that is in the database I get and "ERROR" as I should. But is they enter a name that is not in the database I am not getting "rest of the code."

Why?

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

preg_replace() asks that "Delimiter must not be alphanumeric or backslash" in the pattern.  So I changed

 $new_text = preg_replace($_POST['withthis'] ,$_POST['withthis'],$_POST['text']);
to this
$replacethis = $_POST['replacethis'];
$new_text = preg_replace("/$replacethis/",$_POST['withthis'],$_POST['text']);
It works fine, but out of curiosity, is there any way to have the POST variable as a parameter directly, and why does it not work? 

Just to try it, I attempted: "/$_POST['withthis']/"  and $_POST["/'withthis'/"] and both do not work.  str_replace is a better option I think, but I am just trying to get a better understanding of this delimiter rule.  Thanks for your time!

Hi All,

I'm having trouble with an email I'm trying to send out. While testing my code, the email that my script sends has the "Reply-To" email address in the headers but when I click "reply", the recipient's email, $to in the code below, is inserted instead of the "Reply-To" email. Am I missing anything? Thanks for the help in advance!


$to = "abc@email.com";
$headers = "From: " .$admin_name. "<" .$admin_email. ">\r\n";
$headers .= "Reply-To: " .$host_name. "<" .$host_email. ">\r\n";
$headers .= 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "<br>";
$subject = "Subject";
$body = "Body";
mail($to, $subject, $body, $headers);

I'm trying to make the simplest login and this isnt working can someone explain why?

thanks


if ($_POST['user'] == 'admin' && $_POST['pass'] != '1234') {
echo "fail";
} else {
        echo "win";


no matter what I do it says win

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?

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!

This topic has been moved to PHP Installation & Configuration.

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

Hi there - can anyone lend me a little advise as to what I'm doing wrong here.

I have this line:
$query=mysql_query("SELECT * FROM gallery a JOIN gallery_image b ON a.id = b.gallery_id where gallery_id=$gallery_id");

I am trying to add an order by statement: order by gallery_image.priority

So I created:
$query=mysql_query("SELECT * FROM gallery a JOIN gallery_image b ON a.id = b.gallery_id where gallery_id=$gallery_id order by gallery_image.priority");

But, I receive the error (even though there is table called "Gallery Image" and a column called "Priority":
Code: [Select]
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/***/public_html/***/gallery.php on line 5
select: Unknown column 'gallery_image.priority' in 'order clause'

Hi everyone,

I am just starting out with php so I am sure this is a really silly question.

I have been working through php & mySQL for dummies  (latest edition) and each time I read a new chapter I try to implement the tutorial. I have been trying something really simple from the book and have now even tried copying it word for word but it still will not work.

I am basically trying to output a list of Cities and States with the following code:

      <?php
         $capitals = array ("CA" => "Sacramento", "TX" => "Austin", "OR" => "Salem" );
         foreach ($capitals as $state => $city);
         ksort ($capitals);
         {
            echo "$city, $state<br />";
         }
         ?>
Instead of getting:

Sacramento, CA
Salem, OR
Austin, TX

I just get:

Salem, OR

I am running XAMPP on Mac OS X 10.6.5.

Any ideas or help would be awesome!

Im dealing with html links in a database where I need to execute a small piece of php code. Well mysql doesnt execute php code thats held in a table. The easiest way for me to do this is just add the links without the code, & set up a function that will replace anything I set to for example in my case a link lookin like this:

http://mysite.com/index.php?page=offers&blah=blah&sid=

needs to look like this;

http://mysite.com/index.php?page=offers&blah=blah&sid=<?php echo $_SESSION['login']; ?>

so I would need a function like

<?php
$replace('sid=','sid=<?php echo $_SESSION['login'];?>
?>

something like that.

And I know its possible & I could create a function like this but honestly right now I am so tired after working 12 hours im lazy dont want to think to hard while I know there are a lot of people out there that have a function like this already.

If you dont have one & dont feel like writing one for me could you atleast point me in the right direction so I dont have to think to hard?!

Thanks!!

...added to an error log? Currently, my coding is as follows:

Form to gather data:
Code: [Select]
<html><head><title>Car Accident Report Form</title></head>
<form action="errorlog.php" method="post">
First Name: <br><input type="text" name="name"><br>
Surname:<br> <input type="text" name="surname"><br>
Age: <br><input type="text" name="age"><br>
Weeks Since Accident: <br><input type="text" name="weeks"><br>
<input type="submit" value="Submit">
</form>

Coding for error log:
Code: [Select]
<html><head><title>Validating Car Accident Report Form Details</title></head>
<?php
$name=$_POST["name"];
$surname=$_POST["surname"];
$age=$_POST["age"];
$weeks=$_POST["weeks"];
$subtime = strftime('%c');
$pass = "The details uploaded are fine<br><br>";
if ((((trim($name)="" && trim($surname)="" && trim($age)="" && trim($weeks)=""))))
{
echo "It seems that you have not entered a value for the Name, Surname, Age or Weeks fields. This has been added to the error log.<br><br>";
error_log("<b><u>Error</b></u><br>The user has not entered any values", 3, "C:/xampp/htdocs/errorlog.txt");
}
if (($age<18)&& ($weeks<=1))
{
echo "It seems that you have entered an invalid age and number of weeks since the accident. This has been added to the error log.<br><br>";
error_log("<b><u>Error</b></u><br>The user has entered an age that is below 18 and the number of weeks since the accident is equal to or under 1 week!<br>Age entered:" . $age . "<br>Number Of Weeks Since Accident entered:" . $weeks . "<br>Time that form was submitted:" . $subtime . "<br><br>", 3, "C:/xampp/htdocs/errorlog.txt");
} 
else if ($age<18)
{
echo "It seems that you have entered an invalid age. This has been added to the error log.<br><br>";
error_log("<b><u>Age Error</b></u><br>The user has entered an age that is below 18!<br>Age entered:" . $age . "<br>Time that form was submitted:" . $subtime . "<br><br>", 3, "C:/xampp/htdocs/errorlog.txt");
}
else if ($weeks<=1)
{
echo "It seems that you have entered an invalid age number of weeks since the accident. This has been added to the error log.<br><br>";
error_log("<b><u>Week Error</b></u><br>The user has entered a number of weeks since the accident that is equal to or under 1 week!<br>Number Of Weeks Since Accident entered:" . $weeks . "<br> Time that form was submitted:" . $subtime . "<br><br>", 3, "C:/xampp/htdocs/errorlog.txt");
}
else
{
echo $pass;
}
echo "Car Accident Report Form details have been sent<br>";
echo "<a href='readlog.php'>Read Error Log</a>"
?>

</html>

How can I get it so that if a user presses the space bar in a field, then the trim function sees that there's no white space and then this gets added to the error log?

Any help is appreciated!

$query  = "SELECT * FROM School_Registrations WHERE School_Name= '$_POST[SchoolName]' ";
$result2 = mysql_query($query);
if (mysql_numrows($result2) > 0) {
while($row = mysql_fetch_array($result2))
{
echo" 
<h2>ERROR</h2>
...rest of the error code...
";} 
}
else {

mysql_query("INSERT INTO ``.`` (...all the variables...);") 

or die(mysql_error( 'Location: http://www...php' ));  
 
 echo "
...success code...


$url = 'http://www.mypage.com/page.php?';
$url .= 'email='.urlencode($_POST['email']);
 
$result = getPage('', $url, '', 15);
 
function getPage($proxy, $url, $header, $timeout) {
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_HEADER, $header);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($ch, CURLOPT_PROXY, $proxy);
    curl_setopt($ch, CURLOPT_HTTPPROXYTUNNEL, 1);
    curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout);
    curl_setopt($ch, CURLOPT_REFERER, 'http://mypage.org');
    curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.8) Gecko/2009032609 Firefox/3.0.8');
    $result['EXE'] = curl_exec($ch);
    $result['INF'] = curl_getinfo($ch);
    $result['ERR'] = curl_error($ch);
    curl_close($ch);
    return $result;
}
}
?>


Ok, so this code verifies what the name entered in the forms is not already in database. If it is it gives you the ...error code... and nothing else. If it does not it gives you ...success code... and it creates new table record, and it sends out email address entered to designated page. Bu I keep getting:

Fatal error: Call to undefined function getPage()

It still fully works, but no email goes out as defined. I am stuck. Help?