I have discovered that MySQL is returning odd results when searching on INT columns.

a)

SELECT *
  FROM `sellers` 
 WHERE `seller_key` = '1' 

Returns seller with the key 1.

b)

SELECT * 
  FROM `sellers` 
 WHERE `seller_key` = '1sdjhksadhak' 

Returns seller with the key 1.

c)

SELECT * 
  FROM `sellers` 
 WHERE `seller_key` = '1adlksajdkj187987'

Returns seller with the key 1.

d)

SELECT * 
  FROM `sellers` 
 WHERE `seller_key` = 'adlksajdkj187987' 

Does not return anything.

Why does b and c return a result? if there a way to make the searching strict?

Originally asked by: cappuccino on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/mysql-sum-query-1/ http://www.globberstack.com/Questions/mysql-sum-query-1/ Fri, 10 Sep 2010 09:36:56 -0400 topdog Questions http://www.globberstack.com/Questions/mysql-sum-query-1/

Greetings, I've got a query that I'm struggling with, this is the first time that I am encountering this type of query.
I have two table as shown below.

xid is the primary key in parent_tbl1, while xid is the foreign key in child_tbl2

parent_tbl1

xid pub 
1    1    
2    1    
3    0    
4    1

child_tbl2

id ttype fno xid  qnty
1  A       0    1    0
2  A       1    1    3
3  B       1    1    4
4  A       1    2    1  
5  A       1    3    2
6  A       1    4    3
7  A       1    4    1
8  A       1    1    1

Below is the exlanation of the query in parts, which will then need to make up the whole query.

I need the SUM of qnty in child_tbl2:

1) Who's parent's pub is '1'
Therefore, id 5 is eliminated from child_tbl2, this is because xid 3 is 0 in parent_tbl1

Results:
child_tbl2

id ttype fno xid qnty
1  A       0    1    0
2  A       1    1    3
3  B       1    1    4
4  A       1    2    1
6  A       1    4    3
7  A       1    4    1
8  A       1    1    1

2) AND who's parent table has ttype 'A' in the child table
Therefore, id 3 is eliminated from the existing results because id 3's ttype is B

Results:
child_tbl2

id ttype fno xid qnty
1  A       0    1    0
2  A       1    1    3
4  A       1    2    1
6  A       1    4    3
7  A       1    4    1
8  A       1    1    1

3) AND who's parent has '0' as one it's fno's in the child_tbl2
Therefore, id 4, 6 & 7 are eliminated from the existing results, this is because 0 was not found in one of their fno's, while 0 was found as one of xid 1's fno

Results:
child_tbl2

id ttype fno xid qnty
1  A       0    1    0
2  A       1    1    3
8  A       1    1    1

The answer for the query should be 4

Below is what i've got.

SELECT sum(child_tbl2.qnty), parent_tbl1.xid, parent_tbl1.pub, child_tbl2.ttype, child_tbl2.fno, child_tbl2.xid 
FROM parent_tbl1, child_tbl2
WHERE parent_tbl1.xid = child_tbl2.xid
AND parent_tbl1.pub = '1'
AND child_tbl2.ttype = 'A'

AND child_tbl2.fno ? 

If it is possible, I do not know how to tell the dbms (MySQL) to check if Zero is one of the fno's.
If I say "AND child_tbl2.fno = '0'", I will be saying that the result's fno should be 0. I do not want that, I need zero to be one of the fno's in order for the query to SUM all the qnty in that particular xid

Originally asked by: Nich on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/creating-json-from-a-comma-delimited-string-with-php-1/ http://www.globberstack.com/Questions/creating-json-from-a-comma-delimited-string-with-php-1/ Fri, 10 Sep 2010 09:36:14 -0400 topdog Questions http://www.globberstack.com/Questions/creating-json-from-a-comma-delimited-string-with-php-1/

Hi guys,

I am trying to create JSON from a comma delimited string, the string look something like this:

One,Two,Three,Four,Five,Six,Seven

I need it to look something like this:

[{"test":"One"},{"test":"Two"},{"test":"Three"},{"test":"Four"},{"test":"Five"},{"test":"Six"},{"test":"Seven"}]

Here is the code I have thus far:

$string = mysql_fetch_array($test, true);
$woot = explode(',', $string['test']);

$json = json_encode($woot);
echo($json);

Thanx in advance!

Originally asked by: kielie on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/what-is-a-best-practice-method-to-log-visits-per-page-object-1/ http://www.globberstack.com/Questions/what-is-a-best-practice-method-to-log-visits-per-page-object-1/ Fri, 10 Sep 2010 09:29:49 -0400 topdog Questions http://www.globberstack.com/Questions/what-is-a-best-practice-method-to-log-visits-per-page-object-1/

Take my profile for example, or any question number of views on this site, what is the process of logging the number of visits per page or object on a website, which I presumably think includes:

• Counting registered users once (thist must be reflected in the db, which pages / objects the user has visited). this will also not include unregistered users


• IP: log the visit of each IP per page / object; this could be troublesome as you might have 2 different people checking the same website; or you really do want to track repeat visitors.


• Cookie: this will probably result in that people with multiple computers would be counted twice


• other method goes here ....

The question is, what is the process and best practice to count user requests?

EDIT

I've added the computer languages to the list of tags as they are of interest to me. Feel free to include any libraries, modules, and/or extensions that achieve the task.

