Javascript help

jnich104 — Sun, 05 Sep 2010 22:23:37 GMT

Sorry new to javascript, i am created this script but i dont understand where i have gone wrong please help

Code:

 

  

  Untitled Document 

   

   

   

  

  

 

   

    

   
 

  
 

  Test

Query results to Excel

@script — Thu, 02 Sep 2010 16:35:26 GMT

Hi All,

Can anybody let me know the step by step process to write the query results which is generated by a java program to an excel file.

Thanks in advance.:)

How to fetch the exact height attribute of html divs in IE?

brightbill — Tue, 31 Aug 2010 12:54:47 GMT

I want to get the dynamic heights of some html divs. I am not programmatically applying height to them (so I don't know their values). If I fetch the height in mozilla I am able to fetch the exact value in px but in case of IE it gives "auto". How do I get their exact values? Please help

Javascript Display help please

jnich104 — Tue, 31 Aug 2010 12:25:41 GMT

I am trying to create a navigation system which when the bar is open and you click it, it will disappear, if it is closed then it appears.

This is my code

Javascript

Code:

function nav(a)

        {

                if(document.getElementById(a).style.display == 'block')

                        {

                                document.getElementById(a).style.display == 'none';

                        }

                                else

                        {

                                document.getElementById(a).style.display == 'block';

                        }

        }

Html

Code:

         

           

             
 the javascript is attacted to the page, and nothing happens when i click a button.


Please help
JQuery - Help Noobie
jnich104 — Sun, 29 Aug 2010 22:59:34 GMT
I am new to jquery, and i would like to know how to create something, where a div will close and another will side open kinda thing. like an animation thing please help.

 

Simple Utility
dsipos — Fri, 27 Aug 2010 19:44:36 GMT
Hello,



I am working to make a very very basic utility and am having trouble doing one action in the program. To explain what I am doing, I am making a utility to just simply open up programs that are located in the same folder as my executable.



In short I want to make a simple GUI program to open some install files for the game Oblivion. This utility is going to work as an executable on a cd to run the DLC  (downloaded content) install files.



I am working with VB 2010 Express.



Here is where I am having the trouble:



I understand that I can execute a file using the shell() command, however I don't want to provide a path as it could be located anywhere, the gui program that is. However instead I want it to search for the files its going to execute in the folder I place the exe into and then run them by clicking on the appropriate buttons.



I realize that this is extremely simple for most vb programmers, however, I am not very well versed in VB and my experience is in web programming, java, php, xhtml, etc..



If anyone cares to help please post a reply.

 

String Lengths
vbboard — Tue, 24 Aug 2010 21:50:12 GMT
Working with lengths of strings can come in handy very often. If you need to find how long a string is you can, or if you need to break a string down into parts, you can.



1. Open a new project

2. Add one textbox and Four buttons (excessive but I am breaking each thing down)

3. Name buttons (text AND name)

button1 = btnCountChars

button2 = btnFirstThree

button3 = btnSecondThree

button4 = btnLastThree

4. Double click your first button and add this


	Code:
	
Dim strLengthDemo As String = TextBox1.Text

MessageBox.Show(strlengthdemo.Length.ToString & " characters")
 -This code will show the length of strLengthDemo. You add the ToString part because integers could be added to the textbox.

5. Double click your second button and add this


	Code:
	
Dim strLengthDemo As String = TextBox1.Text

MessageBox.Show(strLengthDemo.Substring(0, 3))
 -This is giving visual basic a starting point and how many characters to grab.

-This will get the first three characters in your textbox

6. Double click your third button and add this


	Code:
	
Dim strLengthDemo As String = TextBox1.Text

MessageBox.Show(strLengthDemo.Substring(3, 3))
 -This will start after the third character and grab 3 more and display them within a messagebox

7. Double click your fourth button and add this


	Code:
	
Dim strLengthDemo As String = TextBox1.Text

MessageBox.Show(strLengthDemo.Substring(strLengthDemo.Length—3))
 -This tells visual basic to get the last three characters of your string.

8. Run your program (F5) and type in a 9 letter word. Or just 9 letters. Click each button to see how it works!



I will keep thinking of more beginner tuts soon enough. So keep waiting for them if you think I am helping.

 

Hello User Program
vbboard — Tue, 24 Aug 2010 21:49:08 GMT
Most people are used to the basic one button click "Hello World" tutorial. But today I am going to show you the little bit more advanced version called "Hello User"



First open up Visual Basic, I use the 2010 Express version which you can download at http://www.microsoft.com/express/downloads/



Go to File > New Project > Windows Forms Application and at the bottom name it "Hello User"



You should now have a blank "Form1" application. Click the grey area and in the bottom right corner you should see the properties box. Scroll to the text property and change it to what ever you want, probably "Hello User". Press enter and you will see the name of your form has changed, that is what the text property does.



Now, add a label control to your form from the toolbox.

Note: If you can't see the toolbox click Ctrl+Alt+X

Click the label and change the text property to "Enter your name"



Add a textbox control and move it under the label. This is where the user will enter their name into. Change the "Name" property to txtName.

Note: The name property is used to reference to the control in your code.



Add two button controls

1. Change the text property to "Ok" and the name property to "btnOk"

2.Change the text property to "Exit" and the name property to "btnExit"



Double click the Ok button and add the bolded code.

 
	Code:
	
Private Sub btnOK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOK.Click

        'displays a message box greeting to the user

        MessageBox.Show("Hello, " & txtName.Text & "! Welcome to VB 2010")

    End Sub
 Messagebox.show = Pops up a message box with whatever is in the parenthesis.

("Hello, " & txtName.Text & "! Welcome to VB 2010") = Will show as exactly what it says. txtName.text will get the text from your textbox control.

Ampersands(&) = connect what is in between the quotation marks and your code. There must be a blank space preceding it.



Return to your Design editor and double click the exit button

Once again, add the bolded code






	Code:
	
Private Sub btnExit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExit.Click

        Me.Close()

    End Sub
 Me = tells the program it will act upon itself

close = obviously close



Now go to File > Save All and browse to the folder you want to save it to. Then hit "F5" or the green button that says start debugging to start your program. Type a name and hit "ok" and tada, you get a lovely greeting to visual basic 2010. Now hit exit and it closes. If you want to get an exe file for your program go to Debug > Build. This will build it into the same place you saved it. It will be found in Bin > Release > Program.exe



Enjoy Everyone,

Zer[o]

 

Coding Practice
vbboard — Tue, 24 Aug 2010 21:47:39 GMT
This is information for the very beginner. These are random things that are good habits for new coders to pick up. None of these practices are mandatory but will help you and other people read your sources.

-If you have more good coding practices tell me and I will add them to this post!



1. Using a Name Prefix: When naming each of your controls it is always a good coding practice to give them a prefix and then name them according to what they do

(or a lot of the time their 'text' name). The prefix is always all lowercase letters. This helps you remember exactly what you are coding when you use your control.





Common Controls and Prefixes:

-Button = btn

-ComboBox = cbo

-CheckBox = chk

-Label = lbl

-ListBox = lst

-RadioButton = rdb

-PictureBox = pic

-TextBox = txt



Examples (if you don't get the idea):

-btnExit

-cboEmailProvider

-chkPasswordShow

-lblStatus

-lstFriends

ect



2. Using White Space and Grouping: Coders use white space to make their code easier to read and also organize it. Also, group things that have to do with eachother.



Bad:


	Code:
	
dim string1 as string = textbox1.text

dim string2 as string = textbox2.text

dim int1 as integer = numericupdown1.value

if string1.contains("blah") then

messagebox.show("blah")

else 

end if

if int1=12 then

messagebox.show("int1 = 12")

else

end if

if string2.contains("flubble") then

messagebox.show("flubble")

else

end if
 Good: 


	Code:
	
dim string1 as string = textbox1.text



if string1.contains("blah") then

messagebox.show("blah")

else 

end if



dim string2 as string = textbox2.text



if string2.contains("flubble") then

messagebox.show("flubble")

else

end if



dim int1 as integer = numericupdown1.value



if int1=12 then

messagebox.show("int1 = 12")

else

end if
 3. Comment things that may be confusing. Put a single quotation mark to start a comment (') and it will comment everything on the same line out. Use this for adding notes to your projects!



Commented Code (these are self explanatory but always useful with complex code):




	Code:
	
'Define String1 as a string to find the length of later

dim string1 as string = textbox1.text



'Find the last 3 characters of string1 and show them in a messagebox to the user

MessageBox.Show(string1.Substring(string1.Length—3)
 

 

Browse Folder Dialog
vbboard — Tue, 24 Aug 2010 21:43:57 GMT
Alright guys so I am going to show you how to create a browsefolderdialog. All this does it popup to the user and let them choose a folder.



For this you need:

1 Button

1 Textbox



Double click your button and add in the code:




	Code:
	
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click

        Dim BrowseFolder As New FolderBrowserDialog

        BrowseFolder.ShowDialog()

        TextBox1.Text = BrowseFolder.SelectedPath

    End Sub
 




	Code:
	
Dim BrowseFolder As New FolderBrowserDialog
 This defines BrowseFolder as your FolderBrowserDialog




	Code:
	
BrowseFolder.ShowDialog()
 This makes your FolderBrowserDialog pop-up to the user and lets them select their path




	Code:
	
TextBox1.Text = BrowseFolder.SelectedPath
 This sets your textbox1.text to what ever folder is selected.



After that you can do whatever you want with your selected folder.

 

Concatenation
vbboard — Tue, 24 Aug 2010 21:42:48 GMT
Concatenation is pretty much the addition of strings. This is frequently used in many programs and also a very simple concept.



Here is an example:

1. Open a new project

2. Add one button and two textboxes

3. Double click your button and add this code:

 
	Code:
	
 Dim strOne As String

        Dim strTwo As String

        strOne = TextBox1.Text

        strTwo = TextBox2.Text



        MessageBox.Show(strOne & " " & strTwo)
 Explanation:

-If you didn't know dim is the same thing as "define" it defines your variables. We defined two different strings here (strOne and strTwo).

-We then set each string equal to a textbox. It is set to textbox1/2.TEXT because you are setting it equal to what was entered into the textbox.

-After defining variables we use messagebox.show (pretty much a pop up which you can add extra functions but I will not use those) and we are making it show strOne, a space, and strTwo.

-Notice we use the ampersand (&). This is what you use to connect any variable with anything in quotes. We connect what ever strOne is equal to, a space (between quotes is the space), and what ever strTwo is equal to.

-Run your application (F5) and enter "Hello" in the first textbox and "Bob" in the second. click your button and a messagebox should pop up saying "Hello Bob"





Mess around with random uses like this until you get the hang of it. Then keep moving forward in your Visual Basic Career :P

 

MySQL & PHP (Messaging Service)
jnich104 — Sun, 15 Aug 2010 12:46:09 GMT
PHP


	Code:
	
mysql_select_db($MySQL_Name, $con);

        $mes = mysql_query("SELECT * FROM messages WHERE to='".$_SESSION[$prifix.'id']."'");



        while($res = mysql_fetch_array($mes))

          {

                 $result2 = mysql_query("SELECT * FROM accounts WHERE id = '".$res['from']."'");

                while($row2 = mysql_fetch_array($result2))

                  {

                          echo '


                                        

                                        

                                

                                

                                  

                                  

                                          ';

                  }

          }
 MySQL

	Code:
	
        id        to                from                subject                   message

        1        1                2                Test Message        1.2.3.4.5.6.7.8.9
 I am trying to create a messaging service, and i can't find whats wrong i have done the debugging i know and i checked it, re-written it 3 times, but i keep getting this error


error : 

	Code:
	
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\Web Server\www\Testing\Messaging\main.php on line 32
 That error is on the line which says

	Code:
	
while($res = mysql_fetch_array($mes))
 I can't find whats wrong please help, i have two users in the accounts database, and 1 message in the messages database.
CSS and id
sarah31 — Fri, 13 Aug 2010 03:55:46 GMT
Been a long time since I have been here. 



I am working on an CSS assignment and one of the rules is that we cannot use the "#" symbol. So far this has not been a problem as I have been able to just use classes and regular selectors (h2, etc). But I have come to these sections:




	Code:
	


  universal selector, *
 and:




	Code:
	


  font

  

    font-style = italic | oblique


    font-size = small | large


    font-variant = small-caps


  
 and I have to put a dashed 1px border around id i10 and i25. I just have not been able to figure out how to do it in the CSS without using the #.

 

Javascript and Php and MySQL
jnich104 — Mon, 09 Aug 2010 20:25:38 GMT
I am trying to create a way for javascript to get a result from PHP & MySQL from a database and show it on  the showing page.



Index.php


	Code:
	
















Max Age:  


Max W

PM: 




Sex: 








 ajax-example.php


	Code:
	

$dbhost = "localhost";

$dbuser = "";

$dbpass = "";

$dbname = "";

        //Connect to MySQL Server

mysql_connect($dbhost, $dbuser, $dbpass);

        //Select Database

mysql_select_db($dbname) or die(mysql_error());

        // Retrieve data from Query String

$age = $_GET['age'];

$sex = $_GET['sex'];

$wpm = $_GET['wpm'];

        // Escape User Input to help prevent SQL Injection

$age = mysql_real_escape_string($age);

$sex = mysql_real_escape_string($sex);

$wpm = mysql_real_escape_string($wpm);

        //build query

$query = "SELECT * FROM ajax_example WHERE ae_sex = '$sex'";

if(is_numeric($age))

        $query .= " AND ae_age <= $age";

if(is_numeric($wpm))

        $query .= " AND ae_wpm <= $wpm";

        //Execute query

$qry_result = mysql_query($query) or die(mysql_error());



        //Build Result String

$display_string = "


                                 

                                        Navigation

                                 


                                         

                                                Navigation

                                         


                                 

                                        Navigation

                                 


                                         

                                                Navigation

                                         


             



 








'.$res['subject'].'  
'.$$res['message'].' From : '.$row2['fullname'].'






 


";

$display_string .= "";

$display_string .= "";

$display_string .= "";

$display_string .= "";

$display_string .= "";

$display_string .= "";



        // Insert a new row in the table for each person returned

while($row = mysql_fetch_array($qry_result)){

        $display_string .= "";

        $display_string .= "";

        $display_string .= "";

        $display_string .= "";

        $display_string .= "";

        $display_string .= "";

        

}

echo "Query: " . $query . "
";

$display_string .= "Name Age Sex WPM
$row[ae_name] $row[ae_age] $row[ae_sex] $row[ae_wpm]
";

echo $display_string;

?>

Name	Age	Sex	WPM
$row[ae_name]	$row[ae_age]	$row[ae_sex]	$row[ae_wpm]

When i get this code finished i will be using it to create a instant chat room online, Please help

Navigation Navigation Navigation Navigation
'.$res['subject'].'
'.$$res['message'].'	From : '.$row2['fullname'].'

Code Forums

Javascript help

Query results to Excel

How to fetch the exact height attribute of html divs in IE?

Javascript Display help please

JQuery - Help Noobie

Simple Utility

String Lengths

Hello User Program

Coding Practice

Browse Folder Dialog

Concatenation

MySQL & PHP (Messaging Service)

CSS and id

Javascript and Php and MySQL