Jump to content
xisto Community

leiaah

Members
  • Content Count

    437
  • Joined

  • Last visited

Posts posted by leiaah


  1. I've redesigned my website - from graphics to the CSS layouting. I was planning on a website that would look personal not commercial, with a home-cooked feel. I ended up with a pretty simple and straightforward design. I'm afraid it looks a bit packaged now, kinda like what you'd get with ready-made blogs out there. I'm making a layout number 3 but I'm sticking with this one for a while if I get not-too-terrible reviews, heehee.Anyways, I feel like I'm writing my own review here :lol: So what do you guys think?Thanks in advance. :)


  2. I'm listening to Someone still loves you Boris Yeltsin. Yes, it's the name of a cool band. I just discovered this band by accident while following some link on some guys blog.They released their album "Pershing" last month and I've been loving them ever since :lol:My fave songs off the album:Trk 1. Glue Girls, Trk 7. Think I wanna die (super catchy-pop!), Trk 10. HeersGo check them out!


  3. My new laptop is running on Vista and installing Apache, MySql and PHP was hell. I've tried googling for tutorials on how to get the services working but still nothing.It was after a few days of tweaking the php.ini and httpd.conf which all amounted to nothing when someone recommended WAMP, a software that installs all 3 applications to machines that run on Windows. I thought there would be problems with Vista but surprisingly I didn't get any. I don't have to configure the php.ini anf httpd.conf and all 3 are working fine now. So yeah, go get WAMP especially if you machine runs on Vista. I'm planning on installing XP on my machine but I'll probably still use WAMP for it since it's easier ^_^


  4. Ooh! I love Total Video Converter! Aside from the formats supported by this software which zer000s has listed, it can create Photos Slide Show which pretty much allows you to well, make slide shows with the background audio of your choice (it does all the transition from pic to pic). Coincidentally, only 15 minutes ago I uploaded a video on youTube created using Total Video Converter' Photos Slide Show and the quality, I thought, was awesome. I love it! Ooh! and I use it for converting videos to 3gp or mp4 formats for my phone also. :P^_^


  5. You can use the SQL statement for creating a table. Jlhaslip posted the code below. You simply need to change the tablename to the name you want (users to table1).

    CREATE TABLE `users` (`name` varchar(20) collate latin1_general_ci NOT NULL,`date` datetime NOT NULL,`message` varchar(100) collate latin1_general_ci NOT NULL,PRIMARY KEY (`name`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;


  6. I made templates so it would be easier for me to create PHP pages with database connectivity

     

    To insert data into a table (assuming you've already created a database with a table called table1)

    <?php	$name=$_POST['name'];	  $msg=$_POST['msg'];  	  $date = date('Y-m-d , h:i:s',time()); 	  $name = addslashes($name);	  $msg = addslashes($msg);	  @ $db = mysql_pconnect('localhost', 'username', 'password');	if (!$db)	  {	 		echo 'Error: Could not connect to database.  Please try again later.';	 		exit;	  }	  mysql_select_db('databasename');  	  $query = "insert into table1(name,date,message) values ('".$name."', '".$date."','".$msg."')"; 	  $result = mysql_query($query);	  	if ($result)			  echo  'Entry has been Posted.'; ?>

    To view data from a database table

    <?php	@ $db = mysql_pconnect('localhost', 'username', 'password');	if (!$db)	  {	 		echo 'Error: Could not connect to database.  Please try again later.';	 		exit;	  }	  mysql_select_db('databasename');  	  $query=mysql_query("SELECT name,date,message FROM table1");	while($row=mysql_fetch_row($query)){		echo "Name: ". $row[0]."<br>";		echo "Date: ". $row[1]."<br>";		echo "Message: ". $row[2]."<br>";	}?>

    Hope this helped! <_<


  7. I just got a compaq presario. I guess it's okay. It's one of the relatively cheap ones being sold here in the Philippines. It has a dual core processor, 1gb of memory, but only 80 gb of HD space though but I plan on buying an external because they're very cheap now, so yeah. Acer also has relatively cheap ones too, you might want to check them out. Anyways, good luck :o


  8. Try this one. The while statement continually queries in the database while there are query results then prints the results in the screen using echo.

     

    if( isset( $_POST['selectsort'] )) {	$query = "SELECT * FROM contracts ORDER BY '{$_POST['selectsort']}' DESC";	$result = mysql_query($query);	while($result_rows = mysql_fetch_row($result)){		echo 'field 1 value: '.$result_rows[0];		echo 'field 2 value: '.$result_rows[1];		echo 'field 3 value: '.$result_rows[2];	}}

  9. Something like this perhaps (assuming your query is correct)..

    $result = mysql_query("SELECT placing_item_bid.category_id, category_master.icon_1FROM school_auction.category_master,school_auction.placing_item_bidWHERE placing_item_bid.category_id=category_master.category_id and category_master.icon_1=category_master.icon_1");while($row=mysql_fetch_row($result)){	$img=$row['icon_1'];			echo '<img name="runimg" src="images/'. $img .'">';}


  10. I've always wanted to go to Europe because of its history and geography. I want to visit France, Italy, England, the Czech Republic, and if there's more money Ireland. I'm sure I'll have a grand time eating food in these regions (pizza, pasta, fish and chips, etc) and visiting historic places as well. We don't have any castles and suspended bridges and trains here in the Philippines and I have a thing for medieval stuff to so yeah, I want to go somewhere in Europe with preferably a digital SLR camera with a huge memory.


  11. Growing up I used to play ping pong (table tennis) with my brother. Nothing serious but I did won first place in our school's intramurals. :lol: I haven't held a ping pong racket for a long time since I've been recently addicted to BADMINTON. I love it and being a somewhat competitive person you sort of get a rush when you hit the shuttlecock just right into your opponent's side of the court.I also watch football and my favorite team has always been Manchester United with David Beckham as my favorite player. He was bought by Real Madrid and now LA Galaxies but he remains my favorite. Also Christiano Ronaldo and Solskjaer (don't know if I spell this right). GO UNITED!!!!


  12. The last book I've read was Night of Rain and Stars by Maeve Binchy. I bought it at a book sale when I was on vacation a few weeks ago. I like it, it's about four strangers who met in an island in Greece. Well anyways, it's nice..just the genre I enjoy and it's the last book that completed my Maeve Binchy collection (I now have 15 maybe 16 of her books, whoopee!~)


  13. Thanks for the info. I'm sure the pay is not that much here in the Philippines but I know some people who do freelance things on the Internet with international clients and so they get paid dollars.Anyways, I'm currently a systems programmer and implementor. I get a bit stressed out with my work and I'm thinking of doing some web design/development on the side after my 9 to 5. I've always liked it and I find it more liberating than doing business applications. I just have to have a proper time table now and some multivitamins ('coz I tire out easily, for some reasons). :)


  14. Does anyone know how to import .unl files into SQLServer 2000? My boss gave me this task to migrate an old database into SQLServer. I don't have informix installed since the files were sent to me via email. All files have .unl extension and I don't have a clue how to view them. I've tried opening them using excel but it can't be read. Does anyone know how to do this? Or at least know how to open/view the file using excel or any other program that could be easily migrated to sqlserver? Please, I need to migrate the files as soon as possible. Thanks very much.

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | 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.