PHP - "is Being Viewed By Now.." Question

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

Hey guys,

I'm new to PHP and I'm currently teaching myself. I'm looking over some code and I'm confused when to use "." inside of code. Can someone please explain to me?

Here's some example code I read from a book:

<?php
$counter = 1;
while ($counter <= 12) {
      echo $counter." times 2 is ".($counter * 2). "<br />"
      $counter++;
}
?>

Thanks!

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

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 All:
I have general question on php...

 if I have an "includes" folder, and on IE somebody goes directly to it, like:
http://www.site.com/includes
on IE, they can see the folder-tree- directory. So, files like config.php, or mysql.php could be visible.
My question is, is this safe?? couldnt people then just drag-copy the file over into their system? or somehow open it, view its contents?
I dragged-copied a .php file into my desktop, but nothing shows up when I open in in notepad. As opposed to opening another file that was also .php but which only had javascript code in it, and the javascipt did show up.
So, I take it, it should be ok?? as it seems like it works as if the .php page actually had been loaded on a web-browser... doesnt show the php code...

well, appreciate comments, feedback on this...
what woudl be the best way to protect files like this? htaccess-protect? or is this not something to be overly concerned about??
From what I can tell looks like a lot of site are setup this way... so must be ok... ha?

Thanks!

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!

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.

Hi and thanks for taking the time to read through this first and foremost. I have a bit of code that I have managed to piece together with help from other sites and what it does is connect to our local ms sql server and retrieve a few tables from our database. The info is relating to property management and it basically displays the unit address, current date and its rental status. (Occupied or Vacant)

This makes it easy for us to at a glance check the status of our rentals instead of having to log into our software and navigate through all that.. anyways, I have two issues I need help with.

First problem, in my code, is it possible to write a conditional statement that would check for a certain status in a view and then if it is there, print a simple yes or no in a table with that appropriate property.

For example, we have property 1000 name street and it is currently vacant, however the viewPendingLease shows us information regarding future bookings. I would like to be able to look through that view with the code, check property 1000 name street for any future pending leases, and if there is one, print out a "Yes" in a Future Booked column that I would create.

If any of that makes sense, I can post the print out of the tables of the viewPendingLease if it makes it easier for anyone to see the data output to understand what I am meaning.

The second issue, is it possible to change the color of the text according to a variable, say a word in a generated table with html or css? I would like to color the words vacant or occupied green and red respectively just to make it much easier to zero in on the vacant properties. Or even maybe just color every other row a background color just to help distinguish between the different properties.

Here is my code that pulls up my current tables to show Property, Street and current rented status.

Code: [Select]
<?php 

//connect to a DSN "*******" 
$conn = odbc_connect('*******','*****','************'); 

if ($conn) 
{ 
//the SQL statement that will query the database 
$query = "Select unit.PropertyUnitID, unit.Street, unit.Status, from unit";
//perform the query 
$result=odbc_exec($conn, $query); 

echo "<table border=\"1\"><tr>"; 

//print field name 
$colName = odbc_num_fields($result); 
for ($j=1; $j<= $colName; $j++) 
{ 
echo "<th>"; 
echo odbc_field_name ($result, $j ); 
echo "</th>"; 
} 

//fetch tha data from the database 
while(odbc_fetch_row($result)) 
{ 
echo "<tr>"; 
for($i=1;$i<=odbc_num_fields($result);$i++) 
{ 
echo "<td>"; 
echo odbc_result($result,$i); 
echo "</td>"; 
} 
echo "</tr>"; 
} 

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

//close the connection 
odbc_close ($conn); 
} 
else echo "odbc not connected"; 
?>

I currently have the viewPendingLease.Active (which shows if there is a future pending lease) taken out due to a repeating data issue I am also trying to figure out...

I have a table where a filed called "recruitment" can either be "0" or "1"  Why does my below code not work?

