PHP - "query Was Empty"

Hello Everyone,

I am having issues where people are submitting null characters on my website (I.e. %00).  Currently, I check if their is a value by using the empty function, and I also am checking if the value after running the trim command is =="".  How can I check for these special characters to make sure that whatever they are submitting actually contains some sort of legitimate value?

Thanks!

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

An insert function is not inserting.  I keep getting "Could not store data, please try again."

After some probing, it seems that "$result = $conn->query($user_degree_insert_query); " is where the problem is.  Variables before it seem to pass testing.  I can't figure out why this line is messing thins up though.

Any idea?  Thank you in advance for your help!

The "//$degree_id = mysql_fetch_array($degree_id_query, MYSQL_BOTH) ;" is commented out because it was giving me trouble, i replaced it with the line above that


                $conn = db_connect();

$arraycount = count($degree_Array);

//loop through the categories chosen and add them each into member-category
for($i =0; $i < $arraycount; $i++){ 
$degree_id_query = "SELECT degree_id FROM degree WHERE degree_type ='".$degree_Array[$i]."'";
$result = $conn->query($degree_id_query);

//place the id found into the array, which automatically cancatonates it.
$degree_id = $result->fetch_array();

//$degree_id = mysql_fetch_array($degree_id_query, MYSQL_BOTH) ;

$user_degree_insert_query = "INSERT INTO user-degree (
`user_id` ,
`degree_id`
)
VALUES (
'".$user_id."', '".$degree_id[0]."'
)";

$result = $conn->query($user_degree_insert_query); 