The question could be rephrased into:

• How does someone go about measuring the number of imprints when a user goes on a page? The question is not intended to be similar to what Google analytics does, rather it should be something similar to when you click on a stackoverflow question or profile and see the number of views.

Originally asked by: dassouki on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/is-there-a-simple-way-to-keep-mysql-row-ids-from-growing-1/ http://www.globberstack.com/Questions/is-there-a-simple-way-to-keep-mysql-row-ids-from-growing-1/ Fri, 10 Sep 2010 09:27:06 -0400 topdog Questions http://www.globberstack.com/Questions/is-there-a-simple-way-to-keep-mysql-row-ids-from-growing-1/

I was wondering what the simplest way of letting a table set ids automatically is, apart from AUTO_INCREMENT.

I have a table that will accumulate thousands of rows over a long period of time. Some of these rows will be deleted at a later time. How do I get new rows to get the lowest available id, without getting into doing it manually.

Can I for instance reset AUTO_INCREMENT every time someone adds a row?

Originally asked by: Codemonkey on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/mysql-query-not-giving-correct-results-1/ http://www.globberstack.com/Questions/mysql-query-not-giving-correct-results-1/ Fri, 10 Sep 2010 09:16:53 -0400 topdog Questions http://www.globberstack.com/Questions/mysql-query-not-giving-correct-results-1/

I have a table called records which has several columns, one of which is fromphone which represents a phone number. I can run this query to see the different phone numbers:

SELECT DISTINCT fromphone
FROM records

and it shows the different phone numbers.

However, if I run this query:

SELECT *
FROM records
WHERE fromphone = '123-456-7890'

where fromphone is a phone number in the table, no results get returned.

Originally asked by: JPC on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/what-type-does-fwrite-returns-1/ http://www.globberstack.com/Questions/what-type-does-fwrite-returns-1/ Fri, 10 Sep 2010 09:16:03 -0400 topdog Questions http://www.globberstack.com/Questions/what-type-does-fwrite-returns-1/

On the php manual we can read:

fwrite() returns the number of bytes written

Ok... but what kind of thing is "number of bytes written"?

Binary string? Binary number? Stream? Int?

I'm a little bit lost here.

Regards

Originally asked by: MEM on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/symfony-update-a-model-schema-1/ http://www.globberstack.com/Questions/symfony-update-a-model-schema-1/ Fri, 10 Sep 2010 09:12:41 -0400 topdog Questions http://www.globberstack.com/Questions/symfony-update-a-model-schema-1/

So heres the scenario:

Currently we have a development site with 3 models. We found we didn't like our initial schema and added a few rows. We re-generated the schema (doctrine:build-sql).

Now it forced us to drop and re-create all the tables and dump back in all the information as no ALTERS were created but rather CREATE statements only. Not a problem...

The big problem came to updating the models. After we ran a build-all and such a few errors popped up i.e. "Widget sort not found" etc. We figured out we needed to rebuild the models. So we can a symfony doctrine:build-models course Course (Course was the table name...course the models). This worked great and fixed the broken links within Symfony.

The downside is all custom code in the actions.class.php file was lost as were customizations to the _form.php page.

My question on this is, how do we store our own actions so they are not lost if you update a models schema? Similarly templates and such are re-generated to but do not hold any customizations.

There surely must be a simple solution to updating a model's schema in symfony?

Originally asked by: CogitoErgoSum on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/css-links-not-working-as-planned-1/ http://www.globberstack.com/Questions/css-links-not-working-as-planned-1/ Fri, 10 Sep 2010 09:08:56 -0400 topdog Questions http://www.globberstack.com/Questions/css-links-not-working-as-planned-1/
My website has a navigation where the links change if you are on that page, have a look at it to see what I mean: http://www.goathland.co.cc

On the gallery I have done a similar thing to show the user what gallery they are in but I am having trouble getting it to work for the main gallery page. This is the HTML for the page:

How can I go about grabbing [x] number of words before and after a given keyword in a string in PHP? I am trying to tokenize results from a mysql query tailored to the keyword as a snippet.

Originally asked by: Jaime Cross on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/horizontal-menu-with-images-and-rollover-states-1/ http://www.globberstack.com/Questions/horizontal-menu-with-images-and-rollover-states-1/ Fri, 10 Sep 2010 09:02:33 -0400 topdog Questions http://www.globberstack.com/Questions/horizontal-menu-with-images-and-rollover-states-1/
Okay. I know how to make a simple horizontal menu using HTML and CSS. But instead of using text, I would like to use images. Each link on the menu is represented by one of three images. Image1A for the active page, Image1B for a link, and Image1C for hover. When the user looks at the menu, there will only be one Image in the "A" state (and that is the page they are currently on). The other image links will be in the "B" state unless hovered over, in which case they go to the "C" state.

I've tried a ton of tutorials, and not a single one works for what I'm trying to do ... which should be simple and easy, but apparently it's not. I've checked out source code from other websites, but it looks either too complicated or too different from what I'm doing.

I'd link to my site, but I don't want to make this page live yet, since it looks like crap.

Suggestions and advice would be much appreciated.