Code: [Select]
$sql_rec = ("SELECT * FROM teams WHERE team_id=".$_GET['t']." ");
$rsrec = mysql_fetch_array($sql_rec);
if($rsrec['recruitment'] == 1){
echo "Your team is <b>OPEN</b> for all members to join <br>
<a href='changemode0.php?t=".$_GET['t']."&r=".$_GET['r']." '>(click here to change mod)</a>";}
elseif($rsrec['recruitment'] == 0){
echo "Your team is <b>CLOSED</b> for all members to join <br>
<a href='changemode1.php?t=".$_GET['t']."&r=".$_GET['r']." '>(click here to change mod)</a>";}
to ask in another way: how do I make the if statement to check if the value is "1" or "0"?

This code works, I am trying to disqualify certain keywords from a website I am scraping. For some reason, the D in the word dishwasher keeps a match from happening so i have to do this without the d. I just dont understand WHY.
I tried it where both of them use Clean_String() which has a strtolower and tirm in it. The subject looks right, I tried utf8_encode() to make sure they were both the correct encoding but nothing works.

Can anyone explain why the letter D is causing the word 'dishwasher' to not trigger strpos when I have the word 'dishwasher' in my disqualify array?

$disqualify = array("ish-washer","ishwasher");
foreach($disqualify as $dis)
{
if(strpos(Clean_String($subject[0]), $dis))
{
$status = 0;
$color = "FF0000";
}
}

Hi I am using this code for directory tree ...and it is working fine except the "define("FILE_ROOT", "$VARIABLE");"  because I can't use variable in the define function ...but I need the variable as the file root in next code ...
Not working: I need this
define("FILE_ROOT", $diro);
Working cod:
define("FILE_ROOT", "store");
The index script that get the directorys and files in to the directory tree..

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<meta name="keywords"  content="" />
<meta name="description" content="" />
<title>Editable jquery tree with php codes</title>
<link rel="stylesheet" type="text/css" href="js/jquery/plugins/simpleTree/style.css" />
<link rel="stylesheet" type="text/css" href="styleis.css" />
<script type="text/javascript" src="js/jquery/jquery.min.js"></script>
<script type="text/javascript" src="js/jquery/plugins/jquery.cookie.js"></script>
<script type="text/javascript" src="js/jquery/plugins/simpleTree/jquery.simple.tree.js"></script>
<script type="text/javascript" src="js/langManager.js" ></script>
<script type="text/javascript" src="js/treeOperations.js"></script>
<script type="text/javascript" src="js/init.js"></script>
</head>
<body>
<table border='2' width='633'>
<tr>
<td>
<div class="contextMenu" id="myMenu1">
<li class="addFolder">
<img src="js/jquery/plugins/simpleTree/images/folder_add.png" /> </li>
<li class="addDoc"><img src="js/jquery/plugins/simpleTree/images/page_add.png" /> </li>
<li class="edit"><img src="js/jquery/plugins/simpleTree/images/folder_edit.png" /> </li>
<li class="delete"><img src="js/jquery/plugins/simpleTree/images/folder_delete.png" /> </li>
<li class="expandAll"><img src="js/jquery/plugins/simpleTree/images/expand.png"/> </li>
<li class="collapseAll"><img src="js/jquery/plugins/simpleTree/images/collapse.png"/> </li>
</div>
<div class="contextMenu" id="myMenu2">
<li class="edit"><img src="js/jquery/plugins/simpleTree/images/page_edit.png" /> </li>
<li class="delete"><img src="js/jquery/plugins/simpleTree/images/page_delete.png" /> </li>
</div>


<div id="wrap">
<div id="annualWizard">
<ul class="simpleTree" id='pdfTree'>
<li class="root" id='<?php echo $treeManager->getRootId();  ?>'><span><?php echo $rootName; ?></span>
<ul><?php echo $treeElements; ?></ul>


</li>
</ul>
</div>
<div>

</div>
</div> 
<div id='processing'></div>
</td>
</tr>
</table>
</body>
</html>

This is the script that makes the directory config.php :

<?php
require('connecto.php');
session_start();
error_reporting(0);
 
     $id = $_GET['id'];
 $q = "SELECT * FROM albums WHERE $id = ideo";
 $results = mysql_query($q);
 $data = mysql_fetch_array($results);
 $diro = $data['dosjeid'];
                 $id = $data['ideo'];
                 
/**************************************
 *   File Name: config.php
 *   Begin: Thursday, June, 06, 2006
 *   Author: Ahmet Oguz Mermerkaya 
 *   Email: ahmetmermerkaya@hotmail.com
 ***************************************/ 

if (!defined("IN_PHP"))
{
die();
}

/** 
 * if you want to run in demo mode, enable the macro below
 * if it runs in demo mode, it doesn't care what TARGET_PLATFORM is
 */
//define("DEMO_MODE", true);


/** target platform types
 *  this script runs for both database(mysql) and file system. 
 *  database is supposed to be mysql
 */
define ("DATABASE_PLATFORM", 0); // Don't edit
define ("FILE_SYSTEM_PLATFORM", 1); // Don't edit


/** 
 * choose target platform according to your needs 
 * it may be DATABASE_PLATFORM or FILE_SYSTEM_PLATFORM
 */
define ("TARGET_PLATFORM", FILE_SYSTEM_PLATFORM);


if (TARGET_PLATFORM == FILE_SYSTEM_PLATFORM)
{
/**
  * if FILE_SYSTEM_PLATFORM is selected as TARGET_PLATFORM,
  * then assign root folder adress to FILE_ROOT macro
  */
 
 
  $dirko = ("store/".$diro);
 
define("FILE_ROOT", $dirko);

}
else if (TARGET_PLATFORM == DATABASE_PLATFORM)
{
/**
 * if DATABASE_PLATFORM is selected as TARGET_PLATFORM,
 * set the variables to connect database and 
 * set the TREE_TABLE_PREFIX if you want to
 * change the prefix of table name
 */
// set database host 
$dbHost = "localhost";
//set database user name    
$dbUsername = "root"; 
// set password to connect to database  
$dbPassword = "21236161";
// set database name
$dbName = "php";
// set database table prefix 
define ("TREE_TABLE_PREFIX", "tree");
}
else {
die("No known target platform specified, in includes/config.php");
}


define ("SUCCESS", 1);  // Don't edit
define ("FAILED", -1);  // Don't edit
define ("FAILED_FILE_WITH_SAME_NAME_EXIST", -2); // Don't edit, it is only used in FILE_SYSTEM_PLATFORM

error_reporting(0); 
?>

And this is File tree menager.php script....

<?php
require('connecto.php');
session_start();
error_reporting(0);
 
     $id = $_GET['id'];
 $q = "SELECT * FROM albums WHERE $id = ideo";
 $results = mysql_query($q);
 $data = mysql_fetch_array($results);
 $diro = $data['dosjeid'];
                 $id = $data['ideo'];
/**************************************
     File Name: DemoTreeManager.php
     Begin:  Wednesday, April, 15, 2009, 21:49 
     Author: Ozan Koroglu
   Ahmet Oguz Mermerkaya 
     Email:  koroglu.ozan@gmail.com
       ahmetmermerkaya@hotmail.com
 ***************************************/ 

require_once("ITreeManager.php");

class FileTreeManager implements ITreeManager 
{
private $fileRoot;

const FOLDER_SEPARATOR = "FOLDER_SEPARATOR";

const DEFAULT_FOLDER_SEPARATOR = "/";

public function __construct($fileRoot) {
if (is_dir($fileRoot)) 
{
$this->fileRoot = $fileRoot;
//if ($this->fileRoot[strlen($this->fileRoot) - 1] != '/' ) {
// $this->fileRoot .= '/';
//}

}
else {
die($fileRoot .' is not a directory ');
}

}

public function insertElement($name, $ownerEl, $slave) 
{
$realOwnerEl = str_replace(self::FOLDER_SEPARATOR, self::DEFAULT_FOLDER_SEPARATOR, $ownerEl);
$fullPath = $this->getFullPath($realOwnerEl. self::DEFAULT_FOLDER_SEPARATOR . $name);

$out = FAILED;
if (file_exists($fullPath) === true) {
$out = FAILED_FILE_WITH_SAME_NAME_EXIST;
}
else {
if ($slave == 1) {
if (touch($fullPath) === true) {
$out = '({ "elementId":"'. $ownerEl . self::FOLDER_SEPARATOR . $name . '", "elementName":"'.$name.'", "slave":"'.$slave.'"})';
}
}
else{
if (mkdir($fullPath, 0755)) {
$out = '({ "elementId":"'. $ownerEl . self::FOLDER_SEPARATOR . $name .'", "elementName":"'.$name.'", "slave":"'.$slave.'"})';
}
}
}

return $out;
}


private function getFullPath($relativePath) 
{
return $this->fileRoot . self::DEFAULT_FOLDER_SEPARATOR . $relativePath;
}


public function getElementList($ownerEl, $pageName) 
{
$realOwnerEl = str_replace(self::FOLDER_SEPARATOR, self::DEFAULT_FOLDER_SEPARATOR, $ownerEl);
$fullPath = $this->getFullPath($realOwnerEl);
$str = null;



if (is_dir($fullPath) && $handle = opendir($fullPath))
{
$fileStr = null;
     /* This is the correct way to loop over the directory. */
    
    
    while (false !== ($file = readdir($handle))) 
{
if ($file == '.' || $file == '..' || $file == 'Thumbs.db'){
continue;
}
$supp = NULL;
 
if (is_dir($fullPath . "/" . $file)) {

$supp = "<ul class='ajax'>"
."<li id='". $ownerEl. self::FOLDER_SEPARATOR . $file ."'>{url:".$pageName."?action=getElementList&ownerEl=". $ownerEl. self::FOLDER_SEPARATOR . $file ."}</li>"
."</ul>";
}


$fileStr[] .= "<li class='text' id='". $ownerEl. self::FOLDER_SEPARATOR . $file."'>"
."<span>$file</span>&nbsp;&nbsp;&nbsp;<a href='".$fullPath."/".$file."'>View the file</a>"
. $supp
."</li>";



       
}


     closedir($handle);
if ($fileStr != null) {
sort($fileStr);
$str = implode($fileStr);
}
}



  return $str; 
  }
 
 
    
 
  public function updateElementName($name, $elementId,$ownerEl) 
{
$ownerEl = str_replace(self::FOLDER_SEPARATOR, self::DEFAULT_FOLDER_SEPARATOR, $ownerEl);

$newElementId = $ownerEl . self::DEFAULT_FOLDER_SEPARATOR . $name;

$elementId = str_replace(self::FOLDER_SEPARATOR, self::DEFAULT_FOLDER_SEPARATOR, $elementId);
$realElementId = $ownerEl 
. self::DEFAULT_FOLDER_SEPARATOR 
. substr($elementId, strrpos($elementId, "/"), strlen($elementId));

$fullPath = $this->getFullPath($realElementId);
//$newElementId = substr($realElementId, 0,  strrpos($realElementId, "/")). "/" . $name;

$newFullPath = $this->getFullPath($newElementId);

$out = FAILED;
if (file_exists($newFullPath) === true && dirname($fullPath) != dirname($newFullPath) ) {
$out = FAILED_FILE_WITH_SAME_NAME_EXIST;
}
else if (rename($fullPath, $newFullPath) == true) {
$newRealElementId = str_replace(self::DEFAULT_FOLDER_SEPARATOR, self::FOLDER_SEPARATOR, $newElementId);
$out = '({"elementName":"'.$name.'", "elementId":"'. $newRealElementId .'"})';
}
 
return $out;
  }
   
 
 
 
 
  public function deleteElement($elementId, &$index = 0, $ownerEl)
{

$elementId = str_replace(self::FOLDER_SEPARATOR, self::DEFAULT_FOLDER_SEPARATOR, $elementId);
$elementId = str_replace(self::FOLDER_SEPARATOR, self::DEFAULT_FOLDER_SEPARATOR, $ownerEl)
. self::DEFAULT_FOLDER_SEPARATOR 
. substr($elementId, strrpos($elementId, "/"), strlen($elementId));
  $fullPath = $this->getFullPath($elementId);

$out = FAILED;
if (is_dir($fullPath) && $this->delete_recursive_dirs($fullPath)) {
$out = SUCCESS;
}
else if (unlink($fullPath)) {
$out = SUCCESS;
}

return $out;
  } 
 
 
 
  public function changeOrder($elementId, $oldOwnerEl, $destOwnerEl, $destPosition)
{ 
$oldOwnerEl = str_replace(self::FOLDER_SEPARATOR, self::DEFAULT_FOLDER_SEPARATOR, $oldOwnerEl);
$elementId = str_replace(self::FOLDER_SEPARATOR, self::DEFAULT_FOLDER_SEPARATOR, $elementId);

$realElementId = $oldOwnerEl . self::DEFAULT_FOLDER_SEPARATOR 
 . substr($elementId, strrpos($elementId, "/"), strlen($elementId));

$fullPath = $this->getFullPath($realElementId);
$elementName = substr($realElementId, strrpos($realElementId, "/")+1); // plus 1 not to get / character
$realDestOwnerEl = str_replace(self::FOLDER_SEPARATOR, self::DEFAULT_FOLDER_SEPARATOR, $destOwnerEl);

$newFullPath = $this->getFullPath($realDestOwnerEl . "/". $elementName);

$newElementId = $destOwnerEl . self::FOLDER_SEPARATOR . $elementName;
$out = FAILED;

if (file_exists($newFullPath) === true && dirname($fullPath) != dirname($newFullPath)) {
$out = FAILED_FILE_WITH_SAME_NAME_EXIST;
}
else if (rename($fullPath, $newFullPath) == true) {
$out = '({"oldElementId":"'. str_replace(self::DEFAULT_FOLDER_SEPARATOR, self::FOLDER_SEPARATOR,  $elementId)
.'", "elementId":"'. $newElementId .'"})';;
}

return $out;  
  }

public function getRootId(){
return self::FOLDER_SEPARATOR;
}

private function delete_recursive_dirs($dirname) 
{ 
   // recursive function to delete 
  // all subdirectories and contents: 
if(is_dir($dirname)) {
$dir_handle=opendir($dirname);
}
   while($file=readdir($dir_handle)) 
   { 
     if($file!="." && $file!="..") 
     { 
       if(!is_dir($dirname."/".$file)){ 
unlink ($dirname."/".$file); 
}
     else {
     $this->delete_recursive_dirs($dirname."/".$file); 
}
      } 
   } 
   closedir($dir_handle); 
   rmdir($dirname); 
   return true; 
}

}

?>


Do someone have an concrete idea for this problem?
Please LET ME KNOW I need this fast... Thanks .