PHP - &quot Inside Of Db

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

This topic has been moved to PHP Installation & Configuration.

http://www.phpfreaks.com/forums/index.php?topic=347922.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!

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.

I'm a very new PHP user (as in, I just started today) and need to make a set of navigation buttons which will take the user to "next" or "previous" pages. I assume that the $_GET function is involved, but I don't know how to do it.

It needs to work like this:

If the URL looks like "http://website.com/page1.php"

I need the "next" button (a href image) to change it to "/page2.php", and while on page 2, for the "previous" button to take the user to "/page1.php" and so forth. How can I cause the page number to increment or decrease respective to the href image being clicked?

In the following code the sign "\" is used before "/index.php?....". What does this sign mean in a link statement?
Does it mean it automatically adds the url of the webfolder or phpfile?

Code: [Select]
<?php
 echo "<a href=\"/index.php?sid=".$name."&question=".$nextquest."\">next</a>";
?>

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 .

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

I've tried everything I could think of to resolve this issue and just can't solve it. I created a CMS, but I get this error when I add a user that has been previously deleted. For example, I create a user with username "Alicia", then I no longer need that username so I delete it. Then later I get another person named alicia, but when I try to add a user again with username Alicia, I get this error. This only happens when the username has been previously deleted. I don't have the username field set as unique in the database and it is also not set as a key. Any ideas?