0 Vote(s) ]]> http://www.globberstack.com/Questions/bottom-not-lining-up-correct-help-please-1/ http://www.globberstack.com/Questions/bottom-not-lining-up-correct-help-please-1/ Fri, 10 Sep 2010 08:59:35 -0400 topdog Questions http://www.globberstack.com/Questions/bottom-not-lining-up-correct-help-please-1/
I wanted to switch a index page from html tables to css and after three days of crawling in the corner and eating my hair I am finally getting closer to what I want however the bottom is not lining up correct. No matter how much I tweak with height of the section it is does not change or something... I am very lost on this one. Logically the change the height changes the height of the section. I also messed with the height in the body codes but that did not help either.

Here is the page: http://www.momsbreak.com/

Codes I can't seem to fix correctly.

/* Articles */
#container3 {
width: 900px;
margin-top: 10px;
margin-left: 0px;
margin-right: 0px;
text-align: left;
margin-left: auto;
margin-right: auto;
height: 3500px;
}
#page_content3 {
border: thick #68647B dashed;
background-color: #FFFFFF;
font-family: Arial, Helvetica, sans-serif;
font-size: medium;
font-weight: normal;
padding-left: 20px;
padding-right: 20px;
padding-top: 20px;
height: 3500px;
padding-bottom: 20px;
}


Any help is much appreciated.
Kimber

0 Vote(s) ]]> http://www.globberstack.com/Questions/update-framework-for-php-1/ http://www.globberstack.com/Questions/update-framework-for-php-1/ Fri, 10 Sep 2010 08:59:05 -0400 topdog Questions http://www.globberstack.com/Questions/update-framework-for-php-1/

Does anyone know of a framework (written in PHP) to update PHP-based software ?

I'm thinking of a library that assists in checking for updates online and that provides methods for generating, downloading, verifying and installing update packages, maybe even with encryption and public-key signatures.

Ideally with a non-copyleft open source license (e.g. BSD or MIT License, no GPL).

While source control tools are nice in theory, they can complicate (initial) deployment of PHP applications as they are not PHP-based (limits portability) and are often quite large.

Originally asked by: Archimedix on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/how-to-run-a-shell-command-through-php-code-1/ http://www.globberstack.com/Questions/how-to-run-a-shell-command-through-php-code-1/ Fri, 10 Sep 2010 08:57:06 -0400 topdog Questions http://www.globberstack.com/Questions/how-to-run-a-shell-command-through-php-code-1/

Hello Experts,
I am trying to run a Jar file in the backend of my php code.But I am not getting the desired output to it.There is a jar file which runs in the background and returns the Page Rank of any of the keyword and Domain given to it.
I am attaching the code,please suggest me any solution to it,because when I run it on the terminal,it is giving correct output.

Here is the Code :

    <?php
set_time_limit(0);
function returnJarPath()
{
    $jarPath = $_SERVER['DOCUMENT_ROOT'] . "myFolder/tools_new/includes/Rank.jar";
    return $jarPath;
}
$jar = returnJarPath();
$command = "java -jar $jar aspdotnet/microsoft.com";//Passing the Argument to the Jar file.


$shellOutput = shell_exec($command);
    print "The Shell Output is : " ; var_dump($shellOutput);print "<br />";
exec($command,$executeCommmand);
    print "The Exec returns the value : " ; var_dump($executeCommmand);print "<br />";
passthru($command,$passthruCommand);
    print "The Passthru returns the value : " . $passthruCommand. "<br />";
?>

Originally asked by: Nishant Shrivastava on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/filter-specific-string-in-php-1/ http://www.globberstack.com/Questions/filter-specific-string-in-php-1/ Fri, 10 Sep 2010 08:53:47 -0400 topdog Questions http://www.globberstack.com/Questions/filter-specific-string-in-php-1/

hello i have string like

$var="UseCountry=1
UseCountryDefault=1
UseState=1
UseStateDefault=1
UseLocality=1
UseLocalityDefault=1
cantidad_productos=5
expireDays=5
apikey=ABQIAAAAFHktBEXrHnX108wOdzd3aBTupK1kJuoJNBHuh0laPBvYXhjzZxR0qkeXcGC_0Dxf4UMhkR7ZNb04dQ
distancia=15
AutoCoord=1
user_add_locality=0
SaveContactForm=0
ShowVoteRating=0
Listlayout=0
WidthThumbs=100
HeightThumbs=75
WidthImage=640
HeightImage=480
ShowImagesSystem=1
ShowOrderBy=0
ShowOrderByDefault=0
ShowOrderDefault=DESC
SimbolPrice=$
PositionPrice=0
FormatPrice=0
ShowLogoAgent=1
ShowReferenceInList=1
ShowCategoryInList=1
ShowTypeInList=1
ShowAddressInList=1
ShowContactLink=1
ShowMapLink=1
ShowAddShortListLink=1
ShowViewPropertiesAgentLink=1
ThumbsInAccordion=5
WidthThumbsAccordion=100
HeightThumbsAccordion=75
ShowFeaturesInList=1
ShowAllParentCategory=0
AmountPanel=
AmountForRegistered=5
RegisteredAutoPublish=1
AmountForAuthor=5
AmountForEditor=5
AmountForPublisher=5
AmountForManager=5
AmountForAdministrator=5
AutoPublish=1
MailAdminPublish=1
DetailLayout=0
ActivarTabs=0
ActivarDescripcion=1
ActivarDetails=1
ActivarVideo=1
ActivarPanoramica=1
ActivarContactar=1
ContactMailFormat=1
ActivarReservas=1
ActivarMapa=1
ShowImagesSystemDetail=1
WidthThumbsDetail=120
HeightThumbsDetail=90
idCountryDefault=1
idStateDefault=1
ms_country=1
ms_state=1
ms_locality=1
ms_category=1
ms_Subcategory=1
ms_type=1
ms_price=1
ms_bedrooms=1
ms_bathrooms=1
ms_parking=1
ShowTextSearch=1
minprice=
maxprice=
ms_catradius=1
idcatradius1=
idcatradius2=
ShowTotalResult=1
md_country=1
md_state=1
md_locality=1
md_category=1
md_type=1
showComments=0
useComment2=0
useComment3=0
useComment4=0
useComment5=0
AmountMonthsCalendar=3
StartYearCalendar=2009
StartMonthCalendar=1
PeriodOnlyWeeks=0
PeriodAmount=3
PeriodStartDay=1
apikey=ABQIAAAAJ879Hg7OSEKVrRKc2YHjixSmyv5A3ewe40XW2YiIN-ybtu7KLRQiVUIEW3WsL8vOtIeTFIVUXDOAcQ
";

