PHP Calendar with MYSQL database

In this section you can share self-made extensions with other users of WYSIWYG Web Builder.
There is a dedicated section for commercial extensions.
User avatar
webwoody
 
 
Posts: 53
Joined: Fri Mar 23, 2007 9:22 pm

Post by webwoody »

Eddy,

After a perfect installation security is not working. I did fill in username and password during the installation but when I push a date the extension is not asking it. This means everyone can add events

Can you have a look at http://2stroom.comuf.com/kalender/index.php to check whether I overlook something?

THANKS
User avatar
Eddy
 
 
Posts: 473
Joined: Tue Nov 27, 2007 1:52 am
Location: Nederland.

Post by Eddy »

If you fill in username and password with install than you have to select for all users or only for the admin.

Look to the demo in the first post than you see that it works.
Did you select NO in that box?

Image
User avatar
webwoody
 
 
Posts: 53
Joined: Fri Mar 23, 2007 9:22 pm

Post by webwoody »

Thanks Eddy for your quick response!!

I did a complete new installation and now it's working (Yes, I forgot the NO)

Is it correct that the extention remember (put something in the register?) me when I add a second event?? (it's not asking for username and password. Also after a new startup of IE I can add without security identification)

Regards
User avatar
Eddy
 
 
Posts: 473
Joined: Tue Nov 27, 2007 1:52 am
Location: Nederland.

Post by Eddy »

The calendar downloads a cookie to your pc so far I know.
To delete an event you have to fill in evertime your name and pass.
User avatar
protectourlands
 
 
Posts: 443
Joined: Sat May 24, 2008 2:16 am
Contact:

Post by protectourlands »

Eddy

I'm finding when you select "No" for allowing others to add events, it also does not allow the admin as well. I've reloaded 3 times and still cannot log in to add an event when I check "No" during the install.

Could you test this and see if it works on your server? Anyone else having this problem?
User avatar
protectourlands
 
 
Posts: 443
Joined: Sat May 24, 2008 2:16 am
Contact:

Post by protectourlands »

I tried another database on a different server and it works fine, so it must be the server database settings.

After you log in, you get the empty fields to add an event. When you fill them in and hit "add event", it takes you back to log in instead of adding the event. Log back in and the cycle continues.

Any ideas?
User avatar
Eddy
 
 
Posts: 473
Joined: Tue Nov 27, 2007 1:52 am
Location: Nederland.

Post by Eddy »

In the first post is an live example with admin login.

Do you accept cookie`s ?
I found the same problem here,but I dont know how todo that.

http://www.kubelabs.com/forums/showthre ... t=calendar

Maybe you can find something here.
http://nl.php.net/manual/en/features.sessions.php
User avatar
protectourlands
 
 
Posts: 443
Joined: Sat May 24, 2008 2:16 am
Contact:

Post by protectourlands »

Looks like you found it in the Kubelabs post Eddy. Thank you so much!

......have to define a path for php sessions.

After it tested fine on my server, I knew it was my client's server My SQL setting. Because they set it up I have no idea what to advise them to change or add. I'll send this to them and have them contact their support. Hopefully they will know.

The other issue I have is trying to make the calendar larger. I am using larger images, but the calendar size always uploads the same. Do I have to modify the script to make the calendar larger?
User avatar
Eddy
 
 
Posts: 473
Joined: Tue Nov 27, 2007 1:52 am
Location: Nederland.

Post by Eddy »

I have not tested this but I think you have to change twice the width 700 in the index page,and I think 200 is the width from the cell.


<div align="center"><br>
<table width="700" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="right"><a href="<? echo "index.php?month=$prev_month&year=$prev_year"; ?>"><<</a></div></td>
<td width="200"><div align="center">

<select name="month" id="month" onChange="MM_jumpMenu('parent',this,0)">
<?
for ($i = 1; $i <= 12; $i++) {
$link = $i+1;
IF($_GET['month'] == $link){
$selected = "selected";
} ELSE {
$selected = "";
}
echo "<option value=\"index.php?month=$link&year=$_GET[year]\" $selected>" . date ("F", mktime(0,0,0,$i,1,$_GET['year'])) . "</option>\n";
}
?>
</select>
<select name="year" id="year" onChange="MM_jumpMenu('parent',this,0)">
<?
for ($i = 2008; $i <= 2014; $i++) {
IF($i == $_GET['year']){
$selected = "selected";
} ELSE {
$selected = "";
}
echo "<option value=\"index.php?month=$_GET[month]&year=$i\" $selected>$i</option>\n";
}
?>
</select>
</div></td>
<td><div align="left"><a href="<? echo "index.php?month=$next_month&year=$next_year"; ?>">>></a></div></td>
</tr>
</table>
<br>
</div>
<table width="700" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#C0C0C0">
User avatar
protectourlands
 
 
Posts: 443
Joined: Sat May 24, 2008 2:16 am
Contact:

Post by protectourlands »

That works Eddy. My ftp program has an editor built in so I just changed the 700's to 900's in the index.php. It looks great. Thank you.

Now if it only allowed links in the event description. I sent a note to Kubelabs several days ago but did not get a response. One can hope.
User avatar
Eddy
 
 
Posts: 473
Joined: Tue Nov 27, 2007 1:52 am
Location: Nederland.

Post by Eddy »

I have searchd how to change the php to insert links but no luck.
On the kubelabs forum you get also no responce :?

If I remove the stripslashes than you have in the text slashes ,I think you have to insert for links an extra field in the events form "new event" with the <a href code in the php.
User avatar
protectourlands
 
 
Posts: 443
Joined: Sat May 24, 2008 2:16 am
Contact:

Post by protectourlands »

I agree Eddy. It most likely needs to be added in a new field.

I hope they realize how badly needed this feature is and add it. It's been almost a week and I haven't heard from them. I'll try again.
User avatar
Eddy
 
 
Posts: 473
Joined: Tue Nov 27, 2007 1:52 am
Location: Nederland.

Post by Eddy »

I dont think that they insert a field for urls. :?

In the download you can read ,all html wil removed to protect that people can execute scripts on your server.
User avatar
neo_webbuilder
 
 
Posts: 79
Joined: Wed Jan 31, 2007 11:05 am

Post by neo_webbuilder »

maybe u know what to do...

Set page tot PHP and not to HTML

It's a PHP calendar with SQL !!!
User avatar
Eddy
 
 
Posts: 473
Joined: Tue Nov 27, 2007 1:52 am
Location: Nederland.

Post by Eddy »

joshuafrfld701 wrote:I did test with links but if I remove in the php what removes the html from links than I get strange things , With testing bbcodes did work but links not and I dont know how to change the php to make it work for links
Yes,I did also try to change that but did have the same problem.
I have also tested with an extra formfield for urls but no luck :?
User avatar
Eddy
 
 
Posts: 473
Joined: Tue Nov 27, 2007 1:52 am
Location: Nederland.

Post by Eddy »

Built with Extension Builder 2.0.2
bjlolmaugh
 
 
Posts: 63
Joined: Thu Nov 15, 2007 2:36 pm
Contact:

Post by bjlolmaugh »

Eddie ... I LOVE IT !!! I've been wanting this feature for a long time.
Thank you for doing such a good job and making it simple for people like me. :D
Sincerely,

Barbara Lolmaugh
http://www.websitesbybarbara.com
User avatar
Eddy
 
 
Posts: 473
Joined: Tue Nov 27, 2007 1:52 am
Location: Nederland.

Post by Eddy »

iggy81 wrote:Greate work Eddy ... thx

Is it posiblle to change language from english to croatian (months and days)?
I have no idea if thats possible. :?
I think you need also to change the charset in the pages?
There is no language file ,search for the file / file`s with the months and days and try what happens if you change the language..
User avatar
Eddy
 
 
Posts: 473
Joined: Tue Nov 27, 2007 1:52 am
Location: Nederland.

Post by Eddy »

I did seach in the source files but it looks that the month`s are generated from the database.
User avatar
randm
 
 
Posts: 36
Joined: Sat Oct 10, 2009 11:46 pm
Location: Ontario, Canada

Post by randm »

I have read the instructions for the PHP Calendar Basic - my question is about inserting a new folder through Site Manager. I want to put two separate event calendars on my site, on two different pages. Do I create a different folder for each calendar with one page in each folder, or do I create one calendar folder and include separate pages within the folder for each calendar. (I have already created a separate database for each calendar.)

Thanks in advance
User avatar
randm
 
 
Posts: 36
Joined: Sat Oct 10, 2009 11:46 pm
Location: Ontario, Canada

Post by randm »

Hi Eddy - I'm having a problem. I created the database on my server. Then I created one folder in my Site Manager and added a page to the folder called index.php. I inserted the calendar extension into that page, and published the folder/page. Then I went to www.mydomain.com/folder1/install.php and successfully installed everything. I also deleted the install.php file from my server.

But now I can't figure out how to access the calendar!! When I type www.mydomain.com/folder1/index.php into my browser, or when I link to that page, which holds the calendar extension, I'm getting redirected back to the install page again. I'm obviously missing something!
User avatar
randm
 
 
Posts: 36
Joined: Sat Oct 10, 2009 11:46 pm
Location: Ontario, Canada

Post by randm »

Hi Eddy - I'm having a problem. I followed your instructions, I think, the way I should have. I created the database on my server. Then I created one folder in my Site Manager and added a page to the folder called index.php. I inserted the calendar extension into that page, and published the folder/page. Then I went to www.mydomain.com/folder1/install.php and successfully installed everything. I also deleted the install.php file from my server.

But now I can't figure out how to edit the calendar. I can go to www.mydomain.com/folder/index.php and the calendar is there - but I can't do anything to it. How do I make entries to it?
User avatar
Eddy
 
 
Posts: 473
Joined: Tue Nov 27, 2007 1:52 am
Location: Nederland.

Post by Eddy »

Click on a date number to make a posting in the calendar.

If you have used the password option than you see first the login window before you can post something.

Original example calendar:
http://demos.kubelabs.com/php_calendar/
User avatar
randm
 
 
Posts: 36
Joined: Sat Oct 10, 2009 11:46 pm
Location: Ontario, Canada

Post by randm »

Thanks, Eddy!
User avatar
randm
 
 
Posts: 36
Joined: Sat Oct 10, 2009 11:46 pm
Location: Ontario, Canada

Post by randm »

Two problems: I have installed 3 calendars - all in separate folders with unique names and each with a unique page name - like indexone, indextwo, indexthree. Two of the installations succeeded - the third seemed to, but now I can't access the page at www.mydomain.com/foldername/indexthree.php I keep getting redirected to www.mydomain.com/foldername/install.php If I try to do the install again, it says I don't have access. I have made sure that I've deleted the install.php file, that my page is php, etc., but I'm obviously missing something. I even tried to delete the whole page and start over - but that didn't help either.

The second problem I'm having is that on the successful installs of calendars one and two, I'm not able to add events. The calendar appears on the page at www.mydomain.com/foldername/indexone.php, and when I click on a date I'm prompted with a username and password - which then brings up an add event dialog box. I insert info to add the event and submit - and it goes right back to the log in box . . . and nothing posts in the calendar. What's happening?
User avatar
Eddy
 
 
Posts: 473
Joined: Tue Nov 27, 2007 1:52 am
Location: Nederland.

Post by Eddy »

indexone.php wil not work because the php config etc files are searching for index.php

Make in the site manger three folders with different names and insert in every folder a page named: index

Make also three databases with different names otherwise you see in every calender the same entries.
User avatar
randm
 
 
Posts: 36
Joined: Sat Oct 10, 2009 11:46 pm
Location: Ontario, Canada

Post by randm »

OK, thanks Eddy, I'll try that. I have the three folders, and the separate databases with different names, so I think the problem must be that I've named the pages other than just index, so I'll fix that and see what happens.
User avatar
randm
 
 
Posts: 36
Joined: Sat Oct 10, 2009 11:46 pm
Location: Ontario, Canada

Post by randm »

Back again - still having problems. I finally deleted all but one calendar, even removing the folders and index pages for the other two from both WYSIWYG and my server through file manager. I now have just one calendar, on a page named index that's in a folder in Site Manager. I have not made any changes to the calendar as far as the properties because I was having unexpected results with that, too. And I still can't add any events! When I click on a date in the calendar, it opens a log-in box. I type in my username and password and submit, and an event entry box pops up. The date in it is old - Jan 1, 2008 - so I change the date to a date this coming week, add a test event and time and submit. And it goes right back to the log in box again. Nothing added to the calendar.

Another problem I've noticed - every time I re-publish my site, or the page, I have to go through the whole install process again. I'm sure it shouldn't work like that - should it? Will I lose all the events, then, every time I republish?

What am I doing wrong, please?
User avatar
Eddy
 
 
Posts: 473
Joined: Tue Nov 27, 2007 1:52 am
Location: Nederland.

Post by Eddy »

I type in my username and password and submit, and an event entry box pops up. The date in it is old - Jan 1, 2008 - so I change the date to a date this coming week, add a test event and time and submit.
That`s correct.
And it goes right back to the log in box again. Nothing added to the calendar.
In this page protectourlands did have the same problem,but I don`t know if he solved that. :?
viewtopic.php?t=19106&postdays=0&postorder=asc&start=15


From the pdf:
How to use in webbuilder.

Make first a database with name calendar or whatever name you like.

1. Insert a new folder to your website (in the Site Manager)
2. Add a page to this folder.
3. Insert the calendar extension to this page.
4. Name the calendar page index with the page extension php


5. Open the calendar in webbuilder and change the properties.
6. After uploading go to: http://www.your domain.com/foldername/install.php

After installing remove the file install.php from your server!


If you need to upload the page a second time than fill in the same database settings and all messages wil the same because all messages are stored in the database.
User avatar
Eddy
 
 
Posts: 473
Joined: Tue Nov 27, 2007 1:52 am
Location: Nederland.

Post by Eddy »

The time is resived from the databse.

Code: Select all

".addslashes($_POST['hour'].":".$_POST['minute'])."', 
I`am not a php coder I did only make a wrapper (extension) to insert the calendar in a webbuilder page.
WWBman
 
 
Posts: 916
Joined: Fri Jan 08, 2010 6:10 pm

Post by WWBman »

If I install Calendar into a subfolder e.g. /public_html/calendar will everything be contained in that folder and nothing will be put into root etc.? Thanks.
User avatar
Eddy
 
 
Posts: 473
Joined: Tue Nov 27, 2007 1:52 am
Location: Nederland.

Post by Eddy »

Yes, all files are in the calendar folder.

Open the site manager and insert a folder named calendar
Insert in that folder a page named index with page extension php.
Insert the extension on the index page in the folder.

Please read also the pdf.
WWBman
 
 
Posts: 916
Joined: Fri Jan 08, 2010 6:10 pm

Post by WWBman »

Great, thanks Eddy.
I have read the PDF file, I just wanted to check about where files go on the server. I'm a bit of a control freak! :-)
User avatar
etcbbu
 
 
Posts: 460
Joined: Mon Apr 23, 2007 3:00 pm

Re: PHP Calendar with MYSQL database

Post by etcbbu »

Eddy:

1) Will this calendar work in WB7?

