i was looking for an events' calendar whereby we can get a calendar and each date will have an option to add an event corresponding to that date. can i get that using some simple javascript.. i need to get that implemented using php... dont know how else to explain this ??

I just want to tell you that I am newbie to OOP and it is quite hard to me, but here is my code:

class functions
{
    function safe_query($string)
    {
    $string = mysql_escape_string(htmlspecialchars($string));
    return $string;
    }  
}

class info
{
    public $text; 

    function infos($value)
    {
    echo functions::safe_query($value);
    }
}

Is there any way to make this sentence : echo functions::safe_query($value); prettier? I can use extends, than I could write echo $this->safe_query($value);, but is it a best way? Thank you.

edit: and maybe I even can to not use class functions and just make separate file of functions and include that?

How to change background color for last render row in while loop ....

that is

row1
row2
**row3**

If row4 is added then it should

row1
row2
row3
**row4**

that is star represents some bgcolor red...

On Linux-based shared hosting that is administered with cpanel, is there a programmatic way to create, sort of reliably, addon domains for my site if I know my cpanel login information and/or FTP information?

Note: interested in PHP and cpanel in this case.

I am getting the following exception while trying to save some Tweets,

Caused by: java.sql.SQLException: Incorrect string value: '\xF3\xBE\x8D\x81' for column 'twtText' at row 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)
at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:94)
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:57)