in that string only i want "api==ABQIAAAAJ879Hg7OSEKVrRKc2YHjixSmyv5A3ewe40XW2YiIN-ybtu7KLRQiVUIEW3WsL8vOtIeTFIVUXDOAcQ";
plz guide me correctly;

Originally asked by: hardik55 on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/parsing-a-json-object-with-jquery-and-creating-two-drop-down-lists-with-that-data-1/ http://www.globberstack.com/Questions/parsing-a-json-object-with-jquery-and-creating-two-drop-down-lists-with-that-data-1/ Fri, 10 Sep 2010 08:47:37 -0400 topdog Questions http://www.globberstack.com/Questions/parsing-a-json-object-with-jquery-and-creating-two-drop-down-lists-with-that-data-1/

Hi guys, I am trying to dynamically create two drop down lists, one will be provinces, and the other will contain the cities of each province, so when a user chooses a province, the cities drop down will populate, I am using jQuery's $.ajax funtion to get the data from a database which then passes it back as JSON, here is what I have thus far,

jQuery:

$.getJSON("provinces.php", function(data){

//clean out the select list
$('#province').html('');

    //run the loop to populate the province drop down list
    $.each(data, function(i, json) {
        var province = json.province;
        var cities = json.cities;

        $('#province').append(
            $('<option></option>').html(province)
        );

    });
});

a snippit of the JSON:

[
 {"province":"Eastern Cape","cities":"Mthatha,Njoli,Port Alfred,Port Elizabeth,Queenstown,Uitenhage"},
 {"province":"Freestate","cities":"Thaba Nchu,Virginia,Welkom"}
]

I am populating the provinces drop down, but not the cities drop down.

I would like to hear from you guys what you think the best method will be to achieve the cities drop down.

Thanx in advance!

Originally asked by: kielie on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/passing-a-propel-criteria-to-the-symfony-routing-function-that-retrieves-the-object-1/ http://www.globberstack.com/Questions/passing-a-propel-criteria-to-the-symfony-routing-function-that-retrieves-the-object-1/ Fri, 10 Sep 2010 08:46:43 -0400 topdog Questions http://www.globberstack.com/Questions/passing-a-propel-criteria-to-the-symfony-routing-function-that-retrieves-the-object-1/

Hi guys, quick symfony / propel question.
I have the following propel collection route:

api_offer:
  class: sfPropelRouteCollection
  options:
    prefix_path: /api/offer
    model: Offer
    plural: offers
    singluar: offer
    actions: [ list ]
    module: apiOffer
  requirements:
    sf_format: (?:html|json)

My question is, does anyone know of a way to pass a Criteria to the $this->getRoute()->getObjects(); in the action? Basically I need to retrieve different objects from the database depending on existing parameters in the route.

Thanks for all you help.

Originally asked by: vincent on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/topis-research-1/ http://www.globberstack.com/Questions/topis-research-1/ Fri, 10 Sep 2010 08:46:08 -0400 topdog Questions http://www.globberstack.com/Questions/topis-research-1/ navigation bar created out of an image. (done)

on the hovers effect on each category, a drop down menu will appear. That is all I want. The turorials I have found so far are either too complex or too basic and do not use images.
I would appreciate any help I can get.

I basically trying to learn how to create the drop down box and set shape it the way I want.

0 Vote(s) ]]> http://www.globberstack.com/Questions/what-is-the-best-way-to-lay-out-my-cms-1/ http://www.globberstack.com/Questions/what-is-the-best-way-to-lay-out-my-cms-1/ Thu, 09 Sep 2010 09:43:52 -0400 topdog Questions http://www.globberstack.com/Questions/what-is-the-best-way-to-lay-out-my-cms-1/

Basically once the user is logged in they will be able to edit a news article and the image gallery and pdf's which will be attached to it, the image galleries can be used in multiple news articles so can the pdf's - so what is the best way to lay the CMS out?

I should have mentioned that I'm building the entire website using Codeigniter so want to build my own CMS - just really wanted some ideas on the best way to lay the CMS out.

