globberstack.com / topdog / Upcoming Questions

Upgrading the existing database in a PHP system

topdog — Sun, 05 Feb 2012 09:42:40 -0500

I'm working on a software solution which was written using PHP Symfony with mysql database. When we do upgrades to the existing product what we use now is copping the existing database to a new database and do the upgrade standing on the new database. But the current method of asking the user to copy the existing database is not seems the professional way to do an upgrade.

Is there any standard way of doing that automatically and preserve the consistency of the old database. Please help me on this issue. Thanks in advance.

Originally asked by: Thilanka on Stack Overflow

0 Vote(s)

MySQL database keeps crashing on replication slave issues, without actually being a slave

topdog — Sun, 05 Feb 2012 09:42:30 -0500

I have a mysql process on machine A which may at one time ran one of the databases as slave to a specific master database (B).

I set up a different slave on another machine (C), so on the problem machine A I ran RESET SLAVE and STOP SLAVE on.

Running SHOW SLAVE STATUS gets me Empty set for all databases on A.

The problem is that mysql on A keeps crashing:

120204 20:20:39  mysqld restarted
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120204 20:20:40  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: In a MySQL replication slave the last master binlog file
InnoDB: position 0 608674962, file name mysql-bin.000004
120204 20:20:45  InnoDB: Started; log sequence number 7 3284755002
120204 20:20:51 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

Number of processes running now: 0
120204 20:21:00  mysqld restarted
InnoDB: Log scan progressed past the checkpoint lsn 7 3284755002
120204 20:21:01  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 7 3284755012
InnoDB: In a MySQL replication slave the last master binlog file
InnoDB: position 0 608674962, file name mysql-bin.000004
120204 20:21:05  InnoDB: Started; log sequence number 7 3284755012
120204 20:21:07 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

Number of processes running now: 0
120204 20:25:43  mysqld restarted
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120204 20:25:43  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: In a MySQL replication slave the last master binlog file
InnoDB: position 0 608674962, file name mysql-bin.000004
120204 20:25:46  InnoDB: Started; log sequence number 7 3284756054
120204 20:25:47 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

Number of processes running now: 0
120204 20:29:21  mysqld restarted
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120204 20:29:22  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: In a MySQL replication slave the last master binlog file

How can I fix this?

Originally asked by: Ian.mc on Stack Overflow

1 Vote(s)

Is there any php-ga ports to Ruby on Rails

topdog — Sun, 05 Feb 2012 09:39:23 -0500

I'm looking for RoR solution to register direct redirects from my site, php-ga looks good but it is PHP.

I mean I have some controller#redirect action which makes smth like this

def redirect
  link = Links.find_by_key params[:key]

  redirect_to link.url
end

That makes flawless redirects from http://myurl.com/XXX to target location for any external references.

