PHP - Accessing A Wordpress Database

Have a client who has a Wordpress site that is running slowly and wants performance improved.  It is averaging on the order of 7 seconds or so to render basic pages.  No video, few images, etc.  The database has about 1 million records.  my primary question is, "When does Wordpress hit a point that the db is too large and will slow down a site?"  i understand there is no definitive answer, just trying to get a ballpark.  its noteworthy that about 700,000 of those records are in a table for the REDIRECTION plugin.  ive deactivated that plugin to eliminate those records as a factor.     as an fyi to anyone with any other ideas on how to speed the site up - ive deactivated all plugins with no effect - activated Twentyfourteen theme with no improvement ( to eliminate theme issues ) - uploaded a php page outside of Wordpress and it rendered immediately.  

I've played around with CakePHP, then XCrud (a decent CRUD application) but I gave up on both of them, XCrud was great for everything up until it came to managing complicated relational database tables. Anyhow, I'm using wordpress a lot now cuz it lets me stop reinventing the wheel so much and although I was able to integrate XCrud into WordPress as a plugin, I think the best way to go is just transfer my database tables to WordPress tables and display them as custom post types. My time is really limited right now though, is there a plugin/set of plugins I can use to automate the process? To show you what I mean, heres the XCrud list display of one of the tables:   thats great because it automatically sets up the CRUD thing and lets you add and edit fields to the table, and doesn't heavily box you into their system but I have a table of plants, one for products, one for pharmacology, one for categories which are all related to each other, and some of them are structured in a tree/nested hierarchy structure so long story short, I need to do advanced searches based on these relations and handle these tree structured tables and CakePHP didn't work out, and XCrud has crappy documentation and isn't popular enough to find good info.   So how would you go about transfering this system to WordPress? I'm guessing I need to make custom post types for each table but what I don't yet know is how to transfer the DB tables to WordPress format, how to handle the relationships between each table and how to handle the hierarchical tree structures.

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.

HEy Guys
Here is a snippet of an array:

SimpleXMLElement Object
(
    [report1] => SimpleXMLElement Object
        (
            [ReportHost] => Array
                (
                    => SimpleXMLElement Object
                        (
                            [HostName] => 192.168.2.34
                            [startTime] => Thu Dec 17 13:58:49 2009
                            [stopTime] => Thu Dec 17 15:13:13 2009
                            [netbios_name] => (unknown)
                            [mac_addr] => (unknown)
                            [dns_name] => (unknown)
                            [os_name] => (unknown)
                            [num_ports] => 2
                            [num_lo] => 0
                            [num_med] => 0
                            [num_hi] => 0
                            [ReportItem] => Array
which is printed using print_r($a)
now how can i access [HostName] => 192.168.2.34 in the $a array??
Thanks in advance

Hi guys,

I have xml that looks like:

<item>
<title></title>
<link></link>
<description></description>
<dc:date>2011-02-27T16:42:31-05:00</dc:date>
</item>


I can access title, link, and description just fine.  But how do I access a tag that has a colon?

I tried this:

Code: [Select]
$x = new SimpleXmlElement($content);
$entry = $x->item;

$entry->children('dc', true)->date;

Thanks for looking.

LR

I am a part of an institue which has internal web pages. It also provides me with my web space with php servers. Now I know those internal web pages are available to the server. I want a code that can fetch those web pages and display it  in my web space. And whatever forms i fill or links i click it should do those on internal page and again return the new web page.

If $result contains the result of mysql_query, a select count distinct query, how do I access the count?  I've tried $result[0] to no avail and $result only returns the resource #.

I use a CURL script API with the header "$headers[] = 'Content-Type: application/json';"

The script ends with "$result = curl_exec($ch);"

If I simply echo the $result to  my browser, I get an array that looks like this:

stdClass Object
(
    [fromAddress] => stdClass Object
        (
            [name] => Fred Sender
            [phone] => 203-111-0000
        )

    [toAddress] => stdClass Object
        (
            [name] => Susan Recipient
            [phone] => 919-555-1212
            
What is the absolute minimum I need to do to access the phone number in the "toAddress" (919-555-1212).

Do I really need to "json_decode" this array?

I've spent 2 1/2 days trying every which way, with every permutation to access that one value:

echo $result["fromAddress"]["phone"];
echo $result->fromAddress->phone;
echo $result[0]->fromAddress->phone
echo $arr[0]->fromAddress->phone; // $arr = json_decode($result);
echo $arr->fromAddress->phone;
echo $arr[0]->fromAddress->phone;
echo $arr[0]->fromAddress["phone"];

Unfortunately I must have fallen asleep during the array lesson in PHP class  ?

Thank you.

    I have the following code in zend:

  Code: [Select]
$arrErrors=array();
     if (!empty($this->post['submit']))
    {
    // Each time theres an error, add an error message to the error array
           // using the field name as the key.
          if (empty($this->post['client_name']))
      $arrErrors['client_name'] = "Please Enter Client's name as it appears in the carrier software";
    }
if i set $this->view->arrErrors=$arrErrors in the controller,
Can I access it as $this->arrErrors['client_name'] in the view?

Hi all,

I've tried to access the admin.php of the xcart installation he http://www.cleaningshopuk.com but it doesn't allow me to access it, saying that it's a 404 page not found error.

That page does in fact exist, but I think the issue might be something to do with a redirection. The site owner apparently clicked on something in the admin section (possibly https or something similar) but what can I do to avoid this issue without having to re install everything?

Thanks,

Neil

Is it possible to have a class access another class it its parent directory without using a fully qualified name?  While the following script is not valid, it is how I would have thought it would be done should it be possible.  If it is not possible, I expect there is a good reason why one would not want to do so, and would appreciate your thoughts why that is so.  Thanks

// src/PrimaryTopic/SubTopic/SubSubTopic/ParentClass.php
namespace PrimaryTopic\SubTopic\SubSubTopic;
class ParentClass {}

// src/PrimaryTopic/SubTopic/SubSubTopic/Child/ChildClass1.php
namespace PrimaryTopic\SubTopic\SubSubTopic\Child;
class ChildClass1 extends ..\ParentClass {}

// src/PrimaryTopic/SubTopic/SubSubTopic/Child/ChildClass2.php
namespace PrimaryTopic\SubTopic\SubSubTopic\Child;
class ChildClass2 extends ..\ParentClass {}

 

Hi all,

I am still trying to figure what went wrong. It doesn't work over here.

The error shown was the {else} command
else {
      echo '<p class="error">There was a problem accessing your profile.</p>';
   }

I have attached my 4 sql tables for reference. Appreciate any advices....

Code: [Select]
<?php
$query3 = "SELECT ols.subject_level_id, sl.level_id, sl.subject_id, tl.level_name AS level_name, ts.subject_name AS subject_name " .
        "FROM tutor_overall_level_subject AS ols " .
"INNER JOIN tutor_subject_level AS sl USING (subject_level_id) " .
        "INNER JOIN tutor_level AS tl USING (level_id) " .
        "INNER JOIN tutor_subject AS ts USING (subject_id) " .
"WHERE ols.tutor_id = '" . $_GET['tutor_id'] . "'";


  $data3 = mysqli_query($dbc, $query3)
  or die(mysqli_error($dbc));

  if (mysqli_num_rows($data3) == 1) {

echo '<div id="panel4">';

echo'<table><tr>'; // Start your table outside the loop... and your first row
$count = 0; // Start your counter
while($row3 = mysqli_fetch_array($data3)) {
/*  Check to see whether or not this is a *new* row
If it is, then end the previous and start the next and restart the counter.
*/
if ($count % 5 == 0) { 
echo "</tr><tr>"; $count = 0;
}
echo '<td class="label">' . $row3['level_name'] . '</td><td>' . $row3['subject_name'] . '</td>';
$count++; //Increment the count
} 
echo '</tr></table><br/>'; //Close your last row and your table, outside the loop

echo '</div>'; //End of panel 4

} //End of if (mysqli_num_rows($data3) == 1)

else {
echo '<p class="error">There was a problem accessing your profile.</p>';
}
?>

So basically I'm using PHP to solve a math problem for me. The user puts in a few parameters and the program runs those numbers through the algorithm and spits out a bunch of xy coordinates. I'm using the PHP SELF method to retrieve the user input. This all works fine, but it's afterwords that I run into problems. I create a drop down menu of all the x values and I want the user to be able to choose any x value they wish and to have the corresponding y value be displayed. The problem is that I have to use another POST command for this and when I do, it wipes out all the computed data.  Of course the y-value is never displayed, and there lies the problem.

I'm sure there are many ways to get around this, but I could not find one out myself. Anyone have any ideas?

How do I access an object on different pages?

I created object "A" on pageone.php and I need to access it on pagetwo.php.

How do I do that?


TomTees

Hello All:

I am trying to access a value within an object. The value name has whitespace in it and is called "zip code".

When I try to access the value via regular object call such as:

Code: [Select]
$sub = $sub->zip code;
PHP goes crazy on me.

I've tried to encapsulate the value name within a variable like this:

Code: [Select]
$zip_code = "Zip Code";

$sub = $sub->zip_code;

and that doesn't work either.

Does anyone have any ideas about how I should go about yanking the data out?