Originally asked by: newbie on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/notify-user-his-password-has-been-changed-via-text-message-on-the-same-page-with-php-or-ajax-1/ http://www.globberstack.com/Questions/notify-user-his-password-has-been-changed-via-text-message-on-the-same-page-with-php-or-ajax-1/ Thu, 09 Sep 2010 09:38:41 -0400 topdog Questions http://www.globberstack.com/Questions/notify-user-his-password-has-been-changed-via-text-message-on-the-same-page-with-php-or-ajax-1/

Hi guys,

Here is the scenario. A user wants to change his password. So he login and fill up his new desired password and clicked submit. Back end PHP checks his codes and updated it in MySQL database. User is brought back to the same page (with the form) and is notified by this small paragraph sitting on the top of the page that his password has been changed successfully.

Is it possbile to do this with PHP only (without jQuery)?

Apologies if I had phrased my question poorly.

Originally asked by: dave on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/installing-postfix-without-mysql-all-i-want-is-to-send-mail-from-djangophp-1/ http://www.globberstack.com/Questions/installing-postfix-without-mysql-all-i-want-is-to-send-mail-from-djangophp-1/ Thu, 09 Sep 2010 09:38:36 -0400 topdog Questions http://www.globberstack.com/Questions/installing-postfix-without-mysql-all-i-want-is-to-send-mail-from-djangophp-1/

I'm currently setting up two servers, one for me and one for a client. Mine is purely a Django server with no PHP in sight. The other is a PHP server with no Django in sight. They are both VPSs with Ubuntu Server 10.04 Lucid on them.

Both require some sort of mail server so the Django and PHP applications can send mail from the server. Both servers don't require email accounts as I do these with Google Apps For Domains. I merely want a solution for letting these technologies send mail, in a way that is totally standard. (no funny send mail setups or anything...)

I was told Postfix is the way to go for email servers. But everywhere I see that it should have MySQL as well. Is this the only way to have a functional Postfix server? Though my client's PHP server will have MySQL anyhow (as it will be hosting the PHP based Simple Machines Forum), my Django server will be using PostgreSQL throughout. And the idea of installing MySQL just for Postfix there seems over the top for me.

Is there other solutions out there? Am I looking at this all wrong? Is there maybe other solutions that would fill this need?

Originally asked by: littlejim84 on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/how-to-use-dbdeploy-with-sql-server-1/ http://www.globberstack.com/Questions/how-to-use-dbdeploy-with-sql-server-1/ Thu, 09 Sep 2010 09:38:32 -0400 topdog Questions http://www.globberstack.com/Questions/how-to-use-dbdeploy-with-sql-server-1/

Guys,

I need help in setting up dbdeploy for my SQL Server database and MySQL Server.

The example in the dbdeploy website does not tell me how to set the drivers for SQL Server and MySQL. Am a bit lost.

Sample scripts will be appreciated.

Thanks

Originally asked by: gath on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/php-dynamic-drop-down-menu-error-1/ http://www.globberstack.com/Questions/php-dynamic-drop-down-menu-error-1/ Thu, 09 Sep 2010 09:37:31 -0400 topdog Questions http://www.globberstack.com/Questions/php-dynamic-drop-down-menu-error-1/

Hi There! I am trying to script a simple dynamic drop down menu showing the tables that exist within my database using PHP 5. I currently have 2 tables installed in my MySQL database.

I have managed to run the script without problem with the menu showing up on my browser however the menu shows 2 entries but they have no words! The menu just contains 2 blank entries once I click the arrow button.

The script is shown below:

<?php
include "db_connect.php";
{
?>
<td valign=top><strong>Name:</strong></td>
<td>
<?php
echo "<select name=\"name\">"; 
echo "<option size =30 selected>Select</option>";

$result = mysql_query("show tables");

if(!$result) trigger_error("Query Failed: ".  mysql_error($db), E_USER_ERROR);

if(mysql_num_rows($result)) 
{ 
while($table_array = mysql_fetch_assoc($result)) 
{ 
    echo "<option>$table_array[0]</option>"; 
} 
} 
else 
{
echo "<option>No Names Present</option>";  
} 

}
?>
</td>

Please do help pr give suggestions. Thanks.

Originally asked by: JavaNoob on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/cronjob-delaying-based-on-php-output-1/ http://www.globberstack.com/Questions/cronjob-delaying-based-on-php-output-1/ Thu, 09 Sep 2010 09:33:05 -0400 topdog Questions http://www.globberstack.com/Questions/cronjob-delaying-based-on-php-output-1/

I'm in charge of a printer, so I wrote a script which runs every 5 minutes and figures out if the printer has paper. If it doesn't, the script will text me. The problem is, if I'm busy, and can't fill the printer, I don't want the script to continue to text me every 5 minutes. Is there a way I can force it to only send me at most 1 text every 8 hours or so, to ensure that the script doesn't text me twice for the same out-of-paper situation? The only thing I can currently think of is to create a db of times that I get texts, then make sure that the most recent one wasn't too long ago, or to create a local file with the most recent time in it.

Thanks!

Originally asked by: codersarepeople on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/echo-json-encode-with-2-variables-with-jquery-form-plugin-1/ http://www.globberstack.com/Questions/echo-json-encode-with-2-variables-with-jquery-form-plugin-1/ Thu, 09 Sep 2010 09:29:07 -0400 topdog Questions http://www.globberstack.com/Questions/echo-json-encode-with-2-variables-with-jquery-form-plugin-1/

