Best way to plan a database before designing
What are the disadvantages to have more number of columns in a table and
more number of rows in a table? in My sql...
I am talking about 292 columns in a single table. and 36 more like them in
a single database.
My website's front end is PHP and Back End is Mysql.
`id` int(11) NOT NULL AUTO_INCREMENT,
username varchar(55) NOT NULL, rollno varchar(15) NOT NULL, jan_tc_s1
varchar(5) DEFAULT NULL, jan_ac_s1 varchar(5) DEFAULT NULL, jan_s1_perce
varchar(5) DEFAULT NULL, feb_tc_s1 varchar(5) DEFAULT NULL, feb_ac_s1
varchar(5) DEFAULT NULL, feb_s1_perce varchar(5) DEFAULT NULL, mar_tc_s1
varchar(5) DEFAULT NULL, mar_ac_s1 varchar(5) DEFAULT NULL, mar_s1_perce
varchar(5) DEFAULT NULL, apr_tc_s1 varchar(5) DEFAULT NULL, apr_ac_s1
varchar(5) DEFAULT NULL, apr_s1_perce varchar(5) DEFAULT NULL, may_tc_s1
varchar(5) DEFAULT NULL, may_ac_s1 varchar(5) DEFAULT NULL, may_s1_perce
varchar(5) DEFAULT NULL, jun_tc_s1 varchar(5) DEFAULT NULL, jun_ac_s1
varchar(5) DEFAULT NULL, jun_s1_perce varchar(5) DEFAULT NULL, dec_tc_s1
varchar(5) DEFAULT NULL, dec_ac_s1 varchar(5) DEFAULT NULL, dec_s1_perce
varchar(5) DEFAULT NULL, s1_ia_att varchar(5) DEFAULT NULL, s1_t1
varchar(5) DEFAULT NULL, s1_t2 varchar(5) DEFAULT NULL, s1_t3 varchar(5)
DEFAULT NULL, s1_ia_tot varchar(5) DEFAULT NULL, jan_tc_s2 varchar(5)
DEFAULT NULL, jan_ac_s2 varchar(5) DEFAULT NULL, jan_s2_perce varchar(5)
DEFAULT NULL, feb_tc_s2 varchar(5) DEFAULT NULL, feb_ac_s2 varchar(5)
DEFAULT NULL, feb_s2_perce varchar(5) DEFAULT NULL, mar_tc_s2 varchar(5)
DEFAULT NULL, mar_ac_s2 varchar(5) DEFAULT NULL, mar_s2_perce varchar(5)
DEFAULT NULL, apr_tc_s2 varchar(5) DEFAULT NULL, apr_ac_s2 varchar(5)
DEFAULT NULL, apr_s2_perce varchar(5) DEFAULT NULL, may_tc_s2 varchar(5)
DEFAULT NULL, may_ac_s2 varchar(5) DEFAULT NULL, may_s2_perce varchar(5)
DEFAULT NULL, jun_tc_s2 varchar(5) DEFAULT NULL, jun_ac_s2 varchar(5)
DEFAULT NULL, jun_s2_perce varchar(5) DEFAULT NULL, dec_tc_s2 varchar(5)
DEFAULT NULL, dec_ac_s2 varchar(5) DEFAULT NULL, dec_s2_perce varchar(5)
DEFAULT NULL, s2_ia_att varchar(5) DEFAULT NULL, s2_t1 varchar(5) DEFAULT
NULL, s2_t2 varchar(5) DEFAULT NULL, s2_t3 varchar(5) DEFAULT NULL,
s2_ia_tot varchar(5) DEFAULT NULL, jan_tc_s3 varchar(5) DEFAULT NULL,
jan_ac_s3 varchar(5) DEFAULT NULL, jan_s3_perce varchar(5) DEFAULT NULL,
feb_tc_s3 varchar(5) DEFAULT NULL, feb_ac_s3 varchar(5) DEFAULT NULL,
feb_s3_perce varchar(5) DEFAULT NULL, mar_tc_s3 varchar(5) DEFAULT NULL,
mar_ac_s3 varchar(5) DEFAULT NULL, mar_s3_perce varchar(5) DEFAULT NULL,
apr_tc_s3 varchar(5) DEFAULT NULL, apr_ac_s3 varchar(5) DEFAULT NULL,
apr_s3_perce varchar(5) DEFAULT NULL, may_tc_s3 varchar(5) DEFAULT NULL,
may_ac_s3 varchar(5) DEFAULT NULL, may_s3_perce varchar(5) DEFAULT NULL,
jun_tc_s3 varchar(5) DEFAULT NULL, jun_ac_s3 varchar(5) DEFAULT NULL,
jun_s3_perce varchar(5) DEFAULT NULL, dec_tc_s3 varchar(5) DEFAULT NULL,
dec_ac_s3 varchar(5) DEFAULT NULL, dec_s3_perce varchar(5) DEFAULT NULL,
s3_ia_att varchar(5) DEFAULT NULL, s3_t1 varchar(5) DEFAULT NULL, s3_t2
varchar(5) DEFAULT NULL, s3_t3 varchar(5) DEFAULT NULL, s3_ia_tot
varchar(5) DEFAULT NULL, jan_tc_s4 varchar(5) DEFAULT NULL, jan_ac_s4
varchar(5) DEFAULT NULL, jan_s4_perce varchar(5) DEFAULT NULL, feb_tc_s4
varchar(5) DEFAULT NULL, feb_ac_s4 varchar(5) DEFAULT NULL, feb_s4_perce
varchar(5) DEFAULT NULL, mar_tc_s4 varchar(5) DEFAULT NULL, mar_ac_s4
varchar(5) DEFAULT NULL, mar_s4_perce varchar(5) DEFAULT NULL, apr_tc_s4
varchar(5) DEFAULT NULL, apr_ac_s4 varchar(5) DEFAULT NULL, apr_s4_perce
varchar(5) DEFAULT NULL, may_tc_s4 varchar(5) DEFAULT NULL, may_ac_s4
varchar(5) DEFAULT NULL, may_s4_perce varchar(5) DEFAULT NULL, jun_tc_s4
varchar(5) DEFAULT NULL, jun_ac_s4 varchar(5) DEFAULT NULL, jun_s4_perce
varchar(5) DEFAULT NULL, dec_tc_s4 varchar(5) DEFAULT NULL, dec_ac_s4
varchar(5) DEFAULT NULL, dec_s4_perce varchar(5) DEFAULT NULL, s4_ia_att
varchar(5) DEFAULT NULL, s4_t1 varchar(5) DEFAULT NULL, s4_t2 varchar(5)
DEFAULT NULL, s4_t3 varchar(5) DEFAULT NULL, s4_ia_tot varchar(5) DEFAULT
NULL, jan_tc_s5 varchar(5) DEFAULT NULL, jan_ac_s5 varchar(5) DEFAULT
NULL, jan_s5_perce varchar(5) DEFAULT NULL, feb_tc_s5 varchar(5) DEFAULT
NULL, feb_ac_s5 varchar(5) DEFAULT NULL, feb_s5_perce varchar(5) DEFAULT
NULL, mar_tc_s5 varchar(5) DEFAULT NULL, mar_ac_s5 varchar(5) DEFAULT
NULL, mar_s5_perce varchar(5) DEFAULT NULL, apr_tc_s5 varchar(5) DEFAULT
NULL, apr_ac_s5 varchar(5) DEFAULT NULL, apr_s5_perce varchar(5) DEFAULT
NULL, may_tc_s5 varchar(5) DEFAULT NULL, may_ac_s5 varchar(5) DEFAULT
NULL, may_s5_perce varchar(5) DEFAULT NULL, jun_tc_s5 varchar(5) DEFAULT
NULL, jun_ac_s5 varchar(5) DEFAULT NULL, jun_s5_perce varchar(5) DEFAULT
NULL, dec_tc_s5 varchar(5) DEFAULT NULL, dec_ac_s5 varchar(5) DEFAULT
NULL, dec_s5_perce varchar(5) DEFAULT NULL, s5_ia_att varchar(5) DEFAULT
NULL, s5_t1 varchar(5) DEFAULT NULL, s5_t2 varchar(5) DEFAULT NULL,
s5_ia_tot varchar(5) DEFAULT NULL, jan_tc_s6 varchar(5) DEFAULT NULL,
jan_ac_s6 varchar(5) DEFAULT NULL, jan_s6_perce varchar(5) DEFAULT NULL,
feb_tc_s6 varchar(5) DEFAULT NULL, feb_ac_s6 varchar(5) DEFAULT NULL,
feb_s6_perce varchar(5) DEFAULT NULL, mar_tc_s6 varchar(5) DEFAULT NULL,
mar_ac_s6 varchar(5) DEFAULT NULL, mar_s6_perce varchar(5) DEFAULT NULL,
apr_tc_s6 varchar(5) DEFAULT NULL, apr_ac_s6 varchar(5) DEFAULT NULL,
apr_s6_perce varchar(5) DEFAULT NULL, may_tc_s6 varchar(5) DEFAULT NULL,
may_ac_s6 varchar(5) DEFAULT NULL, may_s6_perce varchar(5) DEFAULT NULL,
jun_tc_s6 varchar(5) DEFAULT NULL, jun_ac_s6 varchar(5) DEFAULT NULL,
jun_s6_perce varchar(5) DEFAULT NULL, dec_tc_s6 varchar(5) DEFAULT NULL,
dec_ac_s6 varchar(5) DEFAULT NULL, dec_s6_perce varchar(5) DEFAULT NULL,
s6_ia_att varchar(5) DEFAULT NULL, s6_t1 varchar(5) DEFAULT NULL, s6_t2
varchar(5) DEFAULT NULL, s6_ia_tot varchar(5) DEFAULT NULL, jan_tc_s7
varchar(5) DEFAULT NULL, jan_ac_s7 varchar(5) DEFAULT NULL, jan_s7_perce
varchar(5) DEFAULT NULL, feb_tc_s7 varchar(5) DEFAULT NULL, feb_ac_s7
varchar(5) DEFAULT NULL, feb_s7_perce varchar(5) DEFAULT NULL, mar_tc_s7
varchar(5) DEFAULT NULL, mar_ac_s7 varchar(5) DEFAULT NULL, mar_s7_perce
varchar(5) DEFAULT NULL, apr_tc_s7 varchar(5) DEFAULT NULL, apr_ac_s7
varchar(5) DEFAULT NULL, apr_s7_perce varchar(5) DEFAULT NULL, may_tc_s7
varchar(5) DEFAULT NULL, may_ac_s7 varchar(5) DEFAULT NULL, may_s7_perce
varchar(5) DEFAULT NULL, jun_tc_s7 varchar(5) DEFAULT NULL, jun_ac_s7
varchar(5) DEFAULT NULL, jun_s7_perce varchar(5) DEFAULT NULL, dec_tc_s7
varchar(5) DEFAULT NULL, dec_ac_s7 varchar(5) DEFAULT NULL, dec_s7_perce
varchar(5) DEFAULT NULL, s7_ia_att varchar(5) DEFAULT NULL, s7_t1
varchar(5) DEFAULT NULL, s7_t2 varchar(5) DEFAULT NULL, s7_ia_tot
varchar(5) DEFAULT NULL,
Friday, 13 September 2013
Undefined index: myusername in C:\wamp\www\login\login\index.php on line 15 Call Stack
Undefined index: myusername in C:\wamp\www\login\login\index.php on line
15 Call Stack
in my login page it appears error in my log in page how to fix this thanks
Undefined index: myusername in C:\wamp\www\login\login\index.php on line
15 Call Stack
15 Call Stack
in my login page it appears error in my log in page how to fix this thanks
Undefined index: myusername in C:\wamp\www\login\login\index.php on line
15 Call Stack
reformat existing array to group items together
reformat existing array to group items together
I have the following array:
Array
(
[0] => Array
(
[name] => bss2
[label] => front
[text] => just a testing item
)
[1] => Array
(
[name] => bss3
[label] => front top
[text] => front top testing item
)
[2] => Array
(
[name] => J334
[label] => back top
[text] => masking test back top
)
[3] => Array
(
[name] => J3366
[label] => back
[text] => back non mask test
)
)
What i would like to accomplish is to check to see if label = front then
group the ones with front together and same with back all in one big array
to have it looks like so:
[approval] => Array
(
[0] => Array
(
[name] = front
[prev] = Array
(
[0]=>Array
(
[name] => bss2
)
[1]=>Array
(
[name] => bss2
)
)
)
[1] => Array
(
[name] = back
[prev] = Array
(
[0]=>Array
(
[name] => J334
)
[1]=>Array
(
[name] => J3366
)
)
)
)
so far I dont have much and am stuck but this is my code
foreach($info as $data) {
if(strtolower(strpos($data['label'], "front") !==false)) {
} else {
}
}
Any help is greatly appreciated thank you.
I have the following array:
Array
(
[0] => Array
(
[name] => bss2
[label] => front
[text] => just a testing item
)
[1] => Array
(
[name] => bss3
[label] => front top
[text] => front top testing item
)
[2] => Array
(
[name] => J334
[label] => back top
[text] => masking test back top
)
[3] => Array
(
[name] => J3366
[label] => back
[text] => back non mask test
)
)
What i would like to accomplish is to check to see if label = front then
group the ones with front together and same with back all in one big array
to have it looks like so:
[approval] => Array
(
[0] => Array
(
[name] = front
[prev] = Array
(
[0]=>Array
(
[name] => bss2
)
[1]=>Array
(
[name] => bss2
)
)
)
[1] => Array
(
[name] = back
[prev] = Array
(
[0]=>Array
(
[name] => J334
)
[1]=>Array
(
[name] => J3366
)
)
)
)
so far I dont have much and am stuck but this is my code
foreach($info as $data) {
if(strtolower(strpos($data['label'], "front") !==false)) {
} else {
}
}
Any help is greatly appreciated thank you.
How to list the contents of the variable VAR
How to list the contents of the variable VAR
How to list the contents of the variable VAR
(
VAR="foo";
) &
echo $VAR; # I need to get "foo" ?
thank you very much
How to list the contents of the variable VAR
(
VAR="foo";
) &
echo $VAR; # I need to get "foo" ?
thank you very much
Push Messaging with Amazon SNS, SQS and PHP
Push Messaging with Amazon SNS, SQS and PHP
I want to use Amazon SNS to send time-critical mobile PUSH notifications
to 20 million devices. Each topic can have up to 10,000 devices, and I can
create up to 3,000 topics. Using the Amazon PHP SDK would mean sending
2000 API calls at 1 second each - 33 minutes in total. This is no good for
time-critical messages.
I have created an SQS queue and subscribed that to the SNS topic. When I
send my PUSH message to the SQS queue, it doesn't get delivered - it
remains in the queue.
How can I use these services to send the messages more quickly?
Thank you!
I want to use Amazon SNS to send time-critical mobile PUSH notifications
to 20 million devices. Each topic can have up to 10,000 devices, and I can
create up to 3,000 topics. Using the Amazon PHP SDK would mean sending
2000 API calls at 1 second each - 33 minutes in total. This is no good for
time-critical messages.
I have created an SQS queue and subscribed that to the SNS topic. When I
send my PUSH message to the SQS queue, it doesn't get delivered - it
remains in the queue.
How can I use these services to send the messages more quickly?
Thank you!
Thursday, 12 September 2013
"Redirect url" error in facebook api
"Redirect url" error in facebook api
I am working on facebook api. I want to get all facebook post of a user. I
have set the app_id, secret and permission in my code.
This code is working on my localhost perfectly. but when I am putting it
on server then during authentication it is giving error :
This webpage has a redirect loop
My code is located at the url :
https://github.com/ucerturohti/facebookapitest.git
and the app is located at
https://statusupdates.herokuapp.com
update
When I am putting redirect url "https://statusupdates.herokuapp.com" then
its authenticating.
but when I put redirect url as
"https://statusupdates.herokuapp.com/getlike.php" then it is giving error.
I am working on facebook api. I want to get all facebook post of a user. I
have set the app_id, secret and permission in my code.
This code is working on my localhost perfectly. but when I am putting it
on server then during authentication it is giving error :
This webpage has a redirect loop
My code is located at the url :
https://github.com/ucerturohti/facebookapitest.git
and the app is located at
https://statusupdates.herokuapp.com
update
When I am putting redirect url "https://statusupdates.herokuapp.com" then
its authenticating.
but when I put redirect url as
"https://statusupdates.herokuapp.com/getlike.php" then it is giving error.
Audio is not playing properly in ffmpeg player
Audio is not playing properly in ffmpeg player
I need to create a player which will decrypt the input on-fly and play the
content. I have choosen ffmpeg libs (libav*) to create player and to start
I have followed this link
but audio is not playing properly,video is playing fine. I am using ubuntu
12.04LTS 64bit OS with the following ffmpeg version,
admin@vz-X401A1:~$ ffmpeg ffmpeg version 2.0 Copyright (c) 2000-2013 the
FFmpeg developers built on Sep 11 2013 13:46:26 with gcc 4.6
(Ubuntu/Linaro 4.6.3-1ubuntu5) configuration:
--prefix=/home/admin/ffmpeg_build
--extra-cflags=-I/home/admin/ffmpeg_build/include
--extra-ldflags=-L/home/admin/ffmpeg_build/lib --bindir=/home/admin/bin
--extra-libs=-ldl --enable-gpl --enable-libass --enable-libfdk-aac
--enable-libmp3lame --enable-libopus --enable-libtheora --enable-libvorbis
--enable-libvpx --enable-libx264 --enable-nonfree --enable-x11grab
libavutil 52. 43.100 / 52. 43.100 libavcodec 55. 31.101 / 55. 31.101
libavformat 55. 16.102 / 55. 16.102 libavdevice 55. 3.100 / 55. 3.100
libavfilter 3. 84.100 / 3. 84.100 libswscale 2. 5.100 / 2. 5.100
libswresample 0. 17.103 / 0. 17.103 libpostproc 52. 3.100 / 52. 3.100
Hyper fast Audio and Video encoder usage: ffmpeg [options] [[infile
options] -i infile]... {[outfile options] outfile}...
Use -h to get full help or, even better, run 'man ffmpeg' admin@vz-X401A1:~$
and downloaded tutorial07.c from this link
still, with this also, sound is not playing properly.
I need help to solve the following issues,
1> How can I fix this audio issue(I have gone through similar question in
StackOverflow and installed old ver. of ffmpeg, but issue still remains).
2> And also suggest some steps or tutorial, how to implement on-fly
decryption process (in C) and integrate this with the player.
Thank You.
I need to create a player which will decrypt the input on-fly and play the
content. I have choosen ffmpeg libs (libav*) to create player and to start
I have followed this link
but audio is not playing properly,video is playing fine. I am using ubuntu
12.04LTS 64bit OS with the following ffmpeg version,
admin@vz-X401A1:~$ ffmpeg ffmpeg version 2.0 Copyright (c) 2000-2013 the
FFmpeg developers built on Sep 11 2013 13:46:26 with gcc 4.6
(Ubuntu/Linaro 4.6.3-1ubuntu5) configuration:
--prefix=/home/admin/ffmpeg_build
--extra-cflags=-I/home/admin/ffmpeg_build/include
--extra-ldflags=-L/home/admin/ffmpeg_build/lib --bindir=/home/admin/bin
--extra-libs=-ldl --enable-gpl --enable-libass --enable-libfdk-aac
--enable-libmp3lame --enable-libopus --enable-libtheora --enable-libvorbis
--enable-libvpx --enable-libx264 --enable-nonfree --enable-x11grab
libavutil 52. 43.100 / 52. 43.100 libavcodec 55. 31.101 / 55. 31.101
libavformat 55. 16.102 / 55. 16.102 libavdevice 55. 3.100 / 55. 3.100
libavfilter 3. 84.100 / 3. 84.100 libswscale 2. 5.100 / 2. 5.100
libswresample 0. 17.103 / 0. 17.103 libpostproc 52. 3.100 / 52. 3.100
Hyper fast Audio and Video encoder usage: ffmpeg [options] [[infile
options] -i infile]... {[outfile options] outfile}...
Use -h to get full help or, even better, run 'man ffmpeg' admin@vz-X401A1:~$
and downloaded tutorial07.c from this link
still, with this also, sound is not playing properly.
I need help to solve the following issues,
1> How can I fix this audio issue(I have gone through similar question in
StackOverflow and installed old ver. of ffmpeg, but issue still remains).
2> And also suggest some steps or tutorial, how to implement on-fly
decryption process (in C) and integrate this with the player.
Thank You.
Subscribe to:
Posts (Atom)