PHP - How To Create A Local Copy Of A Live Wordpress-site: To Avoid Blank Page

I have a php tutorial that I followed for creating, inserting, selecting and updating a MySQL database with php.  Everything works fine so I wanted to put it into Wordpress.  I took the code and placed it into the wordpress page and everything worked just fine except the update function. 

Here is the tutorial I used. http://www.phpsimple.net/mysql_insert_record.html  It is also the part I am having trouble with.  I am able to create a record and I am also able to select a record but when I choose "update" the form doesn't load the data.  It will outside the website but not inside wordpress.  I am hoping this is not vague but because of my inexperience I am not sure what else to say.  I will be more than happy to provide any other information you need.

When will modern PHP copy an array by reference only instead of reassigning to memory?

For instance, when I execute $bigArray=$stmt->execute([$id]), PHP utilizes memory to store the data.  But then when I execute $dataHolders[] = new DataHolder($bigArray), I believe $bigArray is passed by reference and a new copy of $bigArray will not be stored in memory.  If in DataHolder::__construct, I executed $data[]='bla', then it is my understanding that PHP would see that the array is being modified and will automatically make a copy, but I am not doing so and just state this to confirm my understanding.

The part that I am uncertain about is not the first time data is retrieved but any additional times.  When I execute the next $bigArray=$stmt->execute([$id]), will PHP need to first store in memory the array that DataHolder::data references, then release the memory associated with $bigArray, and then store in memory the new $bigArray?

 

<?php

class DataHolder
{
    private $data;
    public function __construct(array $data)
    {
        $this->data=$data;
        //$this->data[]='bla';   <--  I believe this will force PHP to make a new copy of the array but I am not doing so
    }
}

$dataHolders=[];
foreach($ids as $id) {
    $bigArray=$stmt->execute([$id]);
    $dataHolders[] = new DataHolder($bigArray);
}

 

I am unsuccessfully able to do the following:   User creates an account   After login, checks server if user has their own folder created   If doesn't exist, create it   Copy files from source_code to this new folder   My code does create a folder, but no files appear inside it. Been trying to find an example with google search for the past 3 days with no luck.   I am running LAMP on Linux Mint OS to run my PHP webpages.   Can anyone tell me if issues with this section of coding?

<?php
 
function wait_time($seconds)

{

    $seconds = abs($seconds);

    if ($seconds < 1):

       usleep($seconds*1000000);

    else:

       sleep($seconds);

    endif;   

}
 
$file1 = "blank.html";

$file2 = "channel_video.php";

$file3 = "clear_playlist.php";

$file4 = "confirm.html";

$file5 = "index.html";
set_time_limit(0); //prevent script from timing out
 
$account = $_POST["account_name"];
$src = "source_code/";
$dst = $account."/";
 
echo 'Setting up your account page ->.';
mkdir($account, 0777, true); echo '.'; //create folder with full write permissions
wait_time(2000); //wait 2 seconds before copying files over
copy($src.$file1, $dst.$file1); echo '.';
wait_time(2000); //wait 2 seconds before copying files over
copy($src.$file2, $dst.$file2); echo '.';
wait_time(2000); //wait 2 seconds before copying files over
copy($src.$file3, $dst.$file3); echo '.';
wait_time(2000); //wait 2 seconds before copying files over
copy($src.$file4, $dst.$file4); echo '.';
wait_time(2000); //wait 2 seconds before copying files over
copy($src.$file5, $dst.$file5); echo '.<- setup finished<br>';
 
?>

Thanks for any input you can provide.

this is on amensharma.co.uk/testing

Code: [Select]
<?php

$db_link = mysql_connect("amensharma.co.uk","amenshar_admin","amen001");
if (!$db_link) {
    die('Could not connect: ' . mysql_error());
}

$db_selected = mysql_select_db('amenshar_calender', $db_link);
if (!$db_selected) {
    die ('Can\'t use database : ' . mysql_error());
}

?>
this is the error it returns

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'amenshar_admin'@'neptune.servers.rbl-mer.misp.co.uk' (using password: YES) in /home/amenshar/public_html/testing/functions/database.php on line 4
Could not connect: Access denied for user 'amenshar_admin'@'neptune.servers.rbl-mer.misp.co.uk' (using password: YES)

bit stumped here any help would be great

all the details are correct, just confused why im having these errors

I have a CURL code that fetches some XML content from a remote server. I get the expected output on my localhost (XAMPP on windows). But from the live site(hosted on Linux), I get the CURL error:'couldn't connect to host'.