code inside php file:

$variable1 = array( 'variable1' => "$variable1" );
      $variable2 = array( 'variable2' => "$variable2" );
            echo json_encode ($variable1);

code inside main page:

<span id="variable1"></span>
<span id="variable2"></span>

I am trying to make it so it echos both variables in their spans.
doing 2 echos does not work, but the single as coded above works

using the jquery form plugin for this.

Originally asked by: Jamie on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/solved-need-recommendations-of-word-press-themes-1/ http://www.globberstack.com/Questions/solved-need-recommendations-of-word-press-themes-1/ Thu, 09 Sep 2010 09:16:09 -0400 topdog Questions http://www.globberstack.com/Questions/solved-need-recommendations-of-word-press-themes-1/
0 Vote(s) ]]> http://www.globberstack.com/Questions/whats-the-fastest-way-to-poll-a-mysql-table-for-new-rows-1/ http://www.globberstack.com/Questions/whats-the-fastest-way-to-poll-a-mysql-table-for-new-rows-1/ Thu, 09 Sep 2010 09:12:08 -0400 topdog Questions http://www.globberstack.com/Questions/whats-the-fastest-way-to-poll-a-mysql-table-for-new-rows-1/

My application needs to poll a MySQL database for new rows. Every time new rows are added, they should be retrieved. I was thinking of creating a trigger to place references to new rows on a separate table. The original table has over 300,000 rows.

The application is built in PHP.

Originally asked by: gAMBOOKa on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/whats-best-way-to-backup-databases-1/ http://www.globberstack.com/Questions/whats-best-way-to-backup-databases-1/ Thu, 09 Sep 2010 09:11:24 -0400 topdog Questions http://www.globberstack.com/Questions/whats-best-way-to-backup-databases-1/
0 Vote(s) ]]> http://www.globberstack.com/Questions/uncaught-exception-pdoexception-with-message-sqlstatehy000-2003-cant-connect-to-mysql-server-1/ http://www.globberstack.com/Questions/uncaught-exception-pdoexception-with-message-sqlstatehy000-2003-cant-connect-to-mysql-server-1/ Thu, 09 Sep 2010 09:00:17 -0400 topdog Questions http://www.globberstack.com/Questions/uncaught-exception-pdoexception-with-message-sqlstatehy000-2003-cant-connect-to-mysql-server-1/

Hi, I am using Zend Framework and my application works on localhost but produces the can't connect to MySQL server error when I'm trying to connect to the database I've uploaded on a live server. I've tried handling exceptions and Zend_Exception catches it("perhaps factory() failed to load the specified Adapter class"). I've emailed the webmaster and he told me that Phpmyadmin is working fine so there should be no problem with connecting php to mysql. What else can I do? The lines that produces the error are the following:

    $db = Zend_Registry::get('db');
    $sql = 'SELECT * FROM department';
    $result = $db->fetchAll($sql);  

Is there something specific I can ask the webmaster to look at?

Originally asked by: user429148 on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/how-to-force-mysql-to-take-0-as-a-valid-auto-increment-value-1/ http://www.globberstack.com/Questions/how-to-force-mysql-to-take-0-as-a-valid-auto-increment-value-1/ Thu, 09 Sep 2010 08:58:14 -0400 topdog Questions http://www.globberstack.com/Questions/how-to-force-mysql-to-take-0-as-a-valid-auto-increment-value-1/

Long story short, I have a SQL file that I want to import as a skel style file, so this will be done repeatedly, programmatically. I can edit the SQL file however I want, but I'd rather not touch the application itself.

This application uses userid = 0 to represent the anonymous user. It also has a relevant (blank) entry in the database to represent this 'user'. Hence, the line in my skel.sql looks something like this:

INSERT INTO `{{TABLE_PREFIX}}users` VALUES (0, '', '', '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, NULL, '', '', '', NULL);

The problem with this is that uid is a auto_increment field, for which, technically, 0 is an invalid value. Or atleast, if you set it to 0, you're basically telling MySQL, "Please insert the next id into this field."

Now, I suppose I could put an INSERT then an UPDATE query into my SQL file, but is there a way of telling MySQL in general that yes, I actually want to insert 0 into this field?

Originally asked by: Matthew Scharley on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/current-uri-segment-in-codeigniter-1/ http://www.globberstack.com/Questions/current-uri-segment-in-codeigniter-1/ Thu, 09 Sep 2010 08:54:57 -0400 topdog Questions http://www.globberstack.com/Questions/current-uri-segment-in-codeigniter-1/

What would be the best way to check for the current URI segment in a CodeIgniter view? What I am trying to do is use the current URI segment [i.e. $this->uri->segment(1)] in order to highlight the current page on the navigation bar.

The best that I have figured out is to do

$data['current_uri'] = $this->uri->segment(1);
$this->load->view('header', $data);

in each of my controllers and then in the header.php file, I check the $current_uri variable to determine which part of the navigation should be highlighted. As you know, this is a very tedious way of doing it, but I'm at a loss of a better way to do this.

It may even be possible to extend the default Controller class to pass the current URI segment, but I'm not sure if this would work, or even how to go about doing it.

Originally asked by: Jared on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/firefox-displays-page-but-not-safari-1/ http://www.globberstack.com/Questions/firefox-displays-page-but-not-safari-1/ Thu, 09 Sep 2010 08:51:53 -0400 topdog Questions http://www.globberstack.com/Questions/firefox-displays-page-but-not-safari-1/
0 Vote(s) ]]> http://www.globberstack.com/Questions/best-way-to-store-user-permissions-1/ http://www.globberstack.com/Questions/best-way-to-store-user-permissions-1/ Thu, 09 Sep 2010 08:51:09 -0400 topdog Questions http://www.globberstack.com/Questions/best-way-to-store-user-permissions-1/

