Monday, April 15, 2013
Search Music PHP
Search Music PHP
$link = mysqli_connect("localhost", "root", "", "musicbuydb");
if(mysqli_connect_errno()){
die(mysqli_connect_error());
}
$id = trim($_POST["txtmusicsearch"]);
echo $id;
$query = "select * from musictbl WHERE music_id = $id";
$res = mysqli_query($link,$query);
echo "
";
| Music Id | Music Name | Music Downloaded Times |
|---|
while($record = mysqli_fetch_assoc($res))
{
echo " ";
echo "
". $record['music_id'] ."
";
echo "
". $record['music_title'] ."
";
echo "
". $record['music_no_times'] ."
";
echo "
"; }
echo "
";?>
text Files:
https://www.box.com/s/w7snqebceufl1jn4saon
Search Music:
https://www.box.com/s/f7e1zqftdu09j3phb72f
Thursday, December 20, 2012
Twitch Tv Eve Online
Lately I have been streaming some Eve Online on my Twitch Channel: CapApollo Twitch Channel Come Check me out as I stream Mission Running and Answer any Questions in Chat. Come Hang out and follow me on Twitch as I run Missions and Listen to Music!
Here is a Link for a Free 21 Day Trial of EVE Online:
https://secure.eveonline.com/trial/?invc=7d956c46-392e-497b-ae6e-6f5011b409d9&action=buddy
Come join me and have some fun!
Here is a Link for a Free 21 Day Trial of EVE Online:
https://secure.eveonline.com/trial/?invc=7d956c46-392e-497b-ae6e-6f5011b409d9&action=buddy
Come join me and have some fun!
Thursday, September 20, 2012
Translink Addon
Check out the new Translink blog addon, located on the right hand side.
Use this to check out bus times for the Lower Mainland and Greater Vancouver Regions for bus schedules!
Use this to check out bus times for the Lower Mainland and Greater Vancouver Regions for bus schedules!
Sunday, July 1, 2012
Ventrilo and Minecraft Server!!!!!
Ventrilo Server Information (VoIP Server):
- Server name: Stasis
- IP/Address: 184.154.207.170
- Port: 44128
- Password: canada
Minecraft Server Connect using Hamachi:
- Download Hamachi : Download Hamachi UnManaged
- Run install Hamachi
- Network > Join Network:
- Network Id: davidslegit
- Password: packetstealer
- Hit Ok
- Open Minecraft
- Multiplayer
- add new server
- Server IP: 5.9.102.231
- Hit ok
- Connect
- Success you are now connected to the Minecraft Server.
Rules for Minecraft Server:
- No griefing!
- Don't ask for op!
- Optional: Join Ventrilo
Tuesday, June 12, 2012
Link for criteria sheet
Link to the file needed to attach to the routine letter assignment.
https://www.box.com/s/4a570c0d055bbd5052f0
Monday, April 16, 2012
btnDelete for ClientServers
Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click
Dim cmdStudent As New SqlCommand
Dim daStudent As New SqlDataAdapter
Dim dsStudent As New DataSet
Dim dtStudent As New DataTable
conn = GetConnect()
conn.Open()
cmdStudent = conn.CreateCommand
cmdStudent.CommandText = "Delete from UniversityStudent where Studentid = '" & Trim(txtSID.Text) & "'"
intcheck = cmdStudent.ExecuteReader.RecordsAffected
If intcheck > 0 Then
MsgBox("Record Deleted")
Else
MsgBox("No Records Deleted")
End If
conn.Close()
RefreshDataGrid()
End Sub
Client Servers Final Add Edit Delete
Client Servers Final Add Edit Delete:
http://www.box.com/s/bd7533e04f836df67075
http://www.box.com/s/bd7533e04f836df67075
Sunday, April 15, 2012
Thursday, April 12, 2012
asdjfioashdfuauipshfuiphas
use dchotel35
SELECT ResID, Arrival_Date, Departure_Date, RoomID
FROM Reservation
WHERE Eeservations.Arrival_Date > @dtpStart AND Reservations.Departure_Date < dtpEnd
ORDER BY RoomID
SELECT ResID, Arrival_Date, Departure_Date, RoomID
FROM Reservation
WHERE Eeservations.Arrival_Date > @dtpStart AND Reservations.Departure_Date < dtpEnd
ORDER BY RoomID
Wednesday, April 11, 2012
Wednesday, April 4, 2012
Sunday, March 18, 2012
Funny Guild Names
Here are some funny guild names:
- When In Doubt AFK Out
- Naga Stole My Bike
- Sapped Girls Cant Say No
- STDs are BOP
- Secret Squirrel Society
- Sorry babe, I'm on cooldown
- Teen Girl Squad
- YOU CANT COMPETE
- And two stealthed rogues
- Magically Malicious
- Just AFK Out
- Straight Outta Hillsbrad
- Dont You Peon Me
- AFK Getting Coffee
- AFK Till Expansion
- Seal Clubbers Clubbing Club
- Sorry were you questing
- Chucknorris is AFK in AV
- It Burns When I PVP
- We Are Not Disbanding
- Pie Vendors
- Forsaken Ate MyKodo
- Molten Core Swim Team
- I Farm or Family Dies
- AFK
- Ctrl Alt Elite
- Insert guild name here
- Invalid Target
- Power Word :DRUNK
- What would McGyver do?
- Guildless
- right click to attack
- Dyslexics Untied
- Set Sail for Fail
- Power Word: Awesome
- I Has A Bucket
- Resilience is Futile
- Stormwind Pizza Delivery
- no more guild invites
- the cake is a lie
- Potion Vendor
- Our Server Is Down
- We Have ADD and
- Gold Farmer
Friday, March 2, 2012
SQL - Port to SQL from Access 2010
Chapter 2 +3 Client Servers:
Create Database in SQL Server 2008
Port Access Database to SQL Server 2008
http://www.box.com/s/rb01llihjlg7sgtu8y19
Create Database in SQL Server 2008
Port Access Database to SQL Server 2008
http://www.box.com/s/rb01llihjlg7sgtu8y19
Monday, November 28, 2011
ETL Extract/Transform/Load
Example with 2 Dimension tables: Product Dimension, Seminar Dimension tables
Dim rsProduct As ADODB.Recordset
Dim rsSeminar As ADODB.Recordset
1. Extract Information From Tables using select Statement
Private Sub cmbExtract_Click
Dim cn As New ADODB.Connection
cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=" & CurrentProject.Path & "\NameofDatabaseBackEnd.accdb;"
Set rsProduct = New ADODB.Recordset
With rsProduct
Set .ActiveConnection = cn
.Source = "Select * From Product"
.CursorType = adOpenStatic
.Open
End With
Set rsSeminar = New ADODB.Recordset
With rsSeminar
Set .ActiveConnection = cn
.Source = "Select * from Seminar"
.CursorType = adOpenStatic
.Open
End With
Set cn = Nothing
Dim rsProduct As ADODB.Recordset
Dim rsSeminar As ADODB.Recordset
1. Extract Information From Tables using select Statement
Private Sub cmbExtract_Click
Dim cn As New ADODB.Connection
cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=" & CurrentProject.Path & "\NameofDatabaseBackEnd.accdb;"
Set rsProduct = New ADODB.Recordset
With rsProduct
Set .ActiveConnection = cn
.Source = "Select * From Product"
.CursorType = adOpenStatic
.Open
End With
Set rsSeminar = New ADODB.Recordset
With rsSeminar
Set .ActiveConnection = cn
.Source = "Select * from Seminar"
.CursorType = adOpenStatic
.Open
End With
Set cn = Nothing
End Sub
2. Transform the data (if need be/any) Then load the data into the new Data Warehouse:
(Set the connection to the Warehouse!!!)
Private Sub cmbTransform_Click()
Dim cnwh As New ADODB.Connection
cnwh.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=" & CurrentProject.Path & "\NameofDataWarehouse.accdb;"
Dim rsProductwh As ADODB.Recordset
Set rsProductwh = New ADODB.Recordset
Set rsProductwh.ActiveConnection = cnwh
Dim strInsert2 As String
rsProduct.MoveFirst
Do While Not rsProduct.EOF
strInsert2 = "insert into ProductDim (ProductNumber, Description, UnitPrice)" & _
" values ('" & rsProduct!ProductNumber & "','" & rsProduct!Description & "','" & rsProduct!Unitprice & "')"
rsProductwh.Open strInsert2
rsProduct.MoveNext
Loop
Set rsProductwh = Nothing
Dim rsSeminarwh As ADODB.Recordset
Set rsSeminarwh = New ADODB.Recordset
Set rsSeminarwh.ActiveConnection = cnwh
Dim strInsert3 As String
rsSeminar.MoveFirst
Do While Not rsSeminar.EOF
strInsert3 = "insert into SeminarDim (SeminarDate, SeminarTime, Location, Title)" & _
" values ('" & rsSeminar!SeminarDate & "','" & rsSeminar!SeminarTime & "','" & rsSeminar!Location & "','" & rsSeminar!SeminarTitle & "')"
rsSeminarwh.Open strInsert3
rsSeminar.MoveNext
Loop
Set cnwh = Nothing ' close the connection
Set rsSeminarwh = Nothing
End Sub
Labels:
Data Warehouse,
Dimension Tables,
ETL,
Extract,
Form Load,
Transform
VBA (Visual Basic) Coding for Databases
Posting of Database Coding Review
Set connection to Back end database:
Dim cn As New ADODB.Connection
cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=" & CurrentProject.Path & "\NameofDatabase.accdb;"
Set connection to Back end database:
Dim cn As New ADODB.Connection
cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=" & CurrentProject.Path & "\NameofDatabase.accdb;"
Write the Select Statement to get data:
Dim rsName As ADODB.Recordset ' put this at top
Set rsName = New ADODB.Recordset
With rsName
Set .ActiveConnection = cn
.Source = "Select * From TableName"
.LockType = adLockOptimistic
.CursorType = adOpenStatic
.Open
End With
Fill text boxes on Form with data retrieved:
With rsName
If Not (.EOF) Then
.Find strcriteria
Me.txtTransactionID = !transactionid
Me.txtDateAcquired = !DateAcquired
Me.txtAcquisitionPrice = !AcquisitionPrice
Me.txtAskingPrice = !AskingPrice
Me.txtDateSold = !datesold
Me.txtSalesPrice = !salesprice
End If
End With
Example of Form Load where lsTransaction (Listbox) is filled with transaction ID, Date Acquired and artwork ID:
Dim rsTransactions As ADODB.Recordset
Private Sub Form_Load()
Dim cn As New ADODB.Connection
cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=" & CurrentProject.Path & "\VRG+Art+BE.accdb;"
Set rsTransactions = New ADODB.Recordset
With rsTransactions
Set .ActiveConnection = cn
.Source = "Select * from GalleryTransactions"
.LockType = adLockOptimistic
.CursorType = adOpenStatic
.Open
End With
Do While (Not rsTransactions.EOF)
Me.lsTransactions.AddItem rsTransactions![transactionid] & ", " & rsTransactions![DateAcquired] & ", " & rsTransactions![artworkid]
rsTransactions.MoveNext
Loop
rsTransactions.MoveFirst
Set cn = Nothing
End Sub
Friday, January 29, 2010
Update!!!
Well as you can all see I have not had the time to post here, since I am a dedicated World of Warcraft player, if anyone plays my name is Badunkadunk on the Bladefist Server. I am a Shadow/Disc Priest on the Alliance side, I'm the night elf.
With this upcoming update I'd like to post some guides and tips on leveling characters and making gold.
With this upcoming update I'd like to post some guides and tips on leveling characters and making gold.
Subscribe to:
Posts (Atom)