I definitely do not want to use real redirect page with JS code. And PHP-GA ( http://code.google.com/p/php-ga/ ) looks like the only prod-level and documented solution to register visits in Google Analytics directly from controller, but it's on PHP.

So, I return to my original question: Is there any php-ga ports to Ruby on Rails?

Originally asked by: Wile E. on Stack Overflow

0 Vote(s)

SQLStateConverter.handledNonSpecificException hibernate

topdog — Sun, 05 Feb 2012 09:38:47 -0500

I have the following entity in Hibernate:

@Entity
public class Contact implements Serializable {
    private static final long serialVersionUID = 1L;
      @Temporal(TemporalType.DATE)
    private Date birthday;
}

When I call this method of hibernate:

public Object get(Class entityClass, Serializable id) throws HibernateException {
    return get( entityClass.getName(), id );
}

I get the following exception:

org.hibernate.exception.GenericJDBCException: could not load an entity: [com.mycompany.model.Contact#3]
    at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
}

I tried this simple code:

Statement st = conn.createStatement();
ResultSet res = st.executeQuery("select registration_date from contact where contact_id=3");
Date i = res.getDate(1);

And this works fine.

What is the problem?

The type of Date is java.util.Date in both cases.

EDITED

I debugged it more, and saw that the exception is:

Bad format for DATE '517' in column 2.

The date there is: 1985-05-17

Originally asked by: Odelya on Stack Overflow

1 Vote(s)

php get string from remote page

topdog — Sun, 05 Feb 2012 09:36:13 -0500

I'm creating a mobile payment processing script for my site, and to validate the payment I have to grab a string from the providers site.

The string will be either "Valid" or "Invalid"

How can I pull this string from my own site?

Originally asked by: user1022585 on Stack Overflow

0 Vote(s)

What datatype should I use to store time() in MySQL for my application?

topdog — Sun, 05 Feb 2012 09:32:07 -0500

I plan to capture the start and end of user initiated activities on my website using time() in php. I'm not sure if this is the best way to capture start/end times. Anyway, the data will be stored in MySQL, but again I'm not sure what datatype I should use.
Based on the answers I've read on stackoverflow, the datatype used depends on the purpose of the application.

Purpose of the application

At it's simplest, I want to record start, stop (and duration) of an
activity. Probably using time().

At it's most complicated I'd like to plot statistics based on when
the user did a certain activity, how much time they spent doing the
activity (in total), and when they were the most successful/least
successful etc, etc. (all based on the start/end times) Something to
keep in mind. The users will be from all over the world.

MORE INFO
If an activity is repeated a new record will be made for it. Records will not be updated.

At first, I had planned on storing unix timestamps in MySQL (as an integer datatype?), but from what I understand this is a bad idea, because I will lose a lot of MySQLs ability to process the information. If I store the information as DATETIME, but then move the server, all the times will change based on the local time of the server. Something I found confusing was that TIMESTAMP in MySQL is not the same as a unix timestamp- which is what I would be getting if I used time().

I'm aware that the unix timestamp can only hold dates up to 2038 for some systems, but that isn't a concern (at the moment).

Question: Should I use time() to capture start and end times for user initiated activities? Based on the purpose of the application, what datatype should I use to store the start and stop of user initiated activities?

Originally asked by: moomoochoo on Stack Overflow

0 Vote(s)

PHP - Yii - I can access model's data in a view file, but have the getUrl in its controller. How do i access this?

topdog — Sun, 05 Feb 2012 09:31:10 -0500

PHP - Yii - I can access model's data in a view file, but have the getUrl in its controller. How do i access this?

basically, in yii, i have a model and controller set up. in the controller for a certain models (videos) i have a function called getUrl.

on the homepage i've edited the view to include the latest posts. i do this in views/site/index.php with:

    widget('LatestVideos'); ?>

and the LatestVideos widget has this code:


Yii::import('zii.widgets.CPortlet');

class LatestVideos extends CPortlet {
public $title='Tags';
public $maxVideos = 20;
protected function renderContent() {
    $criteria = new CDbCriteria;
    $criteria->limit=$maxVideos;        
    $vids = Video::model()->findAll();
    foreach($vids as $video) {
        $link = Yii::app()->createUrl('video/view', array(
            'id'=>$video->id,
            'title'=>$video->video_title,
        ));
        echo '' . $video->video_title . '';
    }

as you can see, in that widget i get the info about latest videos by going straight from the widget to the model. i skip the controller. i need to access the controller to propperly access the getUrl function. how do i do this?

Originally asked by: notsid on Stack Overflow

0 Vote(s)

How to open links in an iframe with target=“_blank” in the same iframe?

topdog — Sun, 05 Feb 2012 09:29:25 -0500

I want to Open links with target="_blank" and an iframe in the same iframe.
I tried the code below, but it didn't work:

Originally asked by: user915666 on Stack Overflow

1 Vote(s)

php extract info from a html page

topdog — Sun, 05 Feb 2012 09:26:04 -0500

I have this code


    
        
            AA-T5301
        
        
        
                            HREF="product.asp?ms=&dept_id=322&sku=32&nav=">
                Grapeseed Oil 150ml
            
        
        Order Now
        
            
                £3.04
                 
            
            £2.04
        
        
            
        
    
    
        
            
                AA-T5302
            
            
            
                                    HREF="product.asp?ms=&dept_id=322&sku=143&nav=">
                    Grapeseed Oil 500ml
                
            
            Order Now
            
                
                    £6.46
                     
                
                £4.33
            
            
                
            
        
        
            
                
                    AA-T530
                
                
                
                                            HREF="product.asp?ms=&dept_id=322&sku=19&nav=">
                        Grapeseed Oil 50ml
                    
                
                Out of Stock
                
                    
                        £1.75
                         
                    
                    £1.17

How can i extract the info into an array so i have something like this..

product_code_array=(AA-T5301,AA-T5302,AA-T530);

RRP_array=(3.04,6.46,1.75);

price_array=(2.04,4.33,1.17);

Note: There maybe more than 3 items on a page at a time or there may only be 1

Originally asked by: Stu on Stack Overflow

1 Vote(s)

split string into array and trim middle?

topdog — Sun, 05 Feb 2012 09:26:00 -0500

I have a string that is something like this:

$str="



  lol
      test



test";

I want to trim the text that is within the tags so that I end up with this:

$str="

lol
      test

test";

Is there a way that I can split this out in to a 3 array pieces and so a simple trim() on the text in the middle?

many thanks

Originally asked by: Tim on Stack Overflow

1 Vote(s)

Validate form before submitted (Check all fields are entered)

topdog — Sun, 05 Feb 2012 09:25:47 -0500

I'm trying to check that the fields in the form below have been filled before it can be inserted into a database e.g. display a pop up with the fields that have not been filled in. It is just a simple Registration form.


Sign up
Username:
Password:
Name:

How do I do this using JavaScript or jQuery.

Originally asked by: Droid_Interceptor on Stack Overflow

1 Vote(s)

Illegal Start of Expression Error

topdog — Sun, 05 Feb 2012 09:22:57 -0500

Hey I'm new here so sorry if I'm posting this in the wrong section or something like that.

But does anybody know what's wrong with this code, just can't seem to figure it out:

/**This class mimics a random guy character which could be used...

0 Vote(s)

Libevent timeout loop exit

topdog — Sun, 05 Feb 2012 09:21:40 -0500

I'm having some difficulties getting the PHP libevent extension to break out of a loop on a timeout. Here's what I've got so far based on the demos on the PHP.net docs pages:

// From here: http://www.php.net/manual/en/libevent.examples.php

function print_line($fd, $events, $arg) {
    static $max_requests = 0;
    $max_requests++;

    printf("Received event: %s after %s\n%s", implode(getEventFlags($events)), getTimer(), fgets($fd));

    if ($max_requests == 10) {
        // exit loop after 3 writes
        echo " [EXIT]\n";
        event_base_loopexit($arg[1]);
    }
}

// create base and event
$base = event_base_new();
$event = event_new();


getTimer(); // Initialise time

$fd = STDIN;
event_set($event, $fd, EV_READ | EV_PERSIST, "print_line", array($event, $base));
event_base_set($event, $base);
event_add($event, 2000000);
event_base_loop($base);

// extract flags from bitmask
function getEventFlags ($ebm) {
    $expFlags = array('EV_TIMEOUT', 'EV_SIGNAL', 'EV_READ', 'EV_WRITE', 'EV_PERSIST');
    $ret = array();
    foreach ($expFlags as $exf) {
        if ($ebm & constant($exf)) {
            $ret[] = $exf;
        }
    }
    return $ret;
}

// Used to track time!
function getTimer () {
    static $ts;
    if (is_null($ts)) {
        $ts = microtime(true);
        return "Timer initialised";
    }
    $newts = microtime(true);
    $r = sprintf("Delta: %.3f", $newts - $ts);
    $ts = $newts;
    return $r;
}

I can see that the timeout value passed to event_add effects the events passed to print_line(), if these events are any more than 2 seconds apart I get an EV_TIMEOUT instead of an EV_READ. What I want however is for libevent to call print_line as soon as the timeout is reached rather than waiting for the next event in order to give me the timeout.

I've tried using event_base_loopexit($base, 2000000), this causes the event loop to exit immediately without blocking for events. I've also tried passing EV_TIMEOUT to event_set, this seems to have no effect at all.

Has anyone managed to get this working before? I know that the event_buffer_* stuff works with timeouts, however I want to use the standard event_base functions. One of the PECL bugs talks about event_timer_* functions and these functions do exist on my system, however they're not documented at all.

Originally asked by: Robin on Stack Overflow

1 Vote(s)

Mysql stored procedure array parameter from java

topdog — Sun, 05 Feb 2012 09:19:03 -0500

I need to create mysql stored procedure which makes more than one insert at a time. To prevent many calls to database I need to use stored procedure. I have java.util.List object of my data. MyEntity is an object which holds data which has to be inserted into table.

My question is how should I pass List object as mysql procedure parameter?

Thanks in advance.

Originally asked by: Paulius Matulionis on Stack Overflow

0 Vote(s)

mysql loader error? 'C:test.txt' not found (Errcode: 2)

topdog — Sun, 05 Feb 2012 09:17:09 -0500

I tried the following code to load data from text document to mysql database, but it shows an error: ( file name is test.txt)

File 'C:test.txt' not found (Errcode: 2)
please help me......

LOAD DATA LOCAL INFILE 'C:test.txt' INTO TABLE messagebox fields terminated by ',' LINES TERMINATED BY '\n';

Originally asked by: user1148952 on Stack Overflow

0 Vote(s)

Get all values from a multidimensional array into a single array [closed]

topdog — Sun, 05 Feb 2012 09:16:44 -0500

Possible Duplicate:

How to Flatten a Multidimensional Array?

THe array:

itemA => value
  itemA1 => value
  itemA2 => value
    itemA11 => value
itemB => value

and so on...

How can I get the values gathered like this:

[0] => value (from itemA)
[1] => value (from itemA1)
[2] => value (from itemA2)
[3] => value (from itemA11)
[4] => value (from itemB)
...

Originally asked by: user1190692 on Stack Overflow

0 Vote(s)

How to insert over a million records into a MySQL database?

topdog — Sun, 05 Feb 2012 09:16:16 -0500

I have a sql file which contains over a million insert statements. The official tool for MySQL administration is not able to open it because of its size. Is it possible to insert records using a BASH script?

I tried this so far but it doesn't work.

while read line
do
    mysql -u root --password=root << eof
    use dip;
    $line;
    eof
done < $1

Originally asked by: Tomas on Stack Overflow

0 Vote(s)

How to retrieve 1 record at a time from db

topdog — Sun, 05 Feb 2012 09:15:58 -0500

I have a table comment as follow:

Comment

comment_id         cmt               followupid
1                 Hello              3 
2                 hi                 4
3                 Hey                2
4                 wassup             1

My query is that I want to echo "Hello", "hi", "hey" , "Wassup" and other (the record continues) individualy, I have used

$comment = mysql_result($runQuery, $i,"cmt");
echo $comment;

which works fine but the problem is that it echoes all the comments at once, what I want is to echo all the comment but one at a time. the comment are in a div tag such that each the div appears only after 1 second the page is loaded. I want each comment to appear after different time interval

for e.g:

Hello  to appear at        5pm    (not necessarily the corect time it can be just an int)
hi                         5.10 pm 
hey                        6.30 pm

Please Help!

Originally asked by: FacebookUse on Stack Overflow

1 Vote(s)

UDP Attack on Gaming Server

topdog — Sun, 05 Feb 2012 09:14:02 -0500

Recently the business class server I use for a MMO Game has become under the attack of someone who has a semi-decent amount of knowledge of what they are doing.

For the past couple of weeks they have initiated a UDP flood attack using a command...

1 Vote(s)

Symfony - image in response - speed, optimization

topdog — Sun, 05 Feb 2012 09:13:40 -0500

I generate dynamically graphic in my controller:

if not file exists (unique filename) then generate graphic and save it

return RedirectResponse($url)

(3. I've tried also:

    $fp = fopen($url, "rb");
    $str = stream_get_contents($fp);
    fclose($fp);

    $response = new Response($str, 200);
    $response->headers->set('Content-Type', 'image/png');
    return $response;

)

I need it to generate dynamically userbars for users [on this graphic some text will be automatically updating if some changes will be done on my websites].

So it's important for me that this script works fast and doesn't kill my server/bandwitch. To achieve that I've made cache where all generated graphics are stored. But i've got a problem with speed, solutions which i've described above are pretty slow, when i've tested it in chrome with developer tool (F12) then it shows me that both solution (2. and 3.) takes about ~1s (when the same graphics [without controllers etc. just direct url to .png] loads 44ms).

So if only for me it takes about ~1s per graphic then if for example 1000 users will generate at the same time this graphic it can slower my website I think.

Please help, do you know any faster ways to do that?

PS. Redirect isn't most desire thing for me, because I would prefer to leave url as it is, for example smth/username/userbar/ insted of smth/img/userbars/cache/blabla.png. But if it will be much faster then I can stand it :).

EDIT: To be clear: I'm not looking for solution to cache images, my problem is that returning images via controller (already generated images, just from ftp) takes about 1s, when normally if you do for example

it takes about 44ms.

Originally asked by: Wojciech Kulik on Stack Overflow

1 Vote(s)

[SOLVED] Less width

topdog — Sun, 05 Feb 2012 09:13:07 -0500

Hi

is there a way whereby I can make the width of the following template narrower ? I mean for me at least it is too wide. Will appreciate your help :wink:

Fashion Magazine | Fashion - Free Website Template- TemplatesCreme.com (http://www.templatescreme.com/free-website-fashion-magazine)
...

0 Vote(s)

limit the number of threads viewed on a page

topdog — Sun, 05 Feb 2012 09:12:25 -0500

In forums, there is an option to choose to display the number of viewable threads on a single page, there is also links to view next pages that contain the same number of thread counts.I would like to learn how that is done in mysql and php. Date and pay me!I WILL DO.

Originally asked by: Mackintoast on Stack Overflow

0 Vote(s)

how to use sphider search engine in php mysql

topdog — Sun, 05 Feb 2012 09:10:24 -0500

Now am developing a small website. I tried to use sphider search engine to get data from my database. I'm using Xampp server, i Just extract that sphider files to htdocs document in xampp server. I have update that database name in sphider database.php files and so on. But when i try to search it shows the search did not match any document can any one give suggestion to solve this problem.

Originally asked by: Dhinesh.B on Stack Overflow

0 Vote(s)

How do I get comment count in Disqus?

topdog — Sun, 05 Feb 2012 09:10:00 -0500

I'd like to store the Disqus comment count on my own database, so that I can sort my articles by comment count. Basically, every time a page is read on my site, I'd like to ask Disqus how many comments that certain page has, then update the database with that count.

http://docs.disqus.com/help/3/ doesn't seem to be helpful.

Any suggestions?

Originally asked by: Obay on Stack Overflow

0 Vote(s)

how do I include a class in another file?

topdog — Sun, 05 Feb 2012 09:09:38 -0500

I am new to object php, I have the following concern:
is it possible to have one class included inside another class, and use it's method like:

in Anotherclass.php file

  class Another
 {
    public $value = '';
    public function setValue($newvalue)
    {
      $this->value=$newvalue;
    }
    public function getValue()
    {
      return $this->value;
    }

 }

in Bootstrap.php file:

  require(Another.inc)
  class Bootstrap
 {
    public static function main($value)
{
    $obj =  new Another();
        $obj->  setValue($value)
       echo  $obj->getValue();  

     }
 }


  Bootstrap::main("test");

so when I call Bootstrap::main("test") in the Bootstrap.php file, can I get the output which is "test"? Any help will be greatly appreciated!

Originally asked by: smith on Stack Overflow

1 Vote(s)

Mysql - Alter table statement to create unique index on long text field

topdog — Sun, 05 Feb 2012 09:04:11 -0500

I'm trying to create an Alter command to create an unique_index on the first 8000 characters. I'm not able to figure out how to add the 8000 part. Any help would be appreciated. Thanks!

ALTER TABLE nextractor.tblhtml
  ADD UNIQUE INDEX uniqueindex_InnerHTML (InnerHtml);

Originally asked by: Mike on Stack Overflow

0 Vote(s)

geocode - get the location

topdog — Sun, 05 Feb 2012 09:03:20 -0500

If I have a table with

id, location, latitude, longitude

and I would have a location code: (13.779242,100.472915) for example.

! have 2 questions: what field type should I use for the lat and lon? Double? or maybe the spacial things? but isn't that more for calculating the distance?

Anyway, I want to find the location (or the one most accurate)
Am I thinking to easily if I would just do these 2 queries:

Select * from location_table WHERE latitude > 13.779242 AND longitude > 100.472915." LIMIT 1"; // return as row 1
Select * from location_table WHERE latitude < 13.779242 AND longitude < 100.472915." LIMIT 1"; // return as row2

Then do a compare

$lat_dis_1 = $row1->latitude - 13.779242;
$lat_dis_2 = 13.779242 - $row2->latitude;

if ($lat_dis_1 > $lat_dis_2) {
// row2 was closer
} else {
//row1 closer
}

and same for longitude... Or am i just thinking too simpel here?

Originally asked by: renevdkooi on Stack Overflow

1 Vote(s)

Internal / External Email Notifications

topdog — Sun, 05 Feb 2012 09:02:56 -0500

I have a website which is hosted by GoDaddy.com. For 6 months my Internal / External Email Notifications (New User Signup, Contact From Member, Auction End, Auction Begin, OutBid, Etc...) have been sent with no problem whatsoever until two weeks ago. I contacted GoDaddy and they stated that it was...

0 Vote(s)

How to add uncovered files to PHPUnit code coverage report of the Yii application

topdog — Sun, 05 Feb 2012 09:02:38 -0500

I am currently trying to get the code coverage report for a PHP application based on Yii framework.

Code coverage gets generated by PHPUnit 3.6, and I am using whitelist approach to source files filtering.

Problem is, when I set the option addUncoveredFilesFromWhitelist="true", code coverage breaks with the following error:

Generating code coverage report, this may take a moment.PHP Warning:  include(CButtonColumn.php): failed to open stream: No such file or directory in /home/hijarian/systems/yii/framework/YiiBase.php on line 418
PHP Stack trace:
PHP   1. {main}() /usr/bin/phpunit:0
PHP   2. PHPUnit_TextUI_Command::main() /usr/bin/phpunit:46
PHP   3. PHPUnit_TextUI_Command->run() /usr/share/php/PHPUnit/TextUI/Command.php:125
PHP   4. PHPUnit_TextUI_TestRunner->doRun() /usr/share/php/PHPUnit/TextUI/Command.php:187
PHP   5. PHP_CodeCoverage_Report_HTML->process() /usr/share/php/PHPUnit/TextUI/TestRunner.php:373
PHP   6. PHP_CodeCoverage->getReport() /usr/share/php/PHP/CodeCoverage/Report/HTML.php:133
PHP   7. PHP_CodeCoverage_Report_Factory->create() /usr/share/php/PHP/CodeCoverage.php:141
PHP   8. PHP_CodeCoverage->getData() /usr/share/php/PHP/CodeCoverage/Report/Factory.php:65
PHP   9. PHP_CodeCoverage->processUncoveredFilesFromWhitelist() /usr/share/php/PHP/CodeCoverage.php:173
PHP  10. include_once() /usr/share/php/PHP/CodeCoverage.php:516
PHP  11. YiiBase::autoload() /home/hijarian/systems/yii/framework/YiiBase.php:0

PHP Warning:  include(): Failed opening 'CButtonColumn.php' for inclusion (include_path='.:/home/hijarian/projects/lexgarant/webapp/protected/components:/home/hijarian/projects/lexgarant/webapp/protected/models:/usr/share/php:/usr/share/pear') in /home/hijarian/systems/yii/framework/YiiBase.php on line 418
PHP Stack trace:
PHP   1. {main}() /usr/bin/phpunit:0
PHP   2. PHPUnit_TextUI_Command::main() /usr/bin/phpunit:46
PHP   3. PHPUnit_TextUI_Command->run() /usr/share/php/PHPUnit/TextUI/Command.php:125
PHP   4. PHPUnit_TextUI_TestRunner->doRun() /usr/share/php/PHPUnit/TextUI/Command.php:187
PHP   5. PHP_CodeCoverage_Report_HTML->process() /usr/share/php/PHPUnit/TextUI/TestRunner.php:373
PHP   6. PHP_CodeCoverage->getReport() /usr/share/php/PHP/CodeCoverage/Report/HTML.php:133
PHP   7. PHP_CodeCoverage_Report_Factory->create() /usr/share/php/PHP/CodeCoverage.php:141
PHP   8. PHP_CodeCoverage->getData() /usr/share/php/PHP/CodeCoverage/Report/Factory.php:65
PHP   9. PHP_CodeCoverage->processUncoveredFilesFromWhitelist() /usr/share/php/PHP/CodeCoverage.php:173
PHP  10. include_once() /usr/share/php/PHP/CodeCoverage.php:516
PHP  11. YiiBase::autoload() /home/hijarian/systems/yii/framework/YiiBase.php:0

PHP Fatal error:  Class 'CButtonColumn' not found in /home/hijarian/projects/lexgarant/webapp/protected/components/CLexgarantButtonColumn.php on line 4
PHP Stack trace:
PHP   1. {main}() /usr/bin/phpunit:0
PHP   2. PHPUnit_TextUI_Command::main() /usr/bin/phpunit:46
PHP   3. PHPUnit_TextUI_Command->run() /usr/share/php/PHPUnit/TextUI/Command.php:125
PHP   4. PHPUnit_TextUI_TestRunner->doRun() /usr/share/php/PHPUnit/TextUI/Command.php:187
PHP   5. PHP_CodeCoverage_Report_HTML->process() /usr/share/php/PHPUnit/TextUI/TestRunner.php:373
PHP   6. PHP_CodeCoverage->getReport() /usr/share/php/PHP/CodeCoverage/Report/HTML.php:133
PHP   7. PHP_CodeCoverage_Report_Factory->create() /usr/share/php/PHP/CodeCoverage.php:141
PHP   8. PHP_CodeCoverage->getData() /usr/share/php/PHP/CodeCoverage/Report/Factory.php:65
PHP   9. PHP_CodeCoverage->processUncoveredFilesFromWhitelist()     /usr/share/php/PHP/CodeCoverage.php:173
PHP  10. include_once() /usr/share/php/PHP/CodeCoverage.php:516

(It's interesting by itself, why there is three almost identical errors instead of just one.) When addUncoveredFilesFromWhitelist="false" code coverage generates successfully, but, of course, without the files not covered by tests.

Files of the Yii framework placed in the $HOME/systems/yii/ directory.

Application I'm trying to cover placed in the $HOME/projects/$APPNAME/.

Here's my phpunit.xml:

    colors="true"
    convertErrorsToExceptions="true"
    convertNoticesToExceptions="true"
    convertWarningsToExceptions="true"
    stopOnFailure="false">



  
    ..
    
      ../config/
      ../messages/
      ../tests/
      ../runtime/
      /home/hijarian/systems/yii/framework/
    
  



            target="report/html" 
        title="Lexgarant Online"
        charset="UTF-8" 
        yui="true" 
        highlight="true"
        lowUpperBound="35" highLowerBound="70" />



    
        ./unit/models/
        ./unit/logic/
        ./unit/components/

I have all the tests placed under the protected/tests directory in the application's catalogue, as described in the Test Environment Setup in The Definitive Guide to Yii.

PHPUnit is invoked as follows:

cd $APPDIR/protected/tests/
phpunit

The unit testing itself goes smoothly, only code coverage breaks.

Maybe I should set up the exlude list to exclude directories with Yii's classes, but I am somewhat afraid of this experience because there's dozens of folders, Yii is a highly modular system. Of course, if it's an only solution...

Originally asked by: hijarian on Stack Overflow

1 Vote(s)

[SOLVED] Running EqualCols.js and LightBox.js won't seem to work!

topdog — Sun, 05 Feb 2012 09:01:50 -0500

Ok, I'm building a website for a friend, I'm currently using jquery-1.2.6.min.js, corners.js, equalcols.js, and a pre-load image script in the head. Everything works great.

Problem is, I now need FancyBox (LightBox alternative) for a page and it won't seem to work! I know it's because something...

1 Vote(s)

PHP remember me function doesn't work [closed]

topdog — Sun, 05 Feb 2012 09:00:36 -0500

I have a website and want to remember the session by checking the box.

I have a code to remember username and password, but it doesn't work when i restart my browser.

Here is the code:

session_start();
session_regenerate_id();
$_SESSION['id'] = $id;
$_SESSION['mdid'] = $mdid;
$_SESSION['start'] = $start;
$_SESSION['firstname'] = $firstname;
$_SESSION['lastname'] = $lastname;
$_SESSION['username'] = $username;
$_SESSION['email'] = $email;
$_SESSION['password'] = $password;
$_SESSION['country'] = $country;
$_SESSION['city'] = $city;
$_SESSION['joined'] = $joined;
$_SESSION['activation'] = $activation;
$_SESSION['banned'] = $banned;
$_SESSION['ckey'] = $ckey;

   // these above variables are from database.


$ctimee = time();
$ckeyy = rand(100000,999999);
mysql_query("UPDATE users SET ckey='$ckeyy', ctime='$ctimee' WHERE id='$id'");
$remember = $_POST['remember'];

if($remember){
setcookie("id", $_SESSION['id'], time()+60*60*24*COOKIE_TIME_OUT, "/");

}

Originally asked by: Sandro Vardiashvili on Stack Overflow

0 Vote(s)

MySQL get Offset given Limit, Order By, and Where ID

topdog — Sun, 05 Feb 2012 09:00:22 -0500

I have a table that displays 10 rows per page. Now, given an item's ID, how can I get the "page" that the item is on?

In other words, I'm looking for the offset (multiple of 10) given an ID of a record.

SELECT * FROM items
WHERE category = "category"
LIMIT ?, 10      <----- TRYING TO FIGURE OUT HOW TO GET ? OFFSET GIVEN ID
ORDER BY id DESC

Originally asked by: PeterCPWong on Stack Overflow

1 Vote(s)

Google search: Scrape results page in PHP for total results

topdog — Sun, 05 Feb 2012 08:57:58 -0500

Is it possible to scrape the Google search results page using PHP to pull out the total number of search results found?

If so how would I go about doing this?

Thanks

Originally asked by: Probocop on Stack Overflow

0 Vote(s)

Ruby on rails: mysql error

topdog — Sun, 05 Feb 2012 08:55:03 -0500

I'm using windows xp 32 pro, bit, sp3. the latest version of railsinstaller, and mysql2 gem

i have been trying to solve this error all this week. When i run rake db:create I see this error

this is what i see when i trace the error

i have solved this error by downloading the zipped version of mysql Connector/C 6.0.2 for 32 bit and copying libmysql.dll from mysql-connector-c-noinstall-6.0.2-win32-vs2005\lib

to C:\RailsInstaller\Ruby1.9.2\bin

now when I run rake db:create i see

and this is what i see when i trace the error

i hope these info will help you, to help me solve the problem :)

Originally asked by: Someone Like You on Stack Overflow

1 Vote(s)

Retrieve date saved as string

topdog — Sun, 05 Feb 2012 08:51:34 -0500

I have dates in a database saved as varchar (11 September 2011). I am trying to make a query like this:

$result=mysql_query("SELECT * FROM post WHERE YEAR(STR_TO_DATE(datum,'%e %M %Y') ='2011')") or die(mysql_error());

It's returning NULL.

Originally asked by: InTry on Stack Overflow

1 Vote(s)

Migrate C# Hash Code to PHP

topdog — Sun, 05 Feb 2012 08:51:32 -0500

I know there are similar questions already on SO but none of them seem to address this problem. I have inherited the following c# code that has been used to create password hashes in a legacy .net app, for various reasons the C# implementation is now being migrated to php:

string input = "fred";
SHA256CryptoServiceProvider provider = new SHA256CryptoServiceProvider();
byte[] hashedValue = provider.ComputeHash(Encoding.ASCII.GetBytes(input));
string output = "";
string asciiString = ASCIIEncoding.ASCII.GetString(hashedValue);
foreach ( char c in asciiString ) {
   int tmp = c;
   output += String.Format("{0:x2}", 
             (uint)System.Convert.ToUInt32(tmp.ToString()));
}
return output;

My php code is very simple but for the same input "fred" doesn't produce the same result:

$output = hash('sha256', "fred");

I've traced the problem down to an encoding issue - if I change this line in the C# code:

string asciiString = ASCIIEncoding.ASCII.GetString(hashedValue);

string asciiString = ASCIIEncoding.UTF7.GetString(hashedValue);

Then the php and C# output match (it yields d0cfc2e5319b82cdc71a33873e826c93d7ee11363f8ac91c4fa3a2cfcd2286e5).

Since I'm not able to change the .net code I need to work out how to replicate the results in php.

Thanks in advance for any help,

Originally asked by: davet on Stack Overflow

1 Vote(s)

Creating an object from an array of multiple values

topdog — Sat, 04 Feb 2012 09:44:53 -0500

I have this function:

function getPostInfo($query, $fields, $type, $limit, $since, $until, $lang, $stopwords, $identifier) {
$url = file_get_contents('https://graph.facebook.com/search?q='.spaces($query).'&fields='.$fields.'&limit='.$limit.'&until='.$until);
 $j = json_decode($url);
  foreach($j->data as $v) {
  if ($v->type == $type) {
        $author_id = $v->from->id;
        $original_id = $v->id;
        $post_url = getPostUrl($original_id, $author_id);
        //$description = stopWords($v->message);
        $description = $v->message;
        $pub_date = $v->created_time;
        $post[]= array(
        'author_id' => $author_id, 
        'orginal_id' => $original_id, 
        'post_url' => $post_url, 
        'descritpion' => $description, 
        'pub_date' => $pub_date
        );
    }
 }  
 return (object)$post;
}

If I call for example:

`$post = getPostInfo($query, $fields, $type, $limit, $since, $until, $lang, $stopwords, $identifier);

echo $post->pub_date;`

it returns empty..

I tried to strip the [] from the $post array in the function...and in this case it returns only ONE value..

Instead it should return more values, because the object should get more values from the foreach loop in the above function..

But it's not happening..

I tried also to work with normal arrays, without an object, like this:

$post = getPostInfo($query, $fields, $type, $limit, $since, $until, $lang, $stopwords, $identifier);

echo $post['pub_date'];

In this case it always returns NULL..

What I am doing wrong?

How to assign more values to the array and getting them back when I need, knowing that the things I get should contain more values. It's like an array of an array...

I am a little confused..

I like the solution with objects, but if there is any other way, then better.

This is an example of what I get from the array $post:

array(5) { [0]=> array(5) { ["author_id"]=> string(10) "1319929690" ["orginal_id"]=> string(24) "1319929690_2736172406396" ["post_url"]=> string(77) "https://www.facebook.com/permalink.php?story_fbid=2736172406396&id=1319929690" ["descritpion"]=> string(773) "It was only a matter of time. # How do they serve alcoholic drinks on Italian cruise ships? - On the rocks # What vegetables do you get with dinner on Italian cruise ships? - Leeks # What's the fastest way to get off an Italian cruise ship? - Follow the captain # When the captain of the ill fated Costa Concordia was asked if he knew where he was going he replied "off course." # So the captain of the Costa Concordia will soon be in the dock. That's more than can be said for his ship. # The Costa Concordia is probably the most expensive thing to go down in Italy since Berlusconi's last hooker. # What's the difference between the Italian economy and the stricken cruise liner Costa Concordia? Nothing - The bottoms dropped out of both." ["pub_date"]=> string(24) "2012-02-04T14:36:54+0000" } [1]=> array(5) { ["author_id"]=> string(10) "1721122272" ["orginal_id"]=> string(24) "1721122272_1862454417365" ["post_url"]=> string(77) "https://www.facebook.com/permalink.php?story_fbid=1862454417365&id=1721122272" ["descritpion"]=> string(1968) "ThÃ¡ch thÃ ng nÃ o quÃ¡nh tao 1. Má»¸: â€œTao muá»‘n Ä‘Ã¡nh tháº±ng nÃ o, lÃ  tao Ä‘Ã¡nh tháº±ng Ä‘Ã³. NgoÃ i ra, tao bao tiá»n sÃºng!â€ 2. NATO: â€œMá»¹ Ä‘Ã¡nh tháº±ng nÃ o, tao Ä‘Ã¡nh tháº±ng Ä‘Ã³!â€. 3. NGA: â€œTháº±ng nÃ o báºt tao, tao cáº¯t dáº§u lá»a!â€. 4. ISRAEL: â€œtháº±ng nÃ o ngáº¥m ngáº§m muá»‘n Ä‘Ã¡nh tao, tao Ä‘Ã¡nh tháº±ng Ä‘Ã³!â€. 5. NHáº¬T: â€œtháº±ng nÃ o Ä‘Ã¡nh tao, tao sáº½ báº£o Má»¹ Ä‘Ã¡nh tháº±ng Ä‘Ã³. Náº¿u chÃºng mÃ y khÃ´ng ngá»«ng táº¥n cÃ´ng, tao cho Maria Ozawa nghá»‰ viá»‡c!â€. 6. TRUNG QUá»C: â€œTháº±ng nÃ o gáº§n tao, tao Ä‘Ã¡nh tháº±ng Ä‘Ã³!â€. 7. ÄÃ€I LOAN: â€œTháº±ng nÃ o Ä‘Ã²i Ä‘Ã¡nh tao, tao báº£o bÃ¡o chÃ chá»i tháº±ng Ä‘Ã³!â€. 8. NAM HÃ€N: â€œTháº±ng nÃ o Ä‘á»‹nh Ä‘Ã¡nh tao, tao táºp tráºn vá»›i tháº±ng Má»¹!â€. 9. Báº®C HÃ€N: â€œTháº±ng nÃ o lÃ m tao bá»±c, tao sáº½ Ä‘Ã¡nh tháº±ng Nam HÃ n!â€. 10. Berlusconi (ITALIA): â€œTháº±ng nÃ o oÃ¡nh tao, taoâ€¦ ngá»§ vá»›i vá»£ tháº±ng Ä‘Ã³!â€. 11. SINGAPORE : â€œTháº±ng nÃ o Ä‘Ã¡nh tao?!Cháº¯c Ä‘áº¿k tháº±ng nÃ o ráº£nh mÃ  Ä‘i Ä‘Ã¡nh tao!â€. 12. IRAQ : â€œTháº±ng nÃ o Ä‘Ã¡nh tao thÃ¬ cá»© Ä‘Ã¡nh cho Ä‘Ã£, chá»«ng nÃ o má»‡t thÃ¬ tá»± Ä‘á»™ng vá»!â€. 13. ARAP SAUDI : â€œTháº±ng nÃ o Ä‘Ã¡nh tao, tao mua tháº±ng Ä‘Ã³!â€ 14. Billaden: â€œTháº±ng nÃ o Ä‘Ã¡nh tao, tao khá»§ng bá»‘ tháº±ng Má»¹!â€. 15. LiÃªn Hiá»‡p Quá»‘c: â€œTao dÃ¡n cÃ¡i mÃ¡câ€¦ vÃ¹ng cáº¥m bay lÃªn tháº±ng nÃ o, chÃºng mÃ y Ãºp sá»t tháº±ng Ä‘áº¥y cho tao!â€. 16. CUBA : â€œTháº±ng nÃ o oÃ¡nh tao, tao cho Viá»‡t Nam má»™t mÃ¬nh canh giá»¯ tháº¿ giá»›i!â€. 17. VIá»†T NAM: â€œChá»- nÃ o cÃ³ oÃ¡nh nhau, tao bÃ y tá» quan ngáº¡i sÃ¢u sáº¯c. CÃ²n tháº±ng nÃ o oÃ¡nh tao, tao tuyÃªn bá»‘ chá»§ quyá»n, tao cáº¯t Ä‘iá»‡n luÃ¢n phiÃªn, sau Ä‘Ã³ taoâ€¦ cá»±c lá»±c lÃªn Ã¡n!â€. 18. THá»¤Y SÄ¨ : Tháº±ng nÃ o Ä‘Ã¡nh tao, Tao khÃ³a tÃ i khoáº£n tiá»n quá»‘c gia tháº±ng Ä‘Ã³. 19. PHILIPIN : â€ Tháº±ng nÃ o Ä‘Ã¡nh tao, muá»‘n há»©ng bÃ£o qua mÃ  Ä‘Ã¡nh. =]]" ["pub_date"]=> string(24) "2012-02-04T13:50:47+0000" } [2]=> array(5) { ["author_id"]=> string(9) "594958865" ["orginal_id"]=> string(27) "594958865_10150583915793866" ["post_url"]=> string(80) "https://www.facebook.com/permalink.php?story_fbid=10150583915793866&id=594958865" ["descritpion"]=> string(717) "# How do they serve alcoholic drinks on Italian cruise ships? - On the rocks # What vegetables do you get with dinner on Italian cruise ships? - Leeks # What's the fastest way to get off an Italian cruise ship? - Follow the captain # When the captain of the ill fated Costa Concordia was asked if he knew where he was going he replied "off course." # So the captain of the Costa Concordia will soon be in the dock. That's more than can be said for his ship. # The Costa Concordia is probably the most expensive thing to go down in Italy since Berlusconi's last hooker. # What's the difference between the Italian economy and the stricken cruise liner Costa Concordia? Nothing - The bottoms dropped out of both." ["pub_date"]=> string(24) "2012-02-04T13:15:45+0000" } [3]=> array(5) { ["author_id"]=> string(10) "1561522855" ["orginal_id"]=> string(24) "1561522855_2516825610916" ["post_url"]=> string(77) "https://www.facebook.com/permalink.php?story_fbid=2516825610916&id=1561522855" ["descritpion"]=> string(410) "Monti "frainteso" sulla monotonia del posto fisso??? Come Berlusconi che smentiva le proprie dichiarazioni mezzora dopo averle fatte??? Ma fatemi il piacere!!! La cosa che piÃ¹ mi fa specie Ã© assistere all'atteggiamento di tanti antiberlusconiani di maniera che ieri si stracciavano le vesti per ogni cazzata che proveniva da Arcore e che oggi sono pronti a digerire politiche ed esternazioni anche peggiori!!" ["pub_date"]=> string(24) "2012-02-04T12:46:50+0000" } [4]=> array(5) { ["author_id"]=> string(9) "749211731" ["orginal_id"]=> string(27) "749211731_10150528401901732" ["post_url"]=> string(80) "https://www.facebook.com/permalink.php?story_fbid=10150528401901732&id=749211731" ["descritpion"]=> string(265) "B. al Financial Times: "Mi farÃ² da parte dalla politica attiva e non ho nessuna intenzione di candidarmi ancora a primo ministro". Bossi: "Se Berlusconi si ritira Ã¨ risolto il problema". La solida alleanza parlamentare che ha governato l'Italia in questi 20 anni." ["pub_date"]=> string(24) "2012-02-04T11:57:05+0000" } }

Originally asked by: DiegoP. on Stack Overflow

1 Vote(s)

WSO2 WSF error / rampart_context_create

topdog — Sat, 04 Feb 2012 09:44:27 -0500

After installing wsf/php 2.1 using

All Examples work except for security examples... and I get this error logged in apache error.log:

/usr/lib/php5/xxx/wsf.so: undefined symbol: rampart_context_create

I am running Ubuntu 11.10 and PHP 5.3.6-13ubuntu3.3 with Suhosin-Patch (cli) (built: Dec 13 2011 18:37:10)

What could be the error?

Originally asked by: user1188417 on Stack Overflow

0 Vote(s)

get the specified outpot using php 2d array

topdog — Sat, 04 Feb 2012 09:43:27 -0500

I have got a 2d array called $myarray, and when I using var_dump($myarray), it gives me the following:

  array(4) { [0]=> array(2) { [0]=> string(3) "EUR" [1]=> string(9) "43,543.23" } [1]=> array(2) { [0]=> string(3) "USD" [1]=> string(9) "13,432.34" } [2]=> array(2) { [0]=> string(3) "GBP" [1]=> string(8) "3,432.21" } [3]=> array(2) { [0]=> string(3) "CAD" [1]=> string(8) "2,321.34" } }

But I want the output to be the follwing format:

Totals
GBP 3,432.21
USD 13,432.34
EUR 43,543.23
CAD 2,321.34

I assume that I need to sort the array to be:

GBP 3,432.21
USD 13,432.34
EUR 43,543.23
CAD 2,321.34

and add "Totals", "" into the array, I might be wrong, soanybody could help me with that, any help will be greatly appreciated!

Originally asked by: smith on Stack Overflow

1 Vote(s)

Generate Distinct Combinations PHP

topdog — Sat, 04 Feb 2012 09:42:43 -0500

I need an efficient algorithm to generate distinct combinations(not allowed to repeat). Each combination has 5 distint numbers(different numbers) that ranges between 1 and 99. The result must be stored in an array. If possible I would like the numbers and range allowed to be customized. The order of number doesn't matter(01 02 03 = 03 01 02)

 Ex.: 
 01 02 03 04 05
 02 03 04 05 06
 ...

Does anyone could help me to build it? I would like to pick up some random combinations from the array. Nowdays I am generating random combinations using mt_rand but It takes too much time, SO SLOW! I believe happens to repeat so often then takes time to generate new one and new one...

Originally asked by: Rafael on Stack Overflow

0 Vote(s)