2) And, does the page on which I want to place the calendar have to be named "index.php"?

Thanks.

--etcbbu
https://ktravisj.com

Travis J Consulting, LLC
⚫️Website Design/Development/Maintenance
⚫️Web-Marketing/Social Media
⚫️SEO/Search Engine Optimization

https://ktravisj.com
User avatar
etcbbu
 
 
Posts: 460
Joined: Mon Apr 23, 2007 3:00 pm

Re: PHP Calendar with MYSQL database

Post by etcbbu »

etcbbu wrote:Eddy:

1) Will this calendar work in WB7?

2) And, does the page on which I want to place the calendar have to be named "index.php"?

Thanks.

--etcbbu
https://ktravisj.com

Travis J Consulting, LLC
⚫️Website Design/Development/Maintenance
⚫️Web-Marketing/Social Media
⚫️SEO/Search Engine Optimization

https://ktravisj.com
User avatar
Patrik iden
 
 
Posts: 479
Joined: Wed Mar 24, 2010 9:07 pm
Location: Sweden

Re: PHP Calendar with MYSQL database

Post by Patrik iden »

Hi, I'm trying to translate this Calender in to Swedish. I located whare to change the name of the Days.
But whare do i change the mounth's?

How do i insert Swedish date/time format?

Regards.