My table structure is given below, all the columns are in UTF-8 format,

 CREATE TABLE `tblkeywordtracking` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `word` varchar(200) NOT NULL,
  `tweetId` bigint(100) NOT NULL,
  `twtText` varchar(800) DEFAULT NULL,
  `negTwtText` varchar(1000) DEFAULT NULL,
  `language` text,
  `links` text,
  `negWt` double DEFAULT NULL,
  `posWt` double DEFAULT NULL,
  `tweetType` varchar(20) DEFAULT NULL,
  `source` text,
  `sourceStripped` text,
  `isTruncated` varchar(40) CHARACTER SET latin1 DEFAULT NULL,
  `inReplyToStatusId` bigint(30) DEFAULT NULL,
  `inReplyToUserId` int(11) DEFAULT NULL,
  `isFavorited` varchar(40) CHARACTER SET latin1 DEFAULT NULL,
  `inReplyToScreenName` varchar(40) DEFAULT NULL,
  `latitude` bigint(100) NOT NULL,
  `longitude` bigint(100) NOT NULL,
  `retweetedStatus` varchar(40) CHARACTER SET latin1 DEFAULT NULL,
  `statusInReplyToStatusId` bigint(100) NOT NULL,
  `statusInReplyToUserId` bigint(100) NOT NULL,
  `statusFavorited` varchar(40) CHARACTER SET latin1 DEFAULT NULL,
  `statusInReplyToScreenName` text,
  `screenName` text,
  `profilePicUrl` text,
  `twitterId` bigint(100) NOT NULL,
  `name` text,
  `location` text,
  `bio` text,
  `utcOffset` int(11) DEFAULT NULL,
  `timeZone` varchar(100) DEFAULT NULL,
  `frenCnt` bigint(20) DEFAULT '0',
  `createdAt` datetime DEFAULT NULL,
  `createdOnGMT` text CHARACTER SET latin1,
  `createdOnServerTime` datetime DEFAULT NULL,
  `follCnt` bigint(20) DEFAULT '0',
  `favCnt` bigint(20) DEFAULT '0',
  `totStatusCnt` bigint(20) DEFAULT NULL,
  `usrCrtDate` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`,`word`),
  KEY `twtText` (`twtText`(333)),
  KEY `word` (`word`,`tweetType`),
  KEY `posWt` (`posWt`,`negWt`)
) ENGINE=MyISAM AUTO_INCREMENT=1740 DEFAULT CHARSET=utf8;

I ve installed MySQL (last update).
I need to code, that ll create & establish a connection with SQL DB
& manage the DB(using SELECT, INSERT, CREATE).

I did everything but, i am not able to create connection..(i ve also installed the MySQL/J connector, i jus extracted the .zip pack in a folder & added the folder path in Variables)

Can any1 tell me wat is mean by URL in the below line....

Connection connection = DriverManager.getConnection(url, username, password);

I ve tried this "String url = "jdbc:odbc:sqlserver://localhost:3306/myfirstdb"; "
for "Connection con = DriverManager.getConnection(url, "root", "1234");"

But its not working... I cant able to understand the term 'URL'...
Can anyone explain, the meaning of 'url' and wat should be done to connect to a SQL server from Java.

Thanks

Hello ALL,

I have following table structure

table_country ==> country_id (PK) | country | status
table_department ==> department_id (PK) | department | country_id (FK)
table_province ==> province_id (PK) | province | department_id (FK)
table_district ==> district_id (PK) | district | province_id (FK)

NOTE: all tables engine  are innoDB

One country can have multiple department, one department can have multiple provine and one province can have multiple district. Now i need to search only those country which have atleast one district

i write below 2 SQL quries, in my case, both query give same results....please describe me the difference between below queries and suggest me to use optimized query

USING RIGHT JOIN

SELECT c.country_id as id, c.country as name 
FROM table_country c 
RIGHT JOIN table_department d ON d.country_id=c.country_id 
RIGHT JOIN  table_province p ON p.department_id=d.department_id 
RIGHT JOIN table_district ds ON ds.province_id=p.province_id 
WHERE   c.status='Active' GROUP BY (c.country_id)

USING INNER JOIN and HAVING Clause

SELECT COUNT(ds.district),c.country_id as id, c.country as name 
FROM table_country c 
INNER JOIN table_department d ON d.country_id=c.country_id 
INNER JOIN table_province p ON p.department_id=d.department_id 
INNER JOIN table_district ds ON ds.province_id=p.province_id 
WHERE c.status='Active' GROUP BY (c.country_id)  
HAVING  COUNT(ds.district)>0

please tell me where these both query make the difference in results and which one i have to use or i have to use different query.

Thanks in Advance

There is a program I would like to understand a bit more of, but most of it is in ASM. MatrixMultiply

The reference page is here.

I understand C++, but the ASM part is a bit vague. Can someone explain?

I have quite a long data mining script, and in parts of it I echo some information to the page (during a foreach loop, actually.)

However I am noticing that the information is being sent to the browse not immediately as I had hoped, but in 'segments'.

Is there some function I can use after my echo to send all the data to the browser immediately?

Thanks.

Hey all,

I am using the foreach function to get all the categories for a WordPress site and need a way to adjust the output if there is another tag, to include dynamic CSS.

Basically, if I have only one tag I need the code output to look like this:

.category-wordpress #wordpress { background: #FFFFFF; color: #232323; text-decoration: none; }

and if there's more than one tag like this:

.category-wordpress #wordpress, .category-html #html { background: #FFFFFF; color: #232323; text-decoration: none; }

The problem is with the comma between declarations. How can I change this code so a comma is only included if there is another category to include?

if (is_category()) { 

$css_cats = "<style type='text/css'>";

 //get all blog categories
 $categories = get_categories('title_li=&orderby=name&hide_empty=0');

 if ($categories) {

  foreach($categories as $category) {

   $css_cats .= ".category-".$category->category_nicename." #".$category->category_nicename.", ";

  }

 } 

$css_cats .= "{ background: #FFFFFF; color: #232323; text-decoration: none; }";

$css_cats .= "</style>";

echo $css_cats;

}

This code is outputting a comma at the end of the last declaration like this:

.category-wordpress #wordpress, .category-html #html, { background: #FFFFFF; color: #232323; text-decoration: none; }

so the CSS breaks.

I can change the code so it outputs the CSS declarations individually like this:

.category-wordpress #wordpress { background: #FFFFFF; color: #232323; text-decoration: none; }
.category-html #html { background: #FFFFFF; color: #232323; text-decoration: none; }

but surely there's a better way?

Any help is greatly appreciated.

Cheers,

James

Is it even possible? I am implementing an export to pdf functionality for a pile of data, one of which is a Google map with a marker.

Thank you.

how do i convert a json object to a string

i want to insert a json object to a mysql DB

I'm writing an OS X client for a software that is written in PHP. This software uses a simple RPC interface to receive and execute commands. The RPC client has to sign the commands he sends to ensure that no MITM can modify any of them.

However, as the server was not accepting the signatures I sent from my OS X client, I started investigating and found out that PHP's openssl_sign function generates a different signature for a given private key/data combination than the Objective-C SSCrypto framework (which is only a wrapper for the openssl lib):

SSCrypto *crypto = [[SSCrypto alloc] initWithPrivateKey:self.localPrivKey];
NSData *shaed = [self sha1:@"hello"];
[crypto setClearTextWithData:shaed];
NSData *data = [crypto sign];

generates a signature like CtbkSxvqNZ+mAN...

The PHP code

openssl_sign("hello", $signature, $privateKey);

generates a signature like 6u0d2qjFiMbZ+...
(For my certain key, of course. base64 encoded)

I'm not quite shure why this is happening and I unsuccessfully experimented with different hash-algorithms. As the PHP documentation states SHA1 is used by default.

So why do these two functions generate different signatures and how can I get my Objective-C part to generate a signature that PHPs openssl_verify will accept?

Note: I double checked that the keys and the data is correct!

Hi!

This was my first project in Java, started just for fun and to learn some advanced gui/jdbc programming.

It is a GUI browser for MySQL databases, but I implemented a mysql-console-like interface for cmd lovers.
I planned to improve it by allowing the users to create/modify the existing databases/tables.
Because I'm the only developer of this project, it takes a lot of time to implement such things.

Does it worth to improve this project and to continue with my plans?
What do you think?

I completed my install on Leopard with Mac Ports. I also installed Mysqld via Mac Ports for use with python. I set the password for mysql on mysql start. Everything seemed to be fine except when I invoke mysql-start from the command line now I get this: mysql-start
***Password:
Starting MySQL
. SUCCESS!
demetrius-fords-macbook-pro-17:~ demet8$

I also get a system que stating:Do you want mysqld to accepting incoming notifications.....

So I kinda think I am activating mysqld, not the actual mysql command interpreter. I can use mysql-stop with no problem to shut the server down. Lastly in the Python interpreter when I run: import MySQLdb I get this:

/opt/local/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site-packages/MySQLdb/_init_.py:34: DeprecationWarning: the sets module is deprecated
from sets import ImmutableSet

I don't think this affects mysqld @ all. I don't have the mysql default socket in my path via bash_login. Do I need to do that? thank you....

How do i compare 2 fields in 2 tables, find a match and use it ?
example:

table1: data1(id_data1,name,address,phone,account)
table2: data2(id_data2,name2)

now in php:
if (name2.table2 has a matching name in name.table1) { give me the address,phone,account }

Dear all

I have database of website link, it list out in main file ,when i try to click that link it get to redirect on that database link.
my code is
test.php

<?php

// getting from database

 echo '<li onclick=\"window.location='.$result->website.'\">
       <a href="#">'.$result->option.'</a></li>';
?>

The Main.html calls that test.php
while ajax

$.post("test.php", {queryString: ""+inputString+""}, function(data){

});

how to do it?
any idea Is it possible with
serverside script? whats wrong with my php code?

Greetings all-

I'm writing a program that parses and cleans a lot of data from one database to another on Matlab, querying from MySQL. This would run continuously, as new data come into the first db every minute, are cleaned, and put to the clean db before the next data point comes in. I was wondering how, during this process, I could account for two things...

1. Every three nights MySQL is shutdown for backup. I'd like my program to pause when this happens, and resume when its back up. I've looked around for a solution, and can't seem to find one for this.




2. Allow a user to kill the program. I've narrowed this down to either accounting for a ctrl+c kill, or creating a GUI to do it. Which do you all think would be the better strategy?

Thanks in advance for your time and help on this matter.

I've been working with PHP code that generates HTML without any templating, and it's quite spaghetti and difficult to read with the way they've structured it. One way to drastically improve following the flow I've noticed is to use : endif instead of { } blocks in some cases to increase readability. (See http://php.net/manual/en/control-structures.alternative-syntax.php)

• Is this portable?


• Is this standard?


• Is this slower in any significant way (I understand it takes more chars)

Cheers!

i hava a class that hold a list for each request
but each request the list is empty again
what can i do to make it live

here is my class , i want the list to hold values from previews requests
(yes each request i'm settings a value there )

class Sessions{
    private static $list     = array();
    ....
    .....
}

I have turkish character problem in mysql database when adding content with tinymce from admin panel.

Charset is:

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-9"" />

How can I solve this?
Thanks in advance

Table has 1 500 000 records, 1 250 000 of them have field = 'z'.

I need select random not 'z' field.

$random = mt_rand(1, 250000);  
$query = "SELECT field FROM table WHERE field != 'z' LIMIT $random, 1";

It is working ok.

Then I decided to optimize it and indexed field in table.

Result was strange - it was slower ~3 times. I tested it.

Why it is slower? Is not such indexing should make it faster?

my ISAM

explain with index:  
id  select_type  table  type  possible_keys  key   key_len  ref  rows     Extra  
1   SIMPLE       table  range field          field 758      NULL 1139287  Using  

explain without index:  
id  select_type  table  type  possible_keys  key  key_len  ref  rows     Extra  
1   SIMPLE       table  ALL   NULL           NULL NULL     NULL 1484672  Using where

Hi,

I have mysql 5.1 set up and running.

I need to connect to:

location: comm.eng.bxg.com

name: amntxy

user: username

pswd: password

I have tried using

mysql -h amntxy -u username -p

Also tried: use amntxy and use comm.eng.bxg.com/amntxy

But I am unable to connect.

I get the following error:

ERROR 2005 (HY000): Unknown MySQL server host

I also tried mysql_connect but keep getting the error : mysql_connect is not recognized as internal or external command

But I do not understand hwo I can connect here.

Please help.

Thank you

When submitting a message in my site-wide contact form in Drupal 6.x I get the following message along the top of every message:

[Name] sent a message using the contact form at [www.mysite.com/contact]

I would like to remove this message. Looking around, I've found it comes from the contact.module here:

$message['body'][] = t("!name sent a message using the contact form at !form.", array('!name' => $params['name'], '!form' => url($_GET['q'], array('absolute' => TRUE, 'language' => $language))), $language->language);

I've done a bit of research and it seems that I need to create a custom module with a hook_mail_alter() function to edit the contact.module. When it comes to this I get a bit lost. Could anyone kindly take me through the steps to accomplish the task?

Many thanks.

Hi everyone,

I have a Site object but I can't figure out how best to store a collection of Page objects on Site. The pages are hierarchical (a tree structure for a website navigation). I thought about a tree-like array of pages but that would be a pain to interact with - e.g. $site->pages[0][3][1]->addContent('<h1>lol</h1>'). I could use a flat array of pages with unique IDs like $site->pages['home']->addContent('<p>easier</p>') but how would I extract a tree from that when it came to rendering navigation?

Can anyone help guide me in the right direction please?

Thanks!

I am toying with RMySQL and trying to import a testing database using the following code:

dbSendQuery(db, statement = "LOAD DATA LOCAL INFILE '~/R/survey/pet.csv' INTO TABLE pet 
                              FIELDS TERMINATED BY '\t' 
                                     ENCLOSED BY '@'
                              IGNORE 1 LINES")

My Question is:

You can see I am using '@' for enclosing each piece of data (i.e. @hello@, @hi@ will be 2 pieces of data), I try to use paste() or cat() to replace the '@' with '"' but fails.

Most of the spreadsheet software quote the cells using '"', how can I use the '"' character when writing statement for RMySQL?

Thanks!

I set up Mysql5, mysql5-server and py26-mysql using Macports. I then started the mysql server and was able to start the prompt with mysql5

In my settings.py i changed database_engine to "mysql" and put "dev.db" in database_name.

I left the username and password blank as the database doesnt exist yet.

When I ran python manage.py syncdb, django raised an error

'django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: dynamic module does not define init function (init_mysql)`

