Articles

How to edit, hide and protect a single sheet whilst also keeping other sheets hidden and protected

 Question:   Thanks for taking a look at this question, I can't seem to find a solution that fits my needs. I have a spreadsheet that has many individual sheets (sheet1,sheet2,sheet3...sheetx). Sheet1 must always be visible. Sheets 3,4,5....x must be hidden and protected such that they cannot be unhidden without unprotecting the workbook. Sheet 2 must be normally hidden and protected as above but with the option of editing it after entering a password. The process of hiding and unhiding this sheet must not allow the user to see or unhide sheets 3,4,5....x i.e the user must be able to hide,unhide and edit sheet 2 by use of a password but without ever allowing the user to see sheets 3,4,5,x etc. Thanks again for having a look at this. Charlie  Answers:   You can try hiding sheet 2 (right click --> hide) and then password protecting the workbook. But before that go to VBA and paste and run this: Sub HideSheets Wo...
Enregistrer un commentaire
Lire la suite

disable HTML when i echo a colomb

 Question:   hi users I have a table called profile it contains a colomb called info (TEXT) I use print"row[info]"; The problem is that some people enter HTML and javascript and when i use the echo it, everything shows they can even put their google ads too! How can i disable HTML thanks  Answers:   Try htmlentities() function <? echo htmlentities(row[info]); ?>
Enregistrer un commentaire
Lire la suite

Genrating a unique ID

Image
 Question:   Hello Friends, Is there any function in PHP which i can use for generating a unique ID? Thanks  Answers:   You can generate unique id's by applying this code, $RandomStr = md5(microtime());// md5 to generate the random string echo $ResultStr = substr($RandomStr,0,12);//trim 12 digit There is another way of creating a unique id First: you create a random number using this simple script Code: <?php $numb = rand(1,999999999); echo($numb); ?> Second: You check if the number exists. If it does not exist, then, you save the new number, else, you ask the user to refresh the page to create a different ID Ofcourse this way is a little mixed up, but it should work too Why not
Enregistrer un commentaire
Lire la suite

How to find a file is writable in PHP if it exists?

 Question:   Hello, Could you please tell me about how to find a file is writable in PHP if it exists?  Answers:   Look the details of is_writable() function in PHP manual. http://uk2.php.net/is_writable
Enregistrer un commentaire
Lire la suite

zend framework

 Question:   I am bit confused about whether to use any framework for my php development. have you used zend frame work? how to start on this framework? what are the advantages of this?  Answers:   check the official zend framework site. you will get answer to all your questions. http://framework.zend.com/ _________________
Enregistrer un commentaire
Lire la suite

http authontication with php

 Question: How can create a password protected area with PHP ?  Answers:   Check this php.net page: http://www.php.net/manual/en/features.http-auth.php
Enregistrer un commentaire
Lire la suite

A chat room problem php

 Question:   Hi there, I created a php chat room There is only one thing missing I dont know how to make the data show everytime someone types something I have to reload the page to see if anything is saved in the database, so it shows in the chat room i want to to be like a real chat room, everything shows when inserted by the user How can i do that, can be done in php  Answers:   Yes , you can create chat systems in PHP. You may be able to refresh the screen on regular intervals. You can use frames to refresh middle section. There are plenty of examples online. You can download one and see how it is done.
Enregistrer un commentaire
Lire la suite