Patrik Idén.
User avatar
v84x4
 
 
Posts: 102
Joined: Thu Sep 18, 2008 1:48 am
Contact:

Re: PHP Calendar with MYSQL database

Post by v84x4 »

Hey Eddy

All work fine with this extention
But whe I click on the month to change to a different month
i get redirected to the home page of the site

Any ideas what im doing wrong?

Link: http://www.highwaytrucker.com/bart/events.php

When I try to switch from Jan to Feb it takes me back to the home page of the main site......... :cry:

regards V8
God Bless

Re: PHP Calendar with MYSQL database

Post by God Bless »

FOR YOU WHO DON'T KNOW THE STEP BY STEP HOW TO MAKE THIS EXTENSION WORKS

JUST FOLLOW THIS STEP

1. STEP 1 ( CREATE FOLDER CALENDAR AND ADD PAGE INDEX.PHP )
Image

2. STEP 2 ( ADD EVENT CALENDAR IN INDEX.PHP AND PUBLISH IT )
Image

3. STEP 3 ( GO TO YOUR CPANEL AND FIND MYSQL )
Image

4. STEP 4 ( CREATE DATABASE CALENDAR IN MYSQL )
Image

5. STEP 5 ( CHANGE CONFIG.PHP IN FOLDER CALENDAR/INCLUDES )
Image