if($result) {
header("Location: survey2.php"); 
}else { 
echo "<p>Could not store data, please try again.</p>"; 
exit;

Hi.  I have just one question (I have searched for an answer for this but have not been able to locate one):

How do you go about changing the text on a "Submit Query" button to display simply "Submit"?

Below is the current code for the page that displays said button.

Thank-you in advance for any help or direction.

<?php
include 'connection.php';

$query = "SELECT * FROM people";

$result = mysql_query($query) or die(mysql_error());

while ($person = mysql_fetch_array($result)){

        echo  $person ['name'];
echo  $person ['descrip'];
}
?>

<H1>Add Your Review:</H1>
<form action="create.php" method="post">
     Subject <input type="text" name="inputName" value=""/>
     </br >
     Review <textarea cols="50" rows="4" name="inputDesc" value=""/></textarea>
     </br >
    <input type= "submit" name= "submit"/>
</form>

<html>
<head></head>
<body>
<p>The current second is <span style='font-size:16px;font-weight:bold;color:red;position:absolute;right:25px;'><?php echo time(); ?></span> on this computer.</p>
</body>
</html>

This topic has been moved to MySQL Help.

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

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!

I am trying to make a simplified query by example search form for my website.
I would like to allow my users to do more complicated queries from one my prospects table.
The user will be able to search by 1 or more field(s), select the operator for each field & enter the search value for each field.
The advanced_search .php file is below:
Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Advanced Query</title>
</head>

<body>
<form name="form1" method="post" action="do_advanced_search.php">
<table border="0" cellspacing="5" cellpadding="5">
  <tr>
    <th>Field Name</th>
    <th>Operator</th>
    <th>Value</th>
  </tr>
  <tr>
    <td><input name="company_name" type="text" id="company_name" value="Company Name" readonly="readonly" /></td>
    <td><select name="company_operator" size="1" id="company_operator">
      <option value="=" selected="selected">=</option>
      <option value="&lt;&gt;">Not Equal</option>
      <option value="Like %...%">Like %...%</option>
    </select></td>
    <td><input type="text" name="company_value" id="company_value" /></td>
  </tr>
  <tr>
    <td><input name="state" type="text" id="state" value="State" readonly="readonly"/></td>
    <td><select name="state_operator" size="1" id="state_operator">
      <option value="=" selected="selected">=</option>
      <option value="&lt;&gt;">Not Equal</option>
      <option value="Like %...%">Like %...%</option>
    </select></td>
    <td><input type="text" name="state_value" id="state_value" /></td>
  </tr>
  <tr>
    <td><label>
      <input name="County" type="text" id="County" value="County" readonly="readonly" />
    </label></td>
    <td><select name="county_operator" size="1" id="county_operator">
      <option value="=" selected="selected">=</option>
      <option value="&lt;&gt;">Not Equal</option>
      <option value="Like %...%">Like %...%</option>
    </select></td>
    <td><input type="text" name="county_value" id="county_value" /></td>
  </tr>
  <tr>
    <td><input name="city" type="text" id="city" value="City" readonly="readonly" /></td>
    <td><select name="city_operator" size="1" id="city_operator">
      <option value="=" selected="selected">=</option>
      <option value="&lt;&gt;">Not Equal</option>
      <option value="Like %...%">Like %...%</option>
    </select></td>
    <td><input type="text" name="city_value" id="city_value" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td><label>
      <input type="submit" name="button" id="button" value="Search" />
      </label></td>
    <td>&nbsp;</td>
  </tr>
  </table>
</form> 
</body>
</html>
The do_advanced_search.php is below:
$connection=mysql_connect($servername,$dbusername,$dbpassword);
$db=mysql_select_db($dbname,$connection) or die(mysql_error());

$sql=mysql_query("SELECT * FROM smf_prospects where companyname '". $_POST['company_operator'] ."' '" . $_POST['company_value'] ."' AND state '" . $_POST['state_operator'] ."' '" . $_POST['company_value'] ."' AND county '". $_POST['county_operator'] ."' '" . $_POST['county_value'] . "');
echo $sql;
$result=mysql_query($sql,$connection) or die(mysql_error());

while($row=mysql_fetch_array($result)) {
$comapanyname= $row['companyname'];
$state=$row['state'];
$county=$row['county'];
}
echo $companyname;
echo $state;
echo $county;

?>
Any help would be greatly appreciated.
I will poet a completed version of this once it is finished.

Thank you,
Terry Mullins

Hi all,

Using a form with check boxes divided into different categories, I collect data selected by the user.

I now want to combine each choice in each category with each choice in the other categories and list the combinations to the user.

If the user chooses one or more options in each category, it is relatively easy to nest foreach loops, since the number of categories will always be the same. For example, if the form contains three categories of options, the code will be:

Code: [Select]
foreach ($form['cat_1'] as $k1 => $val1)
{
foreach ($form['cat_2'] as $k2 => $val2)
{
foreach ($form['cat_3'] as $k3 => $val3)
{
echo  $val1.' _ '.$val2.' _ '.$val3.'<br/>';
}
}
}

Things get complicated if the user does not select options within a given category. More generally, I want to be able to generate the list regardless of the number of categories in which the user selects options.

Thank you in advance for your advice.

hello,

I was wondering what is the point of writing

for a dropdown: <?php if ($_POST[inputfieldID] == "value") { echo "selected"; } ?>

or for a checkbox/ radio button: <?php if ($_POST['cb/radioID'] == "value") { echo "checked"; } ?>

I guess it's for after submit, if there is any error, the values filled will still be echoed in the inputfield, or am i wrong?

But then if that is true, i have a php search box where i use AJAX object to to send all the input they filled in after submit. But after pushing submit the inputted values remain.

I guess when using AJAX to send the information i don't need  <?php if ($_POST[inputfieldID] == "value") { echo "selected"; } ?> in my html forms?


Little confused Can maybe somebody bring clearness

Hey guys!
I have the following doubt:

I have a php file that does the following alongside with other code not displayed he

$fp = fopen("emails.txt", "w");

It opens a txt file called emails.txt that is in the same folder where the php is saved but how do I tell $fp = fopen("/folderbefore/emails.txt", "w"); ??

In other words, how do I write the path on the script that the emails.txt is located in a previous folder where the php file is located??

Thanks in advance for your help
Cheers!