Hey all,

Designing a fairly complicated site with a lot of ajax running on a single page. I have reached the point where some user's need to have specific permission to do things and some need to be stopped from the action. I have set up user roles in my database and all is working fine, but I wonder if there is an easier/safer method for me to store each permission.

Currently, when a user logs in their specific permissions are grabbed from the db and loaded into a session array. To check if the user has permission, I simply check to see if the permission is contained in the array. This seems sluggish, and almost like I am missing a better solution.

Also, sessions can apparently be edited by the user... is there a safer method?

I have thought running a query for each check, but that could greatly increase the load time for a simple ajax request.

I am open to any and all ideas. Thanks.

Originally asked by: Capt Otis on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/using-an-html-checkbox-to-put-1-or-0-into-a-mysql-table-1/ http://www.globberstack.com/Questions/using-an-html-checkbox-to-put-1-or-0-into-a-mysql-table-1/ Thu, 09 Sep 2010 08:49:44 -0400 topdog Questions http://www.globberstack.com/Questions/using-an-html-checkbox-to-put-1-or-0-into-a-mysql-table-1/

Hello,

I am using a simple HTML checkbox in a form to put a 1 for checked and a 0 for unchecked in a field called "subcheck" in a MySQL table.

Does the checkbox default to 1 for "checked" and 0 for unchecked? If not, how can I give it those values?

Thanks in advance,

John

Form:

<div class="subcheck"><INPUT TYPE=CHECKBOX NAME="subcheck">Click here to receive free money in the mail.<P></div>

In the file the form goes to:

$subcheck = $_POST['subcheck'];

mysql_query("INSERT INTO submission VALUES (NULL, '$uid', '$title', '$slug', '$cleanurl', '$displayurl', NULL, '$subcheck')");

The MySQL table:

`submission` (
  `submissionid` int(11) unsigned NOT NULL auto_increment,
  `loginid` int(11) NOT NULL,
  `title` varchar(1000) NOT NULL,
  `slug` varchar(1000) NOT NULL,
  `url` varchar(1000) NOT NULL,
  `displayurl` varchar(1000) NOT NULL,
  `datesubmitted` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `subcheck` tinyint(1) NOT NULL,
  PRIMARY KEY  (`submissionid`)
)

Originally asked by: John on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/arabic-being-displayed-in-giberish-and-question-marks-1/ http://www.globberstack.com/Questions/arabic-being-displayed-in-giberish-and-question-marks-1/ Wed, 08 Sep 2010 09:44:49 -0400 topdog Questions http://www.globberstack.com/Questions/arabic-being-displayed-in-giberish-and-question-marks-1/

Hey,
I created a php website that would simply load the text from a mysql database, when I open it in a browser the Arabic text is presented in gibberish but then when I change the encoding of my browser to UTF-8 it's displayed properly, how can I force the encoding to be UTF-8 so users don't have to change it?

The menu part of the website which also loads the menu items from the same database (different table, they both have the same coalition "utf8_unicode_ci") but they are all displayed as question marks. How can I fix this?

You can check out the website on test.bdsfilmfest.com

Thank you in advance :)

Originally asked by: yousefcisco on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/any-good-finance-api-1/ http://www.globberstack.com/Questions/any-good-finance-api-1/ Wed, 08 Sep 2010 09:44:09 -0400 topdog Questions http://www.globberstack.com/Questions/any-good-finance-api-1/

Yahoo! Finance feeds are pain in the ass.

Google Finance API seems OK but don't know why I can't retrieve stock quotes information for Dow Johnes, NASDAQ, S&P...

Works perfect with company quotes like YHOO, MSFT but don't gets full data for stock indexes.

There is an article at YQL blog on how to get this data from Open tables with YQL, but that table is missing in the list.

Can anybody recommend any good API, web service or a feed?

Best answer + vote up guaranteed.

Originally asked by: Otar on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/utf-8-encoding-problem-with-xslt-via-php-1/ http://www.globberstack.com/Questions/utf-8-encoding-problem-with-xslt-via-php-1/ Wed, 08 Sep 2010 09:36:27 -0400 topdog Questions http://www.globberstack.com/Questions/utf-8-encoding-problem-with-xslt-via-php-1/

Hi all,

I'm facing a nasty encoding issue when transforming XML via XSLT through PHP.

The problem can be summarised/dumbed down as follows: when I copy a (UTF-8 encoded) XHTML file with an XSLT stylesheet, some characters are displayed wrong. When I just show the same XHTML file, all characters come out correctly.

Following files illustrate the problem:

XHTML

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
        <title>encoding test</title>
    </head>
    <body>
        <p>This is how we d&#239;&#223;&#960;&#955;&#509; &#145;special characters&#146;</p>
    </body>
</html>