6. STEP 6 ( GO TO YOUR SITE FOR EXAMPLE : http://www.yoursite.com/calendar/install.php )
Image

7. STEP 7 ( DELETE INSTALL.PHP WITH YOUR FTP SOFTWARE )
Image

FINISH..........
THANKS TO EDDY FOR HIS GREAT CONTRIBUTION TO WWB
WE WILL ALWAYS SUPPORT YOU
User avatar
Patrik iden
 
 
Posts: 479
Joined: Wed Mar 24, 2010 9:07 pm
Location: Sweden

Re: PHP Calendar with MYSQL database

Post by Patrik iden »

Hi, the header img/color in Calander is not in mine. I onley get the bgr of my page Image
Jade Turtle
 
 
Posts: 8
Joined: Mon May 03, 2010 7:44 pm
Location: Kansas City, MO
Contact:

Re: PHP Calendar with MYSQL database

Post by Jade Turtle »

First, thanks to all who helped in creating a successful extension. I was able to follow the directions and install the Calendar. It works perfectly. BUT....I want it to sit on my home page, not on a separate page and I want it to have a smaller height and width. I went into the index.php file on the server and altered the height and width sizes and resaved it. No problems there.

Then I created an inline frame on my home page and hyperlinked it to the file on the server. The current month shows up fine when I publish my home page, but when I change to a different month, the calendar opens in on a separate page. What object or coding should I use to get the calendar to move between the different months while still on my home page.

Here is the link:

http://www.gaypridekc.com/Dev/Index.html

Thanks, Jade Turtle
Jade Turtle
 
 
Posts: 8
Joined: Mon May 03, 2010 7:44 pm
Location: Kansas City, MO
Contact:

Re: PHP Calendar with MYSQL database

Post by Jade Turtle »

First, thanks to all who helped in creating a successful extension. I was able to follow the directions and install the Calendar. It works perfectly. BUT....I want it to sit on my home page, not on a separate page and I want it to have a smaller height and width. I went into the index.php file on the server and altered the height and width sizes and resaved it. No problems there.

Then I created an inline frame on my home page and hyperlinked it to the file on the server. The current month shows up fine when I publish my home page, but when I change to a different month, the calendar opens in on a separate page. What object or coding should I use to get the calendar to move between the different months while still on my home page.

Here is the link:

http://www.gaypridekc.com/Dev/Index.html

Thanks, Jade Turtle
User avatar
BaconFries
 
 
Posts: 5366
Joined: Thu Aug 16, 2007 7:32 pm

Re: PHP Calendar with MYSQL database

Post by BaconFries »

@Jade Turtle the builder of the extension is no longer answering questions regarding this due to outside work commitments...as far as I know the extension cannot be made smaller it it designed to work as it is to be display on a page of its own...
User avatar
BaconFries
 
 
Posts: 5366
Joined: Thu Aug 16, 2007 7:32 pm

Re: PHP Calendar with MYSQL database

Post by BaconFries »

Hi ok it has been a while since I have used this extension before we had the content manager tool. How I used was to simply insert on new page by itself and gave a link to it from all pages of the site via the menu as you would only need one Calander with all the dates required to view by the users.If this isnt what you need then mabye this may help

Easy PHP Calendar
http://www.easyphpcalendar.com/

PHP Event Calendar
http://www.phpjabbers.com/php-event-calendar/
User avatar
Patrik iden
 
 
Posts: 479
Joined: Wed Mar 24, 2010 9:07 pm
Location: Sweden

Re: PHP Calendar with MYSQL database

Post by Patrik iden »

Hi, maybe i'v asked you befor but do you know how to change the time/date format. I whant Swedish format. Do you know What, How, Whare to edit and change?.
Thank you.

/Patrik.
User avatar
BaconFries
 
 
Posts: 5366
Joined: Thu Aug 16, 2007 7:32 pm

Re: PHP Calendar with MYSQL database

Post by BaconFries »

@Patrik iden as you may be aware "Eddy" is no longer a acrive member of the forum so he will not be able to reply to this...regarding what your asking this may just that the time/date is controlled by your servers location if it is in the USA then it will be using the date time from there so you may not be able to change this in the script as you have no control of this...if it can be changed then you should be able to do it with the PHP files that are used, I would take a look at them and see what can be done...
User avatar
Patrik iden
 
 
Posts: 479
Joined: Wed Mar 24, 2010 9:07 pm
Location: Sweden

Re: PHP Calendar with MYSQL database

Post by Patrik iden »

Hi, My server is in Sweden. Yes i have looked in the php files but i dont know how or what to change. I dont know how the date time code for swedish date/time looks like. Or wher to change it.
adex1
 
 
Posts: 167
Joined: Fri Apr 01, 2011 1:13 pm

Re: PHP Calendar with MYSQL database

Post by adex1 »

Has anybody try this calendar in WWB8?
Buy Automation Shopping Cart for CMS WEBSHOP + 2.2 Using WB10!
- Use secure gateway to buy using PAYPAL website.
User avatar
BaconFries
 
 
Posts: 5366
Joined: Thu Aug 16, 2007 7:32 pm

Re: PHP Calendar with MYSQL database

Post by BaconFries »

Please note that Eddy (the extension builder) is no longer active in the forum....why not just try the extension and se if it still works....
adex1
 
 
Posts: 167
Joined: Fri Apr 01, 2011 1:13 pm

Re: PHP Calendar with MYSQL database

Post by adex1 »

True. Don't mind me sometime I am too lazy to test of because time factor but now it work with vesrsion 8.
BaconFries wrote:Please note that Eddy (the extension builder) is no longer active in the forum....why not just try the extension and se if it still works....
Buy Automation Shopping Cart for CMS WEBSHOP + 2.2 Using WB10!
- Use secure gateway to buy using PAYPAL website.
Locked