function DownloadUrl($Url, $p){
 
// is curl installed?
if (!function_exists('curl_init')){ 
die('CURL is not installed!');
}

       // create curl resource
        $ch = curl_init();

        // set url
        curl_setopt($ch, CURLOPT_URL, $Url);

   curl_setopt ($ch, CURLOPT_POSTFIELDS, $p);
   curl_setopt ($ch, CURLOPT_POST, 1);
        //return the transfer as a string
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);

        // $output contains the output string
        $output = curl_exec($ch);
        
   if($output === false)
   echo 'Curl error: ' . curl_error($ch);
   else
     print $output;
        // close curl resource to free up system resources
        curl_close($ch);          
}

Having a major problem connecting to a live site. I have set up the user and database on Cpanel like normal. Then proceeded to insert those details into my mysql connection script

Code: [Select]
<?php

$db_link = mysql_connect("***","****","***");
if (!$db_link) {
    die('Could not connect: ' . mysql_error());
}

$db_selected = mysql_select_db('amenshar_calender', $db_link);
if (!$db_selected) {
    die ('Can\'t use database : ' . mysql_error());
}

?>
I am connecting to domain erban.co.uk, yet looking at the cpanel the master domain is amensharma.co.uk. Is this what the problem could be. This is the error messege it is throwing up

Warning: mysql_connect(): Access denied for user '_admin'@'localhost' (using password: YES) in d:\Domains\erban.co.uk\wwwroot\functions\database.php on line 4
Could not connect: Access denied for user '_admin'@'localhost' (using password: YES)

Hi Everyone   I am new in PHP and when i was trying to see live preview of my one of the PHP site then it was not showing properly. all the formats, color, images were not showing, i don't know whats the problem.

I have set up a site for a local orchestra. I have a simple mysql db from which 'News' items are pulled using php.

I have set up the following pages:
1. view_news.php
2. insert_news_item.php
3. delete_news_item.php
4. edit_news_item.php

All pages are working fine.

Now, rather than continually having to do news updates for the orchestra myself, I want to give a person on the orchestra committee access to the above pages so that he/she can do news updates for the orchestra, as required.

What is the best way of proceeding from here? I thought about creating a password protected directory and putting pages 2, 3 and 4 above into that directory and then giving the committee member the protected directory password. Is that the way to go?

What is the conventional way of doing this sort of thing?

Two things to note: I'm new to php and the job is non-paying. I've set up the site as the willing parent of kids in the orchestra.

Any advice will be much appreciated.

I've a code that can create category if not existed the category & add this to the post. If category already exist then it will select the category. 

Here is my code snippet example :  

$mcptitle = 'Lenevo xiaoxin pad pro 2021';