XSLT

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    version="1.0">

    <xsl:output method="xml" encoding="UTF-8"/>

    <xsl:template match="@*|node()">
        <xsl:copy>
            <xsl:apply-templates select="@*|node()"/>
        </xsl:copy>
    </xsl:template>

</xsl:stylesheet>

PHP

<?php
  $xml_file = 'encoding_test.xml';
  $xsl_file = 'encoding_test.xsl';

  $xml_doc = new DOMDocument('1.0', 'utf-8');
  $xml_doc->load($xml_file);

  $xsl_doc = new DOMDocument('1.0', 'utf-8');
  $xsl_doc->load($xsl_file);

  $xp = new XsltProcessor();
  $xp->importStylesheet($xsl_doc);

  // alllow to bypass XSLT transformation with bypass=true request parameter
  if ($bypass = $_GET['bypass']) {
    echo file_get_contents($xml_file);
  }
  else {
    echo $xp->transformToXML($xml_doc);
  }
?>

When this script is invoked as such (via e.g. http://localhost/encoding_test/encoding_test.php), all characters in the transformed XHTML document come out ok, except for the ‘ and ’ character entities (they're opening and closing single quotation marks). I'm not a Unicode expert, but two things strike me:

1. all other character entities are interpreted correctly (which could imply something about the UTF-8-ness of ‘ and ’)


2. yet, when the XHTML file is displayed unmediated (via e.g. http://localhost/encoding_test/encoding_test.php?bypass=true), all characters are displayed properly.

I think I've declared UTF-8 encoding for the output anywhere I could. Do others perhaps see what's wrong and can be righted?

Thanks in advance!

Ron Van den Branden

Originally asked by: rvdb on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/mysql-fails-to-start-and-i-cant-see-why-1/ http://www.globberstack.com/Questions/mysql-fails-to-start-and-i-cant-see-why-1/ Wed, 08 Sep 2010 09:35:03 -0400 topdog Questions http://www.globberstack.com/Questions/mysql-fails-to-start-and-i-cant-see-why-1/

Hi all. After a reboot, mysql is failing to start. Before i rebooted i was fooling around with the /etc/mysql/my.cnf file, trying to change my default character encoding from utf-8 to latin1. As far as i can tell, i've undone my changes (thinking they were probably the result of it failing to start) but i'm not sure as i didn't make a backup (stupidly).

How can i see why mysql is failing to start? I thought it would output something to /var/log/mysql.err or /var/log/mysql.log but there's nothing at all in either of those files. Is there some other file that might be logging the problem, or can i perhaps start it in a verbose/trace mode that would output the problem? I'm looking at the man file now but can't see anything helpful (though i may be looking at the wrong man file).

thanks - max

Here's the contents of my /etc/mysql/my.cnf file as it stands now, hopefully someone can spot something obviously wrong:

#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
# 
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port        = 3306
socket      = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket      = /var/run/mysqld/mysqld.sock
nice        = 0

[mysqld]
#
# * Basic Settings
#

#
# * IMPORTANT
#   If you make changes to these settings and your system uses apparmor, you may
#   also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
#

user        = mysql
pid-file    = /var/run/mysqld/mysqld.pid
socket      = /var/run/mysqld/mysqld.sock
port        = 3306
basedir     = /usr
datadir     = /var/lib/mysql
tmpdir      = /tmp
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address        = 127.0.0.1
#
# * Fine Tuning
#
key_buffer      = 16M
max_allowed_packet  = 16M
thread_stack        = 192K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover         = BACKUP
#max_connections        = 100
#table_cache            = 64
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit   = 1M
query_cache_size        = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file        = /var/log/mysql/mysql.log
#general_log             = 1
#
# Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
#
# Here you can see queries with especially long duration
#log_slow_queries   = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
#server-id      = 1
#log_bin            = /var/log/mysql/mysql-bin.log
expire_logs_days    = 10
max_binlog_size         = 100M
#binlog_do_db       = include_database_name
#binlog_ignore_db   = include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem

#CHANGES

[client]
#default-character-set=latin1

[mysql]
#default-character-set=latin1

[mysqld]
#default-character-set = latin1
#skip-character-set-client-handshake
#collation-server = utf8_unicode_ci
#init-connect='SET NAMES latin1'
#character-set-server = latin1

#/CHANGES


[mysqldump]
quick
quote-names
max_allowed_packet  = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer      = 16M

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/

Originally asked by: Max Williams on Stack Overflow

0 Vote(s) ]]> http://www.globberstack.com/Questions/need-to-fix-a-website-that-uses-border-spacing-1/ http://www.globberstack.com/Questions/need-to-fix-a-website-that-uses-border-spacing-1/ Wed, 08 Sep 2010 09:35:01 -0400 topdog Questions http://www.globberstack.com/Questions/need-to-fix-a-website-that-uses-border-spacing-1/
Any help is appreciated.

Thanks

0 Vote(s) ]]> http://www.globberstack.com/Questions/upload-images-using-a-folder-in-php-1/ http://www.globberstack.com/Questions/upload-images-using-a-folder-in-php-1/ Wed, 08 Sep 2010 09:34:28 -0400 topdog Questions http://www.globberstack.com/Questions/upload-images-using-a-folder-in-php-1/

Hi,

I have a folder with full of images.But I have to upload the images to mysql database.

How can I do it using php code?

Regards,

Rekha

Originally asked by: rekhasathvika on Stack Overflow

0 Vote(s) ]]>