Jump to content

crispytown

Members
  • Posts

    11
  • Joined

  • Last visited

    Never

Contact Methods

  • Website URL
    http://phpclanwebsite.com

Profile Information

  • Gender
    Not Telling

crispytown's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I really like pspad app. it is solid and does everything that I like and need to do. it isn't a WYSIWYG editor.... but call me old fashion. I love my text editors to program with. Plus with pspad you can do more then just web stuff. It can do VB, C++, Cobal, VB, VBscript, Java, INI files, and tons more. About 29 different ones. and the ability to add more custom ones. With 8 different types of DBs. Free of course.
  2. I have been playing with AJAX and php for the past few weeks. I love it. I am willing to help out if you need some more help on this. I will of course help spread the word of the site if anything. But I will help out more if you need me.
  3. That is browser releated. I have a form in my new forum that I am working on... and when I go back it shows me the post that i typed in again. I use FX..... i didn't check IE to see how that works. but i don't like useing IE.
  4. Here is some help for you. This tutorial is based on cPanel and phpmyadmin tool. check this out as it will help you get things going by useing your server admin panel from your hosting package. http://www.php-editors.com/articles/sql_phpmyadmin.php
  5. I jsut grab a little bit for a script that i am working on... but here is your script modded with my function. [!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--][span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]require_once([/span][span style=\"color:#DD0000\"]\'Connections/il_db.php\'[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]?> <?php mysql_select_db[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$database_il_db[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$il_db[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]$query_blog [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"SELECT blog_date, blog_title, blog_text, blog_author FROM blog WHERE blog_active = 1 ORDER BY blog_id DESC\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]$blog [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_query[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$query_blog[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$il_db[/span][span style=\"color:#007700\"]) or die([/span][span style=\"color:#0000BB\"]mysql_error[/span][span style=\"color:#007700\"]()); [/span][span style=\"color:#0000BB\"]$row_blog [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_fetch_assoc[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$blog[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]$totalRows_blog [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_num_rows[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$blog[/span][span style=\"color:#007700\"]); function [/span][span style=\"color:#0000BB\"]builddatetime[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$date_time[/span][span style=\"color:#007700\"]) { [/span][span style=\"color:#0000BB\"]$year[/span][span style=\"color:#007700\"]=[/span][span style=\"color:#0000BB\"]substr[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$date_time[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]0[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]4[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]$month[/span][span style=\"color:#007700\"]=[/span][span style=\"color:#0000BB\"]substr[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$date_time[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]4[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]2[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]$day[/span][span style=\"color:#007700\"]=[/span][span style=\"color:#0000BB\"]substr[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$date_time[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]6[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]2[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]$hour[/span][span style=\"color:#007700\"]=[/span][span style=\"color:#0000BB\"]substr[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$date_time[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]8[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]2[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]$min[/span][span style=\"color:#007700\"]=[/span][span style=\"color:#0000BB\"]substr[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$date_time[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]10[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]2[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]$sec[/span][span style=\"color:#007700\"]=[/span][span style=\"color:#0000BB\"]substr[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$date_time[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]12[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]2[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]$str[/span][span style=\"color:#007700\"]=[/span][span style=\"color:#0000BB\"]date[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\"Y/m/d H:i:s\"[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]mktime[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$hour[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]$min[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]$sec[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]$month[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]$day[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]$year[/span][span style=\"color:#007700\"])); return [/span][span style=\"color:#0000BB\"]$str[/span][span style=\"color:#007700\"]; } [/span][span style=\"color:#0000BB\"]?>[/span]<!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=iso-8859-1\" /> <title>Untitled Document</title> </head> <body> [span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]do { [/span][span style=\"color:#0000BB\"]?> [/span] <p>[span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]echo [/span][span style=\"color:#0000BB\"]$row_blog[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'blog_title\'[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]?>[/span]</p> <p>[span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]echo [/span][span style=\"color:#0000BB\"]$row_blog[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'blog_text\'[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]?>[/span]</p> <p>[span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]echo [/span][span style=\"color:#0000BB\"]$row_blog[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'blog_author\'[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]?>[/span]</p> <p>[span style=\"color:#0000BB\"]<?php $blog_date_time [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$row_blog[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'blog_date\'[/span][span style=\"color:#007700\"]]; if (!empty([/span][span style=\"color:#0000BB\"]$blog_date_time[/span][span style=\"color:#007700\"])){ [/span][span style=\"color:#0000BB\"]$blog_date_time2 [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]builddatetime[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$blog_date_time[/span][span style=\"color:#007700\"]); echo [/span][span style=\"color:#0000BB\"]$blog_date_time2[/span][span style=\"color:#007700\"]; } [/span][span style=\"color:#0000BB\"]?> [/span] </p> <hr width=\"80%\" align=\"center\" /> [span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]} while ([/span][span style=\"color:#0000BB\"]$row_blog [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_fetch_assoc[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$blog[/span][span style=\"color:#007700\"])); [/span][span style=\"color:#0000BB\"]?>[/span]</body> </html> [span style=\"color:#0000BB\"]<?php mysql_free_result[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$blog[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]?>[/span] [/span][!--PHP-Foot--][/div][!--PHP-EFoot--] this variable "row_data_grab" is for my script. you needed to modify that for your mysql_fetch_assoc ... It is editted above so that should work for you now.
  6. [!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--] function builddatetime($date_time) { $year=substr($date_time,0,4); $month=substr($date_time,4,2); $day=substr($date_time,6,2); $hour=substr($date_time,8,2); $min=substr($date_time,10,2); $sec=substr($date_time,12,2); $str=date(\"Y/m/d H:i:s\", mktime($hour,$min,$sec,$month,$day,$year)); return $str; }[/span][!--PHP-Foot--][/div][!--PHP-EFoot--] Try this function. It will convert date and time over to the format you wanted. An example of use.... [!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--][span style=\"color:#0000BB\"]<?php $post_date_time [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$row_data_grab[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'post_date_time\'[/span][span style=\"color:#007700\"]]; if (!empty([/span][span style=\"color:#0000BB\"]$post_date_time[/span][span style=\"color:#007700\"])){ [/span][span style=\"color:#0000BB\"]$post_date_time2 [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]builddatetime[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$post_date_time[/span][span style=\"color:#007700\"]); echo [/span][span style=\"color:#0000BB\"]$post_date_time2[/span][span style=\"color:#007700\"]; } [/span][span style=\"color:#0000BB\"]?>[/span] [/span][!--PHP-Foot--][/div][!--PHP-EFoot--]
  7. What is your mysql table structure like? This is how I would do this personaly. I changed your code a little bit to fit into what I would do. [!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--][span style=\"color:#0000BB\"]<?php $id[/span][span style=\"color:#007700\"]=[/span][span style=\"color:#0000BB\"]$_GET[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'id\'[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$q [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"SELECT * FROM players WHERE id=\'$id\'\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]$result [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_query[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$q[/span][span style=\"color:#007700\"]) or die ([/span][span style=\"color:#DD0000\"]\"Could not execute query : $q.\" [/span][span style=\"color:#007700\"]. [/span][span style=\"color:#0000BB\"]mysql_error[/span][span style=\"color:#007700\"]()); [/span][span style=\"color:#0000BB\"]$view [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_fetch_array[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$result[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]MYSQL_ASSOC[/span][span style=\"color:#007700\"]); if (empty([/span][span style=\"color:#0000BB\"]$view[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'id\'[/span][span style=\"color:#007700\"]])) { print [/span][span style=\"color:#DD0000\"]\"No such player.\"[/span][span style=\"color:#007700\"]; include([/span][span style=\"color:#DD0000\"]\"footer.php\"[/span][span style=\"color:#007700\"]); exit; }[/span] [/span][!--PHP-Foot--][/div][!--PHP-EFoot--]
  8. Try this out ... [!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--][span style=\"color:#0000BB\"]<?php $id[/span][span style=\"color:#007700\"]=[/span][span style=\"color:#0000BB\"]$_GET[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'id\'[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$q[/span][span style=\"color:#007700\"]=[/span][span style=\"color:#DD0000\"]\"SELECT * FROM players WHERE id=\'$id\'\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]$view [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_fetch_array[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]mysql_query[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$q[/span][span style=\"color:#007700\"]) or die ([/span][span style=\"color:#DD0000\"]\"Could not execute query : $q.\" [/span][span style=\"color:#007700\"]. [/span][span style=\"color:#0000BB\"]mysql_error[/span][span style=\"color:#007700\"]())); if (empty ([/span][span style=\"color:#0000BB\"]$view[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'id\'[/span][span style=\"color:#007700\"]])) { print [/span][span style=\"color:#DD0000\"]\"No such player.\"[/span][span style=\"color:#007700\"]; include([/span][span style=\"color:#DD0000\"]\"footer.php\"[/span][span style=\"color:#007700\"]); exit; }[/span] [/span][!--PHP-Foot--][/div][!--PHP-EFoot--]
  9. check out this project. http://www.uniformserver.com/ it seems to be alive again. I used it to base on my test bed. It is small and has a lot of stuff built in for a small webserver that can run anywhere. they are worthy to look at. never know they might give you an idea on who to do yours.
  10. On line 7 of your view.php file there should be a mysql query statement. It is not currect. Check that statement in phpmyadmin or a different mysql query tool. The reason could be a few different ones without looking at your code. 1. a variable might not be getting set... you you might want to check each with isset() function to make sure it was set. 2. you misspelled your fields titles or have the where condition out of wack.
  11. yes this can be done. I have made a small webserver that runs from my usb pendrive. and it has apache/mysql/php4 and 5 both/ssh/ftp/perl and a few more things. it is only about 25mb after unpacking from rar. I can plug my pen drive into any pc that runs windows and have a full webserver in 15 seconds or less. never timed it. but it runs on any pc no matter the pc name or what drive the pc calls it. Very strong and powerful. So what you want to do can be done.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.