How do I fix this? Do I have to create the database first? is it something else?

When I insert some text written in unicode into database, they become question marks. Database encoding is set to utf-8. What else may be incorrect? When I check in phpmyadmin there are question marks inserted only!

This is the code I use for connecting to database:

define ("DB_HOST", "localhost"); // set database host
define ("DB_USER", "root"); // set database user
define ("DB_PASS","password"); // set database password
define ("DB_NAME","name"); // set database name

$link = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die("Couldn't make connection.");
$db = mysql_select_db(DB_NAME, $link) or die("Couldn't select database");

mysql_set_charset('utf8',$link); 
mysql_query("SET CHARACTER SET utf8");

i have a table data like this

(int)   (time)  [mySQL datatype]

Id     Duration 

1      00:10:00

2      10:10:00

3      03:00:00

4      04:13:00

i want to calculate the total duration from this table, how can we do it. like 17:33:00.
Could anybody please provide mysql query to calculate this.

Question1:

MySQL table

id | array

1 | 1,2,3

2 | 2

3 | 2,3

4 | 4,5,6

$_GET['id'] = 2;
$a = mysql_query("SELECT * FROM `table` WHERE `array` ??? '$_GET[id]'");

In this step, I want to run through the entire array and see if it matches with the $_GET['id'], so it should output:

ids: 1,2,3

Question2:

MySQL table

id | array

1 | 4,5,6

2 | 3,4,7

$_GET['id'] = 4;
$a = mysql_query("SELECT * FROM `table` WHERE `array` ??? '$_GET[id]'");

In this step, I only want to match against the first element in the array, so it should output:

id: 4

I can only think of using PHP to do this, but I'd rather do all that just within the MySQL query, if that is even possible.

$a = mysql_query("SELECT * FROM `table`");
while($b = mysql_fetch_assoc($a))
{
    $elements = explode(',', $b['array']);
    foreach($elements as $element)
    {
        if($element == $_GET['id'])
        {
            echo $b['id'].'<br />';
        }
    }
}

or

$a = mysql_query("SELECT * FROM `table`");
while($b = mysql_fetch_assoc($a))
{
    $array = $b['array'];

    if(in_array($_GET['id'], $array))
    {
        echo $b['id'].'<br />';
    }
}

that would look just awful.

Hello all,
I have added a 404 page and included the following in the .htaccess

ErrorDocument 404 http://www.game-plan.net/404.php

For some reason I'm not aware of, when i process forms, it doesnt want to do that, it wants to redirect to a 404 page.

Is this anything common?
Something I dont know that maybe someone has come across before?
Thanks

Code sample -

<form action='process.php' method='POST'>
            <select name='game'>
            <?php

            $q = $database->allGame();
            while($row=mysql_fetch_assoc($q))
            {
                $u=$row['name'];
                echo "<option value=\"$u\">$u</option>";
            }
            ?>
            </select>
            <input type='hidden' name='type' value='1' />
            <input type='hidden' name='joinrank' />
            <input type='submit' value='Proceed' />
            </form>

how to get a class constructor function name without instantiating the class?

example:

$class = 'someClass';
$constructor = somehow get constructor;

$args = array();
$object = call_user_func_array(array($class,$constructor),$args);

what I need is to create a object by passing a undetermined number of variables into it's constructor.