//Geting Brand Name
$brands = $mcptitle;
$arr = explode(' ',trim($mcptitle));
$brand= $arr[0]; 
//Notice Brand name Detected
//category Slug
$catlink=sanitize_title($brand);
//Finding category by name & geting id
if($term = get_term_by( 'name', $brand, 'category' ) ){
 $cat_id= $term->term_id;
 }else{
     //creating category for not exists category
   $terms= wp_insert_term($brand, // the term 
  'category', // the taxonomy
   array(
    'slug' => $catlink
  )); 
//geting new category id
   $cat_id= $terms['term_id'];  

   //post start

 $post = array(
      'post_author' => 1,
    'post_content' => $content,
      'post_status' => "publish",
      'post_title' => $title,
      'post_type' => "post",
    );

    $post_id = wp_insert_post( $post, $wp_error );
    //seting category
    wp_set_object_terms( $post_id, $cat_id, 'category' );

 

That works for create/add one category But I want to add multiple categories in it. Category array will be like this:  $mcptitle = array("Volvo", "BMW", "Toyota");

Plz Can anyone help me about my thoughts. Thanks in advance.  

The Script:

<h1>Do Add a Message to the MySQL Database</h1>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="POST">
    <textarea name="message"></textarea>
    <br/>
    <input type="submit" name="submit"/>
</form>

<?php
// The Connection to the Database
// Taken Out

?>

<?php
// To insert the text data into the MySQL database.
if(isset($_POST['submit'])){

$tqs = "INSERT INTO messages (`message`) VALUES ('{$_POST['message']}')";

$tqr = mysqli_query($dbc, $tqs) or die(mysqli_error($dbc));

}

?>

<?php
// To select the text data from the MySQL database.
$tqs = "SELECT * FROM messages";
$tqr = mysqli_query($dbc, $tqs);


// To print out the text data inside of table on the page.
echo "<h1>This Is Where the Messages Gets Printed on Screen</h1>";
echo "<table><tr><td>ID</td><td>The Message</td></tr>";

while($row = mysqli_fetch_assoc($tqr)){

    echo "<tr><td>" . $row['id'] . "</td><td>" . $row['message'] . "</td></tr>";

}

echo "</table>";

?>

1. When I have added text with the form to the MySQL database... 2. ... and I have clicked on "page reload" in Firefox to reload the page... 3. ... then the before submitted text gets submitted again to the MySQL database.   So basically, add text with the form to the MySQL database, reload the page in Firefox, and the before added text will get submitted to the MySQL database again.   My Question Is: What is the proper way to avoid this?
Edited by glassfish, 06 October 2014 - 10:18 AM.

I have a wordpress site that has a ribbon graphic on the index page posts that are in the category "features", it works great when it's like this:
Code: [Select]
<?php //for better seo, we use alt and titles in h
                query_posts('category_name=features&showposts=4');
                while(have_posts()):the_post();
                $attrs = array(
            'src'    => $src,
            'class'    => "",
            'alt'    => get_the_title(),
            'title'    => get_the_title(),
        );?>

            <!-- Blog entry -->
            <div class="blog_entry">

                <!-- inside -->
                <div class="inside">           


                <!-- Thumbnail -->
                <div class="thumbnail">
                   <a href="<?php the_permalink(); ?>" title="<?php the_title();?>"><?php the_post_thumbnail('blogsmall', $attr );?></a>
                </div>
                <!-- /Thumbnail -->

                <!-- Resume -->
                <div class="resume"><div class="featured_banner2"></div>
                    <h3 class="cufon"><a href="<?php the_permalink();?>"><?php the_title();?></a></h3>
                    <p class="bigline"><?php the_excerpt();?></p>
                    <br>
<?php if(function_exists('the_ratings')) { the_ratings(); } ?>
                </div>
                <!-- /Resume -->
but when going to the category view it doesn't work to just add the Code: [Select]
<div class="featured_banner2"></div> as all post types get the ribbon.

So I am trying to use a PHP if statement to only apply that featured_banner2 div line to posts with the category name of "features"

I am a total php newbie, so far I tried this but it obviously is not right, I am trying though! lol:

Code: [Select]
<!-- Resume -->
            <div class="resume">
            <?php 
              if ( in_category( 'features' )) {
                <div class="featured_banner2"></div>
                 } 
                      endif;?>

                <h3 class="cufon"><a href="<?php the_permalink();?>"><?php the_title();?></a></h3>
                    <p class="bigline"><?php echo  get_the_excerpt();?></p>
                </div>
        <!-- /Resume -->

I'm using paypal PDT, so when the user has made payment he gets directed back to my site, on that page it executes a special sql query. I noticed I can refresh the page to make duplicate sql queries. How can I avoid this??

The Wordpress Atahualpa theme does not appear to be compatible with php 7.2. I know very little about php. I get the following error message in my error log:
=====
[24-Jan-2019 22:14:03 UTC] PHP Warning: Declaration of Walker_Comment2::end_el(&$output, $comment, $depth, $args) should be compatible with Walker::end_el(&$output, $object, $depth = 0, $args = Array) in /home/armst5/public_html/MyBlog/wp-content/themes/atahualpa.3.2/atahualpa/functions/bfa_comment_walker.php on line 145
=======
What does this mean and can I fix it?

Hello everyone,
I am not sure if I am supposed to post this here but I have a problem with a php file of my wordpress site.
Let me insert the code becaus I have no idea what is the problem -     $file_data = fread( $fp, 8 * 'KB_IN_BYTES' );  where the problem shows

function get_file_data( $file, $default_headers, $context = '' ) {
    // We don't need to write to the file, so just open for reading.
    // Pull only the first 8 KB of the file in.
    $file_data = fread( $fp, 8 * 'KB_IN_BYTES' ); 
    // PHP will close file handle, but we are good citizens.
    // Make sure we catch CR-only line endings.
    $file_data = str_replace( "\r", "\n", $file_data );

    /**
     * Filters extra file headers by context.
     *
     * The dynamic portion of the hook name, `$context`, refers to
     * the context where extra headers might be loaded.
     *
     * @since 2.9.0
     *
     * @param array $extra_context_headers Empty array by default.
     */

This topic has been moved to